À propos de IronXL for .NET

Une bibliothèque .NET pour la lecture, l'écriture et la manipulation des fichiers Excel sans passer par 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