  %20-107C10?logo=visualstudio)       [](https://ironsoftware.com/python/excel/?utm_source=nuget&utm_medium=organic&utm_campaign=readme&utm_content=topshield#helpscout-support)
# IronXL - The Python Excel Library
[](https://ironsoftware.com/python/excel/?utm_source=nuget&utm_medium=organic&utm_campaign=readme&utm_content=topbanner#trial-license)
[Get Started](https://ironsoftware.com/python/excel/docs/?utm_source=nuget&utm_medium=organic&utm_campaign=readme&utm_content=navigation) | [Features](https://ironsoftware.com/python/excel/features/?utm_source=nuget&utm_medium=organic&utm_campaign=readme&utm_content=navigation) | [Code Examples](https://ironsoftware.com/python/excel/examples/read-excel/?utm_source=nuget&utm_medium=organic&utm_campaign=readme&utm_content=navigation) | [Licensing](https://ironsoftware.com/python/excel/licensing/?utm_source=nuget&utm_medium=organic&utm_campaign=readme&utm_content=navigation) | [Free Trial](https://ironsoftware.com/python/excel/docs/?utm_source=nuget&utm_medium=organic&utm_campaign=readme&utm_content=navigation#trial-license)
IronXL is a library developed and maintained by Iron Software that helps Software Engineers to read, generate and edit Excel (and other Spreadsheet files) in Python applications & websites.
IronXL is a fast and natural approach to work with Excel and Other Spreadsheet files in Python. With no utilization of Office Excel Interopm IronXL works well with Python. All without extra dependencies or the need to install MS Office.
### IronXL excels at:
- Import Data from XLS/XLSX/CSV/TSV.
- Export Work Sheets to XLS/XLSX/CSV/TSV/JSON.
- Encrypt and decrypt XLSX/XLSM/XLTX files with passwords.
- Work with Spreadsheets as System.Data.DataSet and System.Data.DataTable objects.
- Excel Formulas recalculated every time a sheet it edited.
- Intuitive Ranges setting with a WorkSheet["A1:B10"] syntax.
- Sort Ranges, Columns and Rows.
- Style Cells - Font, Size, Background pattern, Border, Alignment and Number formats.
#### Document Formats
- Load, Read and Edit Data: XLS, XLSX, XLST, XLSM, CSV and TSV
- Saving and Exporting: XLS, XLSX, XLST, XLSM, CSV, TSV and JSON
- System.Data Objects: Work with Excel Spreadsheets as System.Data.DataSet and System.Data.DataTable
#### Sheet Functions
- Formulas: Works with Excel formulas and formulas recalculated every time a sheet it edited
- Cell Data Formats: Text, Number, Formulas, Dates, Currency, Percentage, Scientific, Time and Custom Formats
- Sorting: Ranges, Columns and Rows
- Cell Styling: Font, Size, Background pattern, Border and Alignment
### IronXL has cross platform support compatibility with:
- Python 3.7+
- Windows, macOS, Linux, Docker, Azure, and AWS
[](https://ironsoftware.com/python/excel/docs/?utm_source=nuget&utm_medium=organic&utm_campaign=readme&utm_content=crossplatformbanner)
Additionally, our [API reference](https://ironsoftware.com/python/excel/object-reference/api/) and [full licensing information](https://ironsoftware.com/python/excel/licensing/#trial-license) can easily be found on our website.
### Using IronXL
***
IronXL Python relies on .NET 6.0 as its underlying technology. Therefore, it is necessary to have the .NET 6.0 runtime installed on your machine in order to use IronXL Python.
Linux and Mac users may need to install .NET from https://dotnet.microsoft.com/en-us/download/dotnet/6.0 prior to using this Python package.
### Install Using Pip
```
pip install ironxl
```
IronPDF will then download additional dependencies the first time you run it.
### Or Download the Full Package
Optionally, download the Python package specific to your platform from our downloads section at https://ironxl.com/python/
### Usage
Once installed, you can get started by adding `from ironxl import *` to the top of your Python script. Here is an example to get started:
```python
from ironxl import *
workbook = WorkBook("test.xlsx")
print(workbook.WorkSheets.Count)
```
## Features Table
[](https://ironsoftware.com/python/excel/features/?utm_source=nuget&utm_medium=organic&utm_campaign=readme&utm_content=featuresbanner)
## Licensing & Support available
For code examples, tutorials and documentation visit [https://ironsoftware.com/python/excel/](https://ironsoftware.com/python/excel/?utm_source=nuget&utm_medium=organic&utm_campaign=readme&utm_content=supportanddocs)
For support please email us at support@ironsoftware.com
## Documentation Links
- Code Examples : [(https://ironsoftware.com/python/excel/examples/](https://ironsoftware.com/python/excel/examples/read-excel/?utm_source=nuget&utm_medium=organic&utm_campaign=readme&utm_content=supportanddocs)
- API Reference : [https://ironsoftware.com/python/excel/object-reference/api/](https://ironsoftware.com/python/excel/object-reference/api/?utm_source=nuget&utm_medium=organic&utm_campaign=readme&utm_content=supportanddocs)
- Tutorials : [https://ironsoftware.com/python/excel/tutorials/how-to-read-excel-file-python/](https://ironsoftware.com/python/excel/tutorials/how-to-read-excel-file-python/?utm_source=nuget&utm_medium=organic&utm_campaign=readme&utm_content=supportanddocs)
- Licensing : [https://ironsoftware.com/python/excel/licensing/](https://ironsoftware.com/python/excel/licensing/?utm_source=nuget&utm_medium=organic&utm_campaign=readme&utm_content=supportanddocs)
- Live Chat Support : [https://ironsoftware.com/python/excel/#helpscout-support](https://ironsoftware.com/python/excel/?utm_source=nuget&utm_medium=organic&utm_campaign=readme&utm_content=supportanddocs#helpscout-support)
You can email us at support@ironsoftware.com for support directly from our code team. We offer licensing and extensive support for commercial deployment projects.
Raw data
{
"_id": null,
"home_page": "https://ironxl.com/",
"name": "IronXL",
"maintainer": null,
"docs_url": null,
"requires_python": "<4,>=3.7",
"maintainer_email": null,
"keywords": null,
"author": "Iron Software",
"author_email": "developers@ironsoftware.com",
"download_url": null,
"platform": null,
"description": "  %20-107C10?logo=visualstudio)       [](https://ironsoftware.com/python/excel/?utm_source=nuget&utm_medium=organic&utm_campaign=readme&utm_content=topshield#helpscout-support)\r\n\r\n# IronXL - The Python Excel Library\r\n\r\n\r\n[](https://ironsoftware.com/python/excel/?utm_source=nuget&utm_medium=organic&utm_campaign=readme&utm_content=topbanner#trial-license)\r\n\r\n[Get Started](https://ironsoftware.com/python/excel/docs/?utm_source=nuget&utm_medium=organic&utm_campaign=readme&utm_content=navigation) | [Features](https://ironsoftware.com/python/excel/features/?utm_source=nuget&utm_medium=organic&utm_campaign=readme&utm_content=navigation) | [Code Examples](https://ironsoftware.com/python/excel/examples/read-excel/?utm_source=nuget&utm_medium=organic&utm_campaign=readme&utm_content=navigation) | [Licensing](https://ironsoftware.com/python/excel/licensing/?utm_source=nuget&utm_medium=organic&utm_campaign=readme&utm_content=navigation) | [Free Trial](https://ironsoftware.com/python/excel/docs/?utm_source=nuget&utm_medium=organic&utm_campaign=readme&utm_content=navigation#trial-license)\r\n\r\nIronXL is a library developed and maintained by Iron Software that helps Software Engineers to read, generate and edit Excel (and other Spreadsheet files) in Python applications & websites.\r\n\r\nIronXL is a fast and natural approach to work with Excel and Other Spreadsheet files in Python. With no utilization of Office Excel Interopm IronXL works well with Python. All without extra dependencies or the need to install MS Office.\r\n\r\n### IronXL excels at:\r\n- Import Data from XLS/XLSX/CSV/TSV.\r\n- Export Work Sheets to XLS/XLSX/CSV/TSV/JSON.\r\n- Encrypt and decrypt XLSX/XLSM/XLTX files with passwords.\r\n- Work with Spreadsheets as System.Data.DataSet and System.Data.DataTable objects.\r\n- Excel Formulas recalculated every time a sheet it edited.\r\n- Intuitive Ranges setting with a WorkSheet[\"A1:B10\"] syntax.\r\n- Sort Ranges, Columns and Rows.\r\n- Style Cells - Font, Size, Background pattern, Border, Alignment and Number formats.\r\n\r\n#### Document Formats\r\n- Load, Read and Edit Data: XLS, XLSX, XLST, XLSM, CSV and TSV\r\n- Saving and Exporting: XLS, XLSX, XLST, XLSM, CSV, TSV and JSON\r\n- System.Data Objects: Work with Excel Spreadsheets as System.Data.DataSet and System.Data.DataTable\r\n\r\n#### Sheet Functions\r\n- Formulas: Works with Excel formulas and formulas recalculated every time a sheet it edited\r\n- Cell Data Formats: Text, Number, Formulas, Dates, Currency, Percentage, Scientific, Time and Custom Formats\r\n- Sorting: Ranges, Columns and Rows\r\n- Cell Styling: Font, Size, Background pattern, Border and Alignment\r\n\r\n### IronXL has cross platform support compatibility with:\r\n- Python 3.7+\r\n- Windows, macOS, Linux, Docker, Azure, and AWS\r\n\r\n[](https://ironsoftware.com/python/excel/docs/?utm_source=nuget&utm_medium=organic&utm_campaign=readme&utm_content=crossplatformbanner)\r\n\r\nAdditionally, our [API reference](https://ironsoftware.com/python/excel/object-reference/api/) and [full licensing information](https://ironsoftware.com/python/excel/licensing/#trial-license) can easily be found on our website.\r\n\r\n### Using IronXL\r\n***\r\nIronXL Python relies on .NET 6.0 as its underlying technology. Therefore, it is necessary to have the .NET 6.0 runtime installed on your machine in order to use IronXL Python.\r\n\r\nLinux and Mac users may need to install .NET from https://dotnet.microsoft.com/en-us/download/dotnet/6.0 prior to using this Python package.\r\n\r\n### Install Using Pip\r\n```\r\npip install ironxl\r\n```\r\nIronPDF will then download additional dependencies the first time you run it.\r\n\r\n### Or Download the Full Package\r\nOptionally, download the Python package specific to your platform from our downloads section at https://ironxl.com/python/\r\n### Usage\r\nOnce installed, you can get started by adding `from ironxl import *` to the top of your Python script. Here is an example to get started:\r\n```python\r\nfrom ironxl import *\r\n\r\nworkbook = WorkBook(\"test.xlsx\")\r\nprint(workbook.WorkSheets.Count)\r\n```\r\n\r\n## Features Table\r\n[](https://ironsoftware.com/python/excel/features/?utm_source=nuget&utm_medium=organic&utm_campaign=readme&utm_content=featuresbanner)\r\n\r\n## Licensing & Support available\r\nFor code examples, tutorials and documentation visit [https://ironsoftware.com/python/excel/](https://ironsoftware.com/python/excel/?utm_source=nuget&utm_medium=organic&utm_campaign=readme&utm_content=supportanddocs)\r\n\r\nFor support please email us at support@ironsoftware.com\r\n\r\n## Documentation Links\r\n\r\n- Code Examples : [(https://ironsoftware.com/python/excel/examples/](https://ironsoftware.com/python/excel/examples/read-excel/?utm_source=nuget&utm_medium=organic&utm_campaign=readme&utm_content=supportanddocs)\r\n- API Reference : [https://ironsoftware.com/python/excel/object-reference/api/](https://ironsoftware.com/python/excel/object-reference/api/?utm_source=nuget&utm_medium=organic&utm_campaign=readme&utm_content=supportanddocs)\r\n- Tutorials : [https://ironsoftware.com/python/excel/tutorials/how-to-read-excel-file-python/](https://ironsoftware.com/python/excel/tutorials/how-to-read-excel-file-python/?utm_source=nuget&utm_medium=organic&utm_campaign=readme&utm_content=supportanddocs)\r\n- Licensing : [https://ironsoftware.com/python/excel/licensing/](https://ironsoftware.com/python/excel/licensing/?utm_source=nuget&utm_medium=organic&utm_campaign=readme&utm_content=supportanddocs)\r\n- Live Chat Support : [https://ironsoftware.com/python/excel/#helpscout-support](https://ironsoftware.com/python/excel/?utm_source=nuget&utm_medium=organic&utm_campaign=readme&utm_content=supportanddocs#helpscout-support)\r\n\r\nYou can email us at support@ironsoftware.com for support directly from our code team. We offer licensing and extensive support for commercial deployment projects.\r\n\r\n\r\n",
"bugtrack_url": null,
"license": "Commercial",
"summary": "IronXL for Python",
"version": "2024.9.0.3",
"project_urls": {
"Homepage": "https://ironxl.com/"
},
"split_keywords": [],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "5d9bb9830c65d0f5bd0ab41fac66ab42170d46bc0329b51a6cd8c377e7ceef45",
"md5": "aced29a8ab8c97b1c7a0247bf105a27b",
"sha256": "77abc4aedc5c86ea068fedc8feb2cec99e26468115c0f9d54790cd548d51e69c"
},
"downloads": -1,
"filename": "IronXL-2024.9.0.3-py37-none-any.whl",
"has_sig": false,
"md5_digest": "aced29a8ab8c97b1c7a0247bf105a27b",
"packagetype": "bdist_wheel",
"python_version": "py37",
"requires_python": "<4,>=3.7",
"size": 12134516,
"upload_time": "2024-09-17T08:28:55",
"upload_time_iso_8601": "2024-09-17T08:28:55.701158Z",
"url": "https://files.pythonhosted.org/packages/5d/9b/b9830c65d0f5bd0ab41fac66ab42170d46bc0329b51a6cd8c377e7ceef45/IronXL-2024.9.0.3-py37-none-any.whl",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-09-17 08:28:55",
"github": false,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"lcname": "ironxl"
}
JSON