aspose-cells


Nameaspose-cells JSON
Version 25.7.0 PyPI version JSON
download
home_pagehttps://products.aspose.com/cells/python-java
SummaryAspose.Cells for Python via Java is a high-performance library that unleashes the full potential of Excel in your Python projects. It can be used to efficiently manipulate and convert Excel and spreadsheet formats including XLS, XLSX, XLSB, ODS, CSV, and HTML - all from your Python code. Amazingly, it also offers free support.
upload_time2025-07-11 05:19:03
maintainerNone
docs_urlNone
authorAspose
requires_python<=3.13,>=3.8
licenseNone
keywords excel xls xlsx xlsb csv to pdf jpg png html ods numbers xlsm ooxml spreadsheet markdown xps docx pptx mhtml svg json xml sql
VCS
bugtrack_url
requirements No requirements were recorded.
Travis-CI No Travis.
coveralls test coverage No coveralls.
            
Python Excel API
================

Aspose.Cells for Python via Java is a scalable and feature-rich API to process Excel spreadsheets using Python. API offers Excel file creation, manipulation, conversion, & rendering. Developers can format worksheets, rows, columns or cells to the most granular level, create & manipulate chart & pivot tables, render worksheets, charts and specific data ranges to PDF & images, add & calculate Excel's builtin and custom formulas and much more - all without any dependency on Microsoft Office or Excel application.

Python Excel API Features
-------------------------


* Create Excel files via API.
* Create & refresh Pivot Tables & charts.
* Create & manipulate sparklines & conditional formatting.
* Convert charts to images or PDF.
* Manage comments & hyperlinks.
* Set complex formulas & calculate results via API.
* Set protection on workbook, worksheet, cell, column or row.
* Create & manipulate named ranges.
* Populate worksheets through Smart Markers.
* Convert worksheets to PDF, XPS & SVG formats.
* Inter-convert files to popular Excel formats.

Read & Write Excel Files
------------------------

**Microsoft Excel:** XLS, XLSX, XLSB, XLTX, XLTM, XLSM, XML
**OpenOffice:** ODS
**Text:** CSV, Tab-Delimited, TXT, JSON
**Web:** HTML, MHTML

Save Excel Files As
-------------------

**Fixed Layout:** PDF, XPS
**Images:** JPEG, PNG, BMP, SVG, TIFF, GIF, EMF
**Text:** CSV, Tab-Delimited, JSON, SQL, XML

Create Excel File from Scratch using Python
-------------------------------------------

.. code-block:: python

   import jpype
   import asposecells
   jpype.startJVM()
   from asposecells.api import Workbook, FileFormatType

   workbook = Workbook(FileFormatType.XLSX)
   workbook.getWorksheets().get(0).getCells().get("A1").putValue("Hello World")
   workbook.save("output.xlsx")

   jpype.shutdownJVM()

Convert Excel XLSX File to PDF using Python
-------------------------------------------

.. code-block:: python

   import jpype
   import asposecells
   jpype.startJVM()
   from asposecells.api import Workbook, FileFormatType, PdfSaveOptions

   workbook = Workbook("example.xlsx")
   saveOptions = PdfSaveOptions()
   saveOptions.setOnePagePerSheet(True)
   workbook.save("example.pdf", saveOptions)

   jpype.shutdownJVM()

Create Excel Chart & Convert to Image via Python
------------------------------------------------

.. code-block:: python

   import jpype
   import asposecells
   jpype.startJVM()
   from asposecells.api import Workbook, Chart, ChartType, ImageOrPrintOptions

   workbook = Workbook()
   sheet = workbook.getWorksheets().get(0)
   cells = sheet.getCells()
   cells.get(0, 1).putValue("Income")
   cells.get(1, 0).putValue("Company A")
   cells.get(2, 0).putValue("Company B")
   cells.get(3, 0).putValue("Company C")
   cells.get(1, 1).putValue(10000)
   cells.get(2, 1).putValue(20000)
   cells.get(3, 1).putValue(30000)
   chartIndex = sheet.getCharts().add(ChartType.COLUMN, 9, 9, 21, 15)
   chart = sheet.getCharts().get(chartIndex)
   chart.getNSeries().add("B2:B4", True)
   chart.getNSeries().setCategoryData("A2:A4")
   aSeries = chart.getNSeries().get(0)
   aSeries.setName("=B1")
   chart.setShowLegend(True)
   chart.getTitle().setText("Income Analysis")

   options = ImageOrPrintOptions()
   options.setHorizontalResolution(300)
   options.setVerticalResolution(300)
   chart.toImage("chart.png", options)

   jpype.shutdownJVM()

`Product Page <https://products.aspose.com/cells/python-java>`_ | `Documentation <https://docs.aspose.com/cells/python-java/>`_ | `Blog <https://blog.aspose.com/category/cells/>`_ | `API Reference <https://apireference.aspose.com/cells/python-java>`_ | `Code Samples <https://github.com/aspose-cells/Aspose.Cells-for-Java>`_ | `Free Support <https://forum.aspose.com/c/cells>`_ | `Temporary License <https://purchase.aspose.com/temporary-license>`_ | `EULA <https://company.aspose.com/legal/eula>`_



            

Raw data

            {
    "_id": null,
    "home_page": "https://products.aspose.com/cells/python-java",
    "name": "aspose-cells",
    "maintainer": null,
    "docs_url": null,
    "requires_python": "<=3.13,>=3.8",
    "maintainer_email": null,
    "keywords": "Excel, XLS, XLSX, XLSB, CSV, to, PDF, JPG, PNG, HTML, ODS, Numbers, XLSM, OOXML, Spreadsheet, Markdown, XPS, DOCX, PPTX, MHTML, SVG, JSON, XML, SQL",
    "author": "Aspose",
    "author_email": "cells@aspose.com",
    "download_url": "https://files.pythonhosted.org/packages/ff/a2/3d661ab7f0e97d7efff81db242ac5f162880a9f3cb79aef78c75dd886597/aspose_cells-25.7.0.tar.gz",
    "platform": "Operating System :: MacOS :: MacOS X",
    "description": "\r\nPython Excel API\r\n================\r\n\r\nAspose.Cells for Python via Java is a scalable and feature-rich API to process Excel spreadsheets using Python. API offers Excel file creation, manipulation, conversion, & rendering. Developers can format worksheets, rows, columns or cells to the most granular level, create & manipulate chart & pivot tables, render worksheets, charts and specific data ranges to PDF & images, add & calculate Excel's builtin and custom formulas and much more - all without any dependency on Microsoft Office or Excel application.\r\n\r\nPython Excel API Features\r\n-------------------------\r\n\r\n\r\n* Create Excel files via API.\r\n* Create & refresh Pivot Tables & charts.\r\n* Create & manipulate sparklines & conditional formatting.\r\n* Convert charts to images or PDF.\r\n* Manage comments & hyperlinks.\r\n* Set complex formulas & calculate results via API.\r\n* Set protection on workbook, worksheet, cell, column or row.\r\n* Create & manipulate named ranges.\r\n* Populate worksheets through Smart Markers.\r\n* Convert worksheets to PDF, XPS & SVG formats.\r\n* Inter-convert files to popular Excel formats.\r\n\r\nRead & Write Excel Files\r\n------------------------\r\n\r\n**Microsoft Excel:** XLS, XLSX, XLSB, XLTX, XLTM, XLSM, XML\r\n**OpenOffice:** ODS\r\n**Text:** CSV, Tab-Delimited, TXT, JSON\r\n**Web:** HTML, MHTML\r\n\r\nSave Excel Files As\r\n-------------------\r\n\r\n**Fixed Layout:** PDF, XPS\r\n**Images:** JPEG, PNG, BMP, SVG, TIFF, GIF, EMF\r\n**Text:** CSV, Tab-Delimited, JSON, SQL, XML\r\n\r\nCreate Excel File from Scratch using Python\r\n-------------------------------------------\r\n\r\n.. code-block:: python\r\n\r\n   import jpype\r\n   import asposecells\r\n   jpype.startJVM()\r\n   from asposecells.api import Workbook, FileFormatType\r\n\r\n   workbook = Workbook(FileFormatType.XLSX)\r\n   workbook.getWorksheets().get(0).getCells().get(\"A1\").putValue(\"Hello World\")\r\n   workbook.save(\"output.xlsx\")\r\n\r\n   jpype.shutdownJVM()\r\n\r\nConvert Excel XLSX File to PDF using Python\r\n-------------------------------------------\r\n\r\n.. code-block:: python\r\n\r\n   import jpype\r\n   import asposecells\r\n   jpype.startJVM()\r\n   from asposecells.api import Workbook, FileFormatType, PdfSaveOptions\r\n\r\n   workbook = Workbook(\"example.xlsx\")\r\n   saveOptions = PdfSaveOptions()\r\n   saveOptions.setOnePagePerSheet(True)\r\n   workbook.save(\"example.pdf\", saveOptions)\r\n\r\n   jpype.shutdownJVM()\r\n\r\nCreate Excel Chart & Convert to Image via Python\r\n------------------------------------------------\r\n\r\n.. code-block:: python\r\n\r\n   import jpype\r\n   import asposecells\r\n   jpype.startJVM()\r\n   from asposecells.api import Workbook, Chart, ChartType, ImageOrPrintOptions\r\n\r\n   workbook = Workbook()\r\n   sheet = workbook.getWorksheets().get(0)\r\n   cells = sheet.getCells()\r\n   cells.get(0, 1).putValue(\"Income\")\r\n   cells.get(1, 0).putValue(\"Company A\")\r\n   cells.get(2, 0).putValue(\"Company B\")\r\n   cells.get(3, 0).putValue(\"Company C\")\r\n   cells.get(1, 1).putValue(10000)\r\n   cells.get(2, 1).putValue(20000)\r\n   cells.get(3, 1).putValue(30000)\r\n   chartIndex = sheet.getCharts().add(ChartType.COLUMN, 9, 9, 21, 15)\r\n   chart = sheet.getCharts().get(chartIndex)\r\n   chart.getNSeries().add(\"B2:B4\", True)\r\n   chart.getNSeries().setCategoryData(\"A2:A4\")\r\n   aSeries = chart.getNSeries().get(0)\r\n   aSeries.setName(\"=B1\")\r\n   chart.setShowLegend(True)\r\n   chart.getTitle().setText(\"Income Analysis\")\r\n\r\n   options = ImageOrPrintOptions()\r\n   options.setHorizontalResolution(300)\r\n   options.setVerticalResolution(300)\r\n   chart.toImage(\"chart.png\", options)\r\n\r\n   jpype.shutdownJVM()\r\n\r\n`Product Page <https://products.aspose.com/cells/python-java>`_ | `Documentation <https://docs.aspose.com/cells/python-java/>`_ | `Blog <https://blog.aspose.com/category/cells/>`_ | `API Reference <https://apireference.aspose.com/cells/python-java>`_ | `Code Samples <https://github.com/aspose-cells/Aspose.Cells-for-Java>`_ | `Free Support <https://forum.aspose.com/c/cells>`_ | `Temporary License <https://purchase.aspose.com/temporary-license>`_ | `EULA <https://company.aspose.com/legal/eula>`_\r\n\r\n\r\n",
    "bugtrack_url": null,
    "license": null,
    "summary": "Aspose.Cells for Python via Java is a high-performance library that unleashes the full potential of Excel in your Python projects. It can be used to efficiently manipulate and convert Excel and spreadsheet formats including XLS, XLSX, XLSB, ODS, CSV, and HTML - all from your Python code. Amazingly, it also offers free support.",
    "version": "25.7.0",
    "project_urls": {
        "Homepage": "https://products.aspose.com/cells/python-java"
    },
    "split_keywords": [
        "excel",
        " xls",
        " xlsx",
        " xlsb",
        " csv",
        " to",
        " pdf",
        " jpg",
        " png",
        " html",
        " ods",
        " numbers",
        " xlsm",
        " ooxml",
        " spreadsheet",
        " markdown",
        " xps",
        " docx",
        " pptx",
        " mhtml",
        " svg",
        " json",
        " xml",
        " sql"
    ],
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "261275ce644eab89a6e0072a0792d5ac0ffb53fb94fc56fc83ae901332cc2095",
                "md5": "f68960e11642bc6255ff206b3dd3f693",
                "sha256": "259e8115792b58fa08a39bb2f58cf1662d528f8f62fe5b6cdc315d0a17487dec"
            },
            "downloads": -1,
            "filename": "aspose_cells-25.7.0-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "f68960e11642bc6255ff206b3dd3f693",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": "<=3.13,>=3.8",
            "size": 15309058,
            "upload_time": "2025-07-11T05:18:52",
            "upload_time_iso_8601": "2025-07-11T05:18:52.199590Z",
            "url": "https://files.pythonhosted.org/packages/26/12/75ce644eab89a6e0072a0792d5ac0ffb53fb94fc56fc83ae901332cc2095/aspose_cells-25.7.0-py3-none-any.whl",
            "yanked": false,
            "yanked_reason": null
        },
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "ffa23d661ab7f0e97d7efff81db242ac5f162880a9f3cb79aef78c75dd886597",
                "md5": "4882bca36bb81b9ddd1ca2c63b02d429",
                "sha256": "506f961a2b028845eea581d8d961063603b125f8c00dc2ef2a7c41dc4c65df78"
            },
            "downloads": -1,
            "filename": "aspose_cells-25.7.0.tar.gz",
            "has_sig": false,
            "md5_digest": "4882bca36bb81b9ddd1ca2c63b02d429",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": "<=3.13,>=3.8",
            "size": 15332295,
            "upload_time": "2025-07-11T05:19:03",
            "upload_time_iso_8601": "2025-07-11T05:19:03.835101Z",
            "url": "https://files.pythonhosted.org/packages/ff/a2/3d661ab7f0e97d7efff81db242ac5f162880a9f3cb79aef78c75dd886597/aspose_cells-25.7.0.tar.gz",
            "yanked": false,
            "yanked_reason": null
        }
    ],
    "upload_time": "2025-07-11 05:19:03",
    "github": false,
    "gitlab": false,
    "bitbucket": false,
    "codeberg": false,
    "lcname": "aspose-cells"
}
        
Elapsed time: 0.47797s