- SmartXLS is a high performance .NET component which can write, read, calculate Excel compatible files without the need for Microsoft Excel on either the developer or client machines. It was entirely written in 100% managed C# code.
SmartXLS for .Net provides the following features:
- Import data into excel Worksheet from DataTable.
- Export excel worksheet data to DataTable.
- CSV files (delimited with comma, tab, semicolon or any other separator).
- XLSX/XLSM reading / writing (Excel2007-Excel2016 openxml format).
- Encrypte/Decrypt Excel files(xls and xlsx).
- Template support (create new workbooks using existing workbook as a template).
- Multiple worksheets per file.
- Various cell data types (numbers, strings,dates, floating point etc.).
- Custom number formatting.
- Merged regions.
- Cell styles (alignment, indentation, rotation, borders, shading, protection, text wrapping and shrinking etc.).
- Font formatting (size, color, font type, italic and strikeout properties, different levels of boldness, underlining, subscript and superscript).
- formatting options(font,color,content format,pattern,border line,border color,align).
- Copy/Move/Delete(Cells can be copied, moved and deleted).
- Row height and column width.
- Formula support (absolute and relative references, names, 3D cell references, more than 260 supported functions).
- Named ranges(Names can be used where you want. Access cells through their name is easy).
- Supports Formula Calculations using robust Formula Calculation (Cells and whole worksheets can be calculated).
- Formulas with references to external workbooks are supported as well.
- Set Print Options(print area,print margins,print header/footer,page break etc).
- Rich Text: Insert rich text into cells.
- Conditional formatting.
- Comments: Insert cell comments.
- Charts(Supports all standard Chart Types like Column, Bar, Line, Pie, Scatter etc,Customize Charts by setting their different properties).
- Create Excel pivot table from scratch.
- Macro support: Read macros and preserve them on re-saving.
- Written in 100% managed code.
- Unicode support.
- Supporting asp. Net Medium trust level.
- Mono support (works on Unix/Linux/OsX machines with Mono).
2.Custom function/VBA function.