• Material
  • Fabric
  • Bootstrap
  • High Contrast
Preferences
Theme Selection
Mode Selection
Touch
Mouse

Chart

This sample demonstrates how to create a simple Excel document with formulas and formatting using XlsIO.
DEMO
SOURCE

Click the button to view the Excel Spreadsheet generated by Essential XlsIO. Please note that Microsoft Excel Viewer or Microsoft Excel is required to view the resultant document.


Save As :
      

Essential XlsIO 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.

Features:

  • 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