IronXL for .NET

Leggi e modifica i fogli di calcolo Excel in C# senza necessità di Microsoft Office o dell'interoperabilità Excel.

Pubblicato da Iron Software
Distribuito da ComponentSource dal 2017

Prezzi da: $ 734.02 Versione: 2024.x NUOVO Aggiornato il: Apr 4, 2024 Media stelle Recensioni: 5.00Media stelle Recensioni: 5.00Media stelle Recensioni: 5.00Media stelle Recensioni: 5.00Media stelle Recensioni: 5.00 (2)

Schermata di IronXL for .NET

A proposito di IronXL for .NET

Leggi e modifica i fogli di calcolo Excel in C# senza necessità di Microsoft Office o dell'interoperabilità Excel.

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