Sobre o IronXL for .NET

Uma biblioteca .NET para ler, gravar e manipular arquivos do Excel sem exigir o Microsoft Office.

IronXL for .NET allows developers to read, generate and edit Excel (and other Spreadsheet files) in .NET applications and websites. You can read and edit XLS/XLSX/CSV/TSV and save an export to XLS/XLSX/CSV/TSV/JSON. It works well with .NET Framework, .NET Core and Azure. It is a great solution for data analysis and reporting, providing fast and scalable spreadsheet automation. All without extra dependencies or the need to install MS Office.

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