# excelize-py
<p align="center"><img width="500" src="https://github.com/xuri/excelize-py/raw/main/excelize-py.svg" alt="excelize-py logo"></p>
<p align="center">
<a href="https://pypi.org/project/excelize"><img src="https://img.shields.io/pypi/v/excelize.svg" alt="Pipy version"></a>
<a href="https://github.com/xuri/excelize-py/actions/workflows/build.yml"><img src="https://github.com/xuri/excelize-py/actions/workflows/build.yml/badge.svg" alt="Build Status"></a>
<a href="https://codecov.io/gh/xuri/excelize-py"><img src="https://codecov.io/gh/xuri/excelize-py/branch/main/graph/badge.svg" alt="Code Coverage"></a>
<a href="https://opensource.org/licenses/BSD-3-Clause"><img src="https://img.shields.io/badge/license-bsd-orange.svg" alt="Licenses"></a>
<a href="https://www.paypal.com/paypalme/xuri"><img src="https://img.shields.io/badge/Donate-PayPal-green.svg" alt="Donate"></a>
</p>
Package excelize-py is a Python port of Go [Excelize](https://github.com/xuri/excelize) library, providing a set of functions that allow you to write and read from XLAM / XLSM / XLSX / XLTM / XLTX files. Supports reading and writing spreadsheet documents generated by Microsoft Excel™ 2007 and later. Supports complex components by high compatibility, and provided streaming API for generating or reading data from a worksheet with huge amounts of data. This library needs Python version 3.7 or later. The full API docs can be found at [docs reference](https://xuri.me/excelize/).
## Platform Compatibility
Operating system | CPU Architecture
---|---
Windows | amd64
Darwin | amd64
Darwin | arm64
Linux | amd64
Linux | arm64
## Basic Usage
### Installation
```bash
pip install excelize
```
### Create spreadsheet
Here is a minimal example usage that will create spreadsheet file.
```python
import excelize
f = excelize.new_file()
# Create a new sheet.
index, err = f.new_sheet("Sheet2")
if err is not None:
print(err)
exit()
# Set value of a cell.
f.set_cell_value("Sheet2", "A2", "Hello world.")
f.set_cell_value("Sheet1", "B2", 100)
# Set active sheet of the workbook.
f.set_active_sheet(index)
# Save spreadsheet by the given path.
err = f.save_as("Book1.xlsx")
if err is not None: {
print(err)
}
err = f.close()
if err is not None: {
print(err)
}
```
Raw data
{
"_id": null,
"home_page": null,
"name": "excelize",
"maintainer": "xuri",
"docs_url": null,
"requires_python": ">=3.7",
"maintainer_email": "xuri.me@gmail.com",
"keywords": "excelize, excel, xlsx, xlsm, xltx, xltm, xls, spreadsheet, workbook, vba, macro",
"author": "xuri",
"author_email": "xuri.me@gmail.com",
"download_url": "https://files.pythonhosted.org/packages/46/c1/a697da7cd13de78120768232065a08f67d071827eb2f87393252f21e84d2/excelize-0.0.2.tar.gz",
"platform": null,
"description": "# excelize-py\n\n<p align=\"center\"><img width=\"500\" src=\"https://github.com/xuri/excelize-py/raw/main/excelize-py.svg\" alt=\"excelize-py logo\"></p>\n\n<p align=\"center\">\n <a href=\"https://pypi.org/project/excelize\"><img src=\"https://img.shields.io/pypi/v/excelize.svg\" alt=\"Pipy version\"></a>\n <a href=\"https://github.com/xuri/excelize-py/actions/workflows/build.yml\"><img src=\"https://github.com/xuri/excelize-py/actions/workflows/build.yml/badge.svg\" alt=\"Build Status\"></a>\n <a href=\"https://codecov.io/gh/xuri/excelize-py\"><img src=\"https://codecov.io/gh/xuri/excelize-py/branch/main/graph/badge.svg\" alt=\"Code Coverage\"></a>\n <a href=\"https://opensource.org/licenses/BSD-3-Clause\"><img src=\"https://img.shields.io/badge/license-bsd-orange.svg\" alt=\"Licenses\"></a>\n <a href=\"https://www.paypal.com/paypalme/xuri\"><img src=\"https://img.shields.io/badge/Donate-PayPal-green.svg\" alt=\"Donate\"></a>\n</p>\n\nPackage excelize-py is a Python port of Go [Excelize](https://github.com/xuri/excelize) library, providing a set of functions that allow you to write and read from XLAM / XLSM / XLSX / XLTM / XLTX files. Supports reading and writing spreadsheet documents generated by Microsoft Excel™ 2007 and later. Supports complex components by high compatibility, and provided streaming API for generating or reading data from a worksheet with huge amounts of data. This library needs Python version 3.7 or later. The full API docs can be found at [docs reference](https://xuri.me/excelize/).\n\n## Platform Compatibility\n\nOperating system | CPU Architecture\n---|---\nWindows | amd64\nDarwin | amd64\nDarwin | arm64\nLinux | amd64\nLinux | arm64\n\n## Basic Usage\n\n### Installation\n\n```bash\npip install excelize\n```\n\n### Create spreadsheet\n\nHere is a minimal example usage that will create spreadsheet file.\n\n```python\nimport excelize\n\nf = excelize.new_file()\n# Create a new sheet.\nindex, err = f.new_sheet(\"Sheet2\")\nif err is not None:\n print(err)\n exit()\n# Set value of a cell.\nf.set_cell_value(\"Sheet2\", \"A2\", \"Hello world.\")\nf.set_cell_value(\"Sheet1\", \"B2\", 100)\n# Set active sheet of the workbook.\nf.set_active_sheet(index)\n# Save spreadsheet by the given path.\nerr = f.save_as(\"Book1.xlsx\")\nif err is not None: {\n print(err)\n}\nerr = f.close()\nif err is not None: {\n print(err)\n}\n```\n",
"bugtrack_url": null,
"license": "BSD 3-Clause",
"summary": "A Python build of the Go Excelize library for reading and writing Microsoft Excel\u2122 (XLAM / XLSM / XLSX / XLTM / XLTX) spreadsheets",
"version": "0.0.2",
"project_urls": {
"Documentation": "https://xuri.me/excelize",
"Source": "https://github.com/xuri/excelize-py"
},
"split_keywords": [
"excelize",
" excel",
" xlsx",
" xlsm",
" xltx",
" xltm",
" xls",
" spreadsheet",
" workbook",
" vba",
" macro"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "cd72783c06c434c2160e0122406cf45cae078259a3078a2eb42286bb1128af30",
"md5": "1f1a9591abf880cd2fa1e1f0dba7ce65",
"sha256": "8b4ab65f0156f244d25e91ed739f8f9ce8ace10d7bf563085ba31afd41a4b018"
},
"downloads": -1,
"filename": "excelize-0.0.2-py3-none-any.whl",
"has_sig": false,
"md5_digest": "1f1a9591abf880cd2fa1e1f0dba7ce65",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.7",
"size": 19145690,
"upload_time": "2024-11-26T15:32:22",
"upload_time_iso_8601": "2024-11-26T15:32:22.242267Z",
"url": "https://files.pythonhosted.org/packages/cd/72/783c06c434c2160e0122406cf45cae078259a3078a2eb42286bb1128af30/excelize-0.0.2-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "46c1a697da7cd13de78120768232065a08f67d071827eb2f87393252f21e84d2",
"md5": "c563bfbccb62f91e7133883b0786bf6a",
"sha256": "156d6018a88ed56891d4de7b6f2d7fff15fbbfd168de63657029d416ac99b29a"
},
"downloads": -1,
"filename": "excelize-0.0.2.tar.gz",
"has_sig": false,
"md5_digest": "c563bfbccb62f91e7133883b0786bf6a",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.7",
"size": 19056977,
"upload_time": "2024-11-26T15:32:26",
"upload_time_iso_8601": "2024-11-26T15:32:26.618726Z",
"url": "https://files.pythonhosted.org/packages/46/c1/a697da7cd13de78120768232065a08f67d071827eb2f87393252f21e84d2/excelize-0.0.2.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-11-26 15:32:26",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "xuri",
"github_project": "excelize-py",
"github_not_found": true,
"lcname": "excelize"
}