Implementation:

• Read / Write: Read and write Microsoft Excel files
• Versions: Read and write all version of Excel from Office 97 forward
• Object model: Full-fledged object model comparable to Microsoft Office Excel automation model
• 100% managed code: Built from scratch in C#; does not use COM interop
• No dependency on Excel: Can be used on systems without Excel

SpreadSheet Creation:

• Multiple worksheets: Create a workbook with multiple worksheets
• Templates: Create workbooks from templates (existing workbooks)
• Text Formatting: Set or change the color, type, size, style of font in a cell
• Number Formats: Display fractions, percentages, currency and date formats in a cell
• Shading Cells: Shade cells with solid colors or patterns
• Merge/UnMerge Cells
• Group/UnGroup Cells: Group/ungroup rows and columns
• Styles: Apply complex formatting using styles
• Named Ranges: Create/manipulate named ranges
• Formula support: Use predefined Excel functions and custom formulas
• Modify spreadsheet: Read and modify existing spreadsheets

Features

• Charts: Create charts using provided API
• Worksheet protection: Lock/unlock spreadsheets with passwords
• Pictures: Insert pictures into spreadsheets
• Streams: Open spreadsheets from streams and save them back to streams
• Macro support: Read macros and preserve them on re-saving
• Conditional formatting
• Data Validation
• Rich Text: Insert rich text into cells
• Comments: Insert cell comments

• Stream to Browser: Stream created spreadsheets to browser clients

• Full-fledged Excel reporting - Create Excel reports from scratch or by using templates. Most Excel formatting is supported. There is also advanced support for reading and writing formulas and the manipulation of work sheets
• Easy API transitioning - Essential XLSIO is not constrained by dependency on Microsoft Office. When using Essential XLSIO to create or read Excel files, there is no need to have Microsoft Excel installed
• Unparalleled Technical Support and Extensibility - Syncfusion Essential XLSIO comes with 60 days of support and updates. After this period you can purchase an annual subscription to maintain access to technical support and stay current with the latest updates
• Support for Syncfusion products is available through our Direct-Trac support system. Support is also available by email and phone. Direct-Trac is a developer support system that is uniquely tailored for developer needs. Support incidents can be created and tracked to completion 24 hours a day, 7 days a week
• Syncfusion Essential XLSIO’s source code version comes with full source code. Unlike other components on the market, which offer unsupported source code in a zip file, Syncfusion Essential XLSIO offers complete integration of the source code with the product. XLSIO offers the ability to step into the source code directly from your application with the Assembly Manager technology. Syncfusion offers support and extension hints with reference to the source code

Essential XLSIO Main Page