IronXL Features

• Load, Read and Edit Data - from XLS/XLSX/CSV/TSV
• Saving and Exporting - to XLS/XLSX/CSV/TSV/JSON
• System.Data Objects - Work with Excel Spreadsheets as System.Data.DataSet and System.Data.DataTable objects.
• Formulas - Works with Excel formulas. Formulas are recalculated every time a sheet it edited.
• Ranges - Easy to use WorkSheet["A1:B10"] syntax. Combine and create ranges intuitively.
• Sorting - Sort Ranges, Columns and Rows.
• Styling - Cell visual styles Font, Size, Background pattern, Border, Alignment and Number formats.

Workbooks

• Create or Load Spreadsheets:
  • XLS
  • XLSX, XSLT, XLSM
  • CSV
  • TSV
• Save or Export Formats:
  • XLS
  • XLSX, XSLT, XLSM
  • CSV
  • TSV
  • JSON
  • HTML
  • Binary
  • Byte Array
• System.Data Objects:
  • Import and export as DataSet or DataTable
• Edit Workbooks:
  • Metadata
  • Permissions & Passwords
  • Create and Remove Worksheets
  • Set Sheet Position
  • Set Active Tab

Worksheets

• Edit Formulas:
  • Works with Excel formulas
  • Recalculation on sheet edit
• Sort Data:
  • Range
  • Column
  • Row
• Create and Edit Charts:
  • Area, Bar, Column, Lines, Pie, Scatter
• Edit Layout:
  • Freeze Panes
  • Autosize Rows/Columns
  • Add and Remove Rows/Columns
• Edit Worksheets:
  • Duplicate Worksheets
  • Protect with Password
  • Group and Ungroup
  • Add, Remove, and Extract Images

Cell Ranges

• Cell Range Functions:
  • Sort
  • Trim
  • Clear
  • Copy
  • Find and Replace
  • Set Hyperlinks
  • Merge and Unmerge Cells
• Style Cells:
  • Font and Size
  • Border and Alignment
  • Background Pattern
  • Conditional Formatting
• Maths Functions:
  • Average and Sum
  • Min and Max
• Set Cell Data Formats:
  • Text, Number, Formula, Date, Currency, Scientific, Time, Boolean, Custom Formats