 Quick Start | Description | Source |
| Creating a Simple Spreadsheet | A simple empty spreadsheet is created in this sample. |   |  |
| Importing DataTable | This code snippet demonstrates importing a DataTable into a spreadsheet. | | |
| Import Array | This samples demonstrates the usage of ImportArray method. | | |
| Named Ranges | This sample demonstrates the usage of Named Ranges. | | |
| Opening an existing spreadsheet | This sample demonstrates the method of modifying an existing spreadsheet. | | |
| Printing the created Spreadsheet | This sample demonstrates the process of printing the Excel file after creation. | | |
| Deleting Data | This sample demonstrates the method for deleting data from spreadsheets. | | |
| 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. | | |
| Introducing Styles | This sample introduces the usage of styles in formatting a spreadsheet. | | |
| Formulas | This sample introduces the usage of formulas in XlsIO. | | |
| Merging Cells | This sample demonstrates the method of merging cells using XlsIO. | | |
| Grouping Rows and Columns | This sample demonstrates the method of grouping Rows/Columns using XlsIO. | | |
| Print Settings | This sample demonstrates the method of setting print setting to the workbook. | | |
| Worksheet Manipulation | Description | Source |
| CopyWorksheetToAnotherWorkbook | This Sample demonstrates copying a sheet from one Workbook and adding it to another. | | |
| FindReplace | This Sample demonstrates XlsIO's support for 'Find and Replace' feature. | | |
| Freezepane | This Sample demonstrates XlsIO's support for Freezing panes. | | |
| HideUnhideRowsandColumns | This Sample demonstrates Hiding and Unhiding of Rows and Columns using XlsIO. | | |
| InsertRowsandColumns | This Sample demonstrates inserting new rows and columns to a spreadsheet using XlsIO. | | |
| PageBreak | This Sample demonstrates XlsIO's support for Page break. | | |
| RowHeightandColumnWidth | This Sample demonstrates setting the Rows Height and Columns Width using XlsIO. | | |
| Range Manipulation | Description | Source |
| Range Manipulation | This sample demonstrates the various methods to access a range. | | |
| Data Manipulation | Description | Source |
| ImportExportDataTable | This Sample demonstrates exporting excel contents to grid and importing grid contents to excel. | | |
| Formatting | Description | Source |
| AlignmentSettings | This sample demonstrates the Alignment settings for the text inside a Cell which includes Text orientation,Text direction, Text alignment, Merging cells, Wrapping text and Indent level. | | |
| BorderSettings | This Sample demonstrates the Border Settings for the cells which includes Border LineStyles and Border Color | | |
| FontSettings | This Sample demonstrates XlsIO's support for setting font styles. | | |
| GlobalStyles | This sample demonstrates XlsIO's Global styles which can be used when a style is to be applied to many cells. | | |
| NumberFormatting | This Sample demonstrates the Number Formatting using XlsIO. | | |
| PatternSettings | This Sample demonstrates Pattern Settings for cells which include Pattern types and Pattern colors. | | |
| Conditional Formatting | Description | Source |
| ReadConditionalFormatting | This Sample demonstrates how to Read the Conditional Formatting applied to a spreadsheet using XlsIO. | | |
| WriteConditionalFormatting | This Sample demonstrates Writing Conditional formatting using XlsIO. | | |
| Autofilters | Description | Source |
| WriteAutofilters | This Sample demonstrates the Writing of Autofilters using XlsIO. | | |
| Charts | Description | Source |
| ChartWorksheet | This Sample demonstrates the Adding a chart as Separate worksheet to a workbook using XlsIO. | | |
| EditCharts | This Sample demonstrates the Editing of Charts in a Spreadsheet using XlsIO. | | |
| EmbeddedChart | This Sample demonstrates the Embedded Chart using XlsIO. | | |
| SecondaryAxisChart | This sample demonstrates how to display the secondary axis visible. Note that to draw secondary axis, you should have minimum two series and one of the series should reset the primary axis using UsePrimaryAxis. | | |
| LegendSettings | This sample demonstrates how to hide the legend using XlsIO. | | |
| Formatting ChartDataLabel | This sample demonstrates formatting the chart datalabel using font style, size, Border style and with colors. | | |
| ChartDataTable | This sample demonstrates how the datatable can be included in the chart. | | |
| Comments | Description | Source |
| ReadComments | This sample demonstrates the method of Reading both plain text and rich text comments from template Spreadsheet using XlsIO. | | |
| WriteComments | This sample demonstrates XlsIO's support for writing both plain text and rich text comments. | | |
| Data Validation | Description | Source |
| ReadDataValidation | This Sample demonstrates reading the values in datavalidation list. | | |
| WriteDataValidation | This sample demonstrates setting of the data validation using XlsIO. | | |
| Rich Text | Description | Source |
| ReadRichText | This sample demonstrates XlsIO's support for reading rich text. | | |
| WriteRichText | This sample demonstrates XlsIO's support for writing rich text . | | |
| Security | Description | Source |
| CellsProtection | This Sample demonstrates the protection of cells using XlsIO. | | |
| Unlocking | This Sample demonstrates unlocking of the Worksheet using XlsIO. | | |
| WorksheetProtection | 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. | | |
| Spreadsheet Property Settings | Description | Source |
| DocumentProperties | This Sample demonstrates how to set Document properties using XlsIO. | | |
| HeaderFooter | This Sample demonstrates Setting of Header and Footer using xlsIO. | | |
| Margins | This Sample demonstrates the Setting of Margins using XlsIO. | | |
| PageSetUp | This sample demonstrates XlsIO's support for Page setup. | | |
| Hyperlinks | Description | Source |
| ReadHyperlinks | This sample demonstrates XlsIO's support for reading hyperlinks in a spreadsheet.
| | |
| WriteHyperlinks | This sample demonstrates XlsIO's support for writing hyperlinks. | | |
| Formulas | Description | Source |
| ArrayFormula | This sample demonstrates the usage of array formulas in XlsIO. | | |
| ExcelFunctions | This sample demonstrates XlsIO's support for built in Excel functions. | | |
| Images | Description | Source |
| ReadImage | This sample demonstrates the method of extracting an Image from a spreadsheet using XlsIO.
| | |
| WriteImages | This sample demonstrates the method of inserting an image into a spreadsheet using XlsIO.
| | |
| Styles | Description | Source |
| ColorPalette | This Sample demonstrates XlsIO's support for Customizing Color palettes. | | |
| Streams Support | Description | Source |
| OpenFromStream | This Sample demonstrates Opening a file from a stream using XlsIO. | | |
| SaveToStream | This Sample demonstrates saving to a stream using XlsIO. | | |
| Template Markers | Description | Source |
| Template Markers | 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 |
| ReadWriteSpreadsheetML | This Sample demonstrates XlsIO's support for reading and writing XML files. | | |
| Excel2007Support | 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 formatting. | | |
| Export to Excel 2007 | This sample demonstrates Essential XlsIO support for creating Excel 2007 file from scratch with simple styles and formatting. | | |
