This sample demonstrates how to create a simple Excel document with formulas and formatting using Excel (XlsIO) Library.
has support for creating richly formatted spreadsheets from scratch independent of Excel. Advanced features, like data validation, conditional formatting, charts, pivot tables are also supported. This sample demonstrates the creation of a simple, multi-sheet workbook. Formats like Excel 97-2003, Excel 2007, Excel 2010, Excel 2013, Excel 2016, CSV, SpreadsheetML, Excel 2007 Template, and Excel 2007 Macro Enabled Template are supported and demonstrated here.
In this sample, a new instance of XlsIO is created. This instance has no open workbooks. A workbook is created with the IWorkbook
interface. This workbook has one worksheet by default and number of worksheets can be created based on the need. The IRange
interface can be used to access the cell and write the content.
- Create workbooks from scratch in various file formats such as, .xls, .xlsx, .csv, .xml, .xltx, .xltm
- Create more numbers of sheets
- Write text in range of cells