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.

Create

• Design Your Spreadsheets
  • Create Spreadsheets
  • Duplicate Worksheets
  • Set Your Worksheet Position
  • Set The Active Worksheet
• Customize Your Spreadsheets with Ease
  • Add Rows and Columns
  • Group Rows and Columns
  • Set Workbook Metadata

Save and Export

• Export Worksheet Formats
  • Save Your Files as CSV, XML, XLSX and More
  • Margins and Borders
  • Import and Export as DataSet

Edit Workbooks

• Visually Represent Your Data
  • Add, Remove, and Extract Images Within Workbooks
  • Create and Edit Informative Charts
• Edit The Layout
  • Add a Freeze Pane
  • Autosize Your Rows and Columns
  • Set Custom Cell Fonts
  • Set Cell Borders and Alignment
  • Add Backgrounds To Cells
  • Create Conditional Formatting
• Working With Cells
  • Set Cell Data Format
  • Select and Manipulate Ranges
  • Sort Cell Ranges
  • Trim Cell Ranges
  • Clear Cell Content
  • Copy Cells
  • Add Hyperlinks to Your Cells
  • Merge and Unmerge Your Cells

Working With Data

• Using Formulas
  • Editing Formulas
  • Retrieve Formula Results
• Working With Math Functions
  • Averages
  • Sum
  • Min
  • Max

Secure Your Workbooks

• Add Passwords
  • Add Passwords to Your Workbooks
  • Encrypt Your Worksheets