IronXL for .NET

Lesen und bearbeiten Sie Excel Spreadsheets in C#, ohne dass MS Office oder Excel Interop benötigt werden.

Veröffentlicht von Iron Software
Wird von ComponentSource seit 2017 vertrieben

Preise ab: $ 734.02 Version: 2024.x NEU Letzte Aktualisierung: Apr 4, 2024 5.00 Stern Durchschnittliche Bewertung5.00 Stern Durchschnittliche Bewertung5.00 Stern Durchschnittliche Bewertung5.00 Stern Durchschnittliche Bewertung5.00 Stern Durchschnittliche Bewertung (2)

Screenshot von IronXL for .NET

Über IronXL for .NET

Lesen und bearbeiten Sie Excel Spreadsheets in C#, ohne dass MS Office oder Excel Interop benötigt werden.

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. 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.

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