À propos de IronXL for Python via .NET

Lisez, modifiez et créez des fichiers de feuille de calcul Excel sans avoir besoin d'une interopérabilité avec Microsoft Office ou Excel.

IronXL for Python via .NET is a Python Excel library for generating and editing Excel documents. You can read and edit XLS/XLSX/CSV/TSV and save an export to XLS/XLSX/CSV/TSV/JSON. Its user friendly API allows developers to add Excel functionality to Python projects in minutes.

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