Sample Codes List
- Workbooks
-
Read/Write xls/csv file. [C# Source] [VB.Net Source] [Java Source] Read/Write xlsx/xlsm file. [C# Source] [VB.Net Source] [Java Source] Read spreadsheet xml file. [C# Source] [VB.Net Source] Import Data Array to WorkBook. [C# Source] [VB.Net Source] Encrypt/Decrypt Excel97-2003 xls file. [C# Source] [VB.Net Source] [Java Source] Encrypt/Decrypt Excel2007-2010 xlsx file. [C# Source] [VB.Net Source] [Java Source] Setting Calculation Options. [C# Source] [VB.Net Source] [Java Source]
- WorkSheets
-
Add/Remove sheet. [C# Source] [VB.Net Source] [Java Source] Copy & Move Worksheets. [C# Source] [VB.Net Source] [Java Source] Hide/Unhide sheet. [C# Source] [VB.Net Source] [Java Source] Freeze Panes. [C# Source] [VB.Net Source] [Java Source] Page Break Preview. [C# Source] [VB.Net Source] [Java Source] Display/Hide sheet options [C# Source] [VB.Net Source] [Java Source] Worksheet protection. [C# Source] [VB.Net Source] [Java Source] Row Height & Column Width. [C# Source] [VB.Net Source] [Java Source]
- Cell Data
-
Find & Replace cell content. [C# Source] [VB.Net Source] [Java Source] Importing data to worksheet. [C# Source] [VB.Net Source] Exporting data from worksheet. [C# Source] [VB.Net Source] Data Filter. [C# Source] [VB.Net Source] [Java Source] Formulas. [C# Source] [VB.Net Source] [Java Source] Formulas Calculation with external workbook. [C# Source] [VB.Net Source] [Java Source] Hyperlinks. [C# Source] [VB.Net Source] [Java Source] Named Ranges. [C# Source] [VB.Net Source] [Java Source] Data Sorting. [C# Source] [VB.Net Source] [Java Source] Data Validation. [C# Source] [VB.Net Source] [Java Source] Add Row/Column Outlines. [C# Source] [VB.Net Source] [Java Source] Range Manipulation. [C# Source] [VB.Net Source] [Java Source] Iterator all cell's data in the workbook. [C# Source] [VB.Net Source] [Java Source]
- Cell Formatting
-
Number Formatting. [C# Source] [VB.Net Source] [Java Source] Alignment Setting. [C# Source] [VB.Net Source] [Java Source] Font Setting. [C# Source] [VB.Net Source] [Java Source] Border Setting. [C# Source] [VB.Net Source] [Java Source] Pattern Setting. [C# Source] [VB.Net Source] [Java Source] Conditional Formatting. [C# Source] [VB.Net Source] [Java Source] Merge/Unmerge Range. [C# Source] [VB.Net Source] [Java Source] Rich Text Formatting. [C# Source] [VB.Net Source] [Java Source] Text Wrapping. [C# Source] [VB.Net Source] [Java Source]
- Printing Setting
-
Setting Print Page. [C# Source] [VB.Net Source] [Java Source] Setting Print Margins. [C# Source] [VB.Net Source] [Java Source] Setting Print Header/Footer. [C# Source] [VB.Net Source] [Java Source] Setting Print Sheet. [C# Source] [VB.Net Source] [Java Source] Setting Page Break. [C# Source] [VB.Net Source] [Java Source]
- Drawings & Charts
-
Adding Pictures. [C# Source] [VB.Net Source] [Java Source] Adding Comments. [C# Source] [VB.Net Source] [Java Source] Adding DropDown. [C# Source] [VB.Net Source] [Java Source] Adding CheckBox. [C# Source] [VB.Net Source] [Java Source] Adding TextBox. [C# Source] [VB.Net Source] [Java Source] Create Chart. [C# Source] [VB.Net Source] [Java Source] Create Chart Sheet. [C# Source] [VB.Net Source] [Java Source]
- Pivot Table & Pivot Chart
-
Pivot table. [C# Source] [VB.Net Source] [Java Source] Pivot chart. [C# Source] [VB.Net Source] [Java Source] Pivot table with external data source. [C# Source] [VB.Net Source] [Java Source]