excelize


Nameexcelize JSON
Version 0.0.2 PyPI version JSON
download
home_pageNone
SummaryA Python build of the Go Excelize library for reading and writing Microsoft Excelâ„¢ (XLAM / XLSM / XLSX / XLTM / XLTX) spreadsheets
upload_time2024-11-26 15:32:26
maintainerxuri
docs_urlNone
authorxuri
requires_python>=3.7
licenseBSD 3-Clause
keywords excelize excel xlsx xlsm xltx xltm xls spreadsheet workbook vba macro
VCS
bugtrack_url
requirements No requirements were recorded.
Travis-CI No Travis.
coveralls test coverage No coveralls.
            # 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&trade; 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&trade; 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"
}
        
Elapsed time: 0.36030s