 Quick Start | Description | Source |
| Creating a Simple Spreadsheet | A simple empty spreadsheet is created in this sample. |   |  |
| Introducing Styles | This sample introduces the usage of styles in formatting a spreadsheet. | | |
| Formulas | This sample introduces the usage of formulas in XlsIO | | |
| Grouping Rows and Columns | This sample demonstrates the method of grouping Rows/Columns using XlsIO. | | |
| Named Ranges | This sample demonstrates the usage of Named Ranges. | | |
| Opening an existing spreadsheet | This sample demonstrates the method of modifying an existing spreadsheet. | | |
| Read Formula | This sample demonstrates reading formulas from a spreadsheet. | | |
| Autofit Rows and Columns | This sample demonstrates the method for Autofitting Rows and Columns. | | |
| Ranges and Cells | This sample introduces the usage of Ranges and cells to insert data into a spreadsheet. | | |
| Formatting | Description | Source |
| Alignment Settings | This sample demonstrates the Alignment settings for the text inside a Cell which includes Text orientation,Text direction, Text alignment, Merging cells, Wraping text and Indent level. | | |
| Color Pallete | This Sample demonstrates how custom colors can be added to the workbook's color palette. | | |
| Font Settings | This Sample demonstrates XlsIO's support for setting font styles. | | |
| Number Formattings | This Sample demonstrates the Number Formatting using XlsIO. | | |
| Pattern Settings | This Sample demonstrates Pattern Settings for cells which include Pattern types and Pattern colors. | | |
| DataManipulations | Description | Source |
| Named Ranges | This sample demonstrates the usage of Named Ranges. | | |
| Range Manipulations | This Sample demonstrates the various methods to acess a range. | | |
| Conditional Formatting | Description | Source |
| Write Conditional Formatting | This Sample demonstrates Writing Conditional formatting using XlsIO. | | |
| Read Conditional formatting | This Sample demonstrates how to Read the Conditional Formatting applied to a spreadsheet using XlsIO. | | |
| AutoFilter | Description | Source |
| Write Autofilter | This Sample demonstrates the Writing of Autofilters using XlsIO. | | |
| Rich Text | Description | Source |
| Write Rich text | This sample demonstrates XlsIO's support for writing rich text . | | |
| Comments | Description | Source |
| Write Comments | This sample demonstrates XlsIO's support for writing both plain text and rich text comments. | | |
| Read Comments | This sample demonstrates the method of Reading both plain text and rich text comments from template Spreadsheet using XlsIO. | | |
| Data Validation | Description | Source |
| Write Data validation | This sample demonstrates setting of the data validation using XlsIO. | | |
| Chart | Description | Source |
| Create Chart Worksheet | This Sample demonstrates the Adding a chart as Separate worksheet to a workbook using XlsIO. | | |
| Edit Chart | This Sample demonstrates the Editing of Charts in a Spreadsheet using XlsIO. | | |
| Embedded Chart | This Sample demonstrates the Embedded Chart using XlsIO. | | |
| Template Markers | Description | Source |
| Template Marker | This sample demonstrates the usage of TemplateMarkers in XlsIO. This is another variant of the Template based approach but the difference is that the end user places special markers in the template spreadsheet which get replaced with data during runtime.
| | |
| SpreadSheetML | Description | Source |
| SpreadSheetML | This Sample demonstrates XlsIO's support for reading and writing XML files. | | |
| Hyperlinks | Description | Source |
| Read Hyperlinks | This sample demonstrates XlsIO's support for reading hyperlinks in a spreadsheet. | | |
| Write Hyperlinks | This sample demonstrates XlsIO's support for writing hyperlinks. | | |
| Security | Description | Source |
| Cell protection | This Sample demonstrates the protection of cells using XlsIO. | | |
| Unlocking | This Sample demonstrates unlocking of the Worksheet using XlsIO. | | |
| Worksheet protection | This Sample demonstrates the protection of Worksheet using the password. | | |
| Encryption and Decryption | This sample demonstrates how a workbook can be encrypted and decrypted with password. | | |
| Images | Description | Source |
| Write Images | This sample demonstrates the method of inserting an image into a spreadsheet using XlsIO. | | |
| Spreadsheet Property settings | Description | Source |
| Document Properties | This Sample demonstrates how to set Document properties using XlsIO. | | |
| Header and Footer | This Sample demonstrates Setting of Header and Footer using xlsIO. | | |
| Margins | This Sample demonstrates the Setting of Margins using XlsIO. | | |
| Page Setup | This sample demonstrates XlsIO's support for Page setup. | | |
| Worksheet manipulations | Description | Source |
| Copy Worksheets | This Sample demonstrates copying a sheet from one Workbook and adding it to another. | | |
| Hide and Unhide rows and columns | This Sample demonstrates Hiding and Unhiding of Rows and Columns using XlsIO. | | |
| Insert rows and columns | This Sample demonstrates inserting new rows and columns to a spreadsheet using XlsIO. | | |
| Page Break | This Sample demonstrates XlsIO's support for Page break. | | |
| Row Height and Column width | This Sample demonstrates setting the Rows Height and Columns Width using XlsIO. | | |
| Stream Support | Description | Source |
| Open from Stream | This Sample demonstrates Opening a file from a stream using XlsIO. | | |
| Save to Stream | This Sample demonstrates saving to a stream using XlsIO. | | |
| Excel2007 Support | Description | Source |
| Export to Excel97-2003 | This sample demonstrates the Essential XlsIO support for creating Excel97 to 2003 files from Excel 2007 file with various formattings. | | |
