• Material
  • Fabric
  • Bootstrap
  • Bootstrap v4
  • High Contrast
Preferences
Theme Selection
Mode Selection
Touch
Mouse
Localization
*Translated by Google Translator.
Currency

Example of Create in ASP.NET MVC XlsIO Control

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

Click the "Create Document" button to view the created Excel document. Please note that the Microsoft Excel viewer or Microsoft Excel is required to view the Excel 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