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.7",
"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/df/20/0b02d3e65580bdcc1c29864078b5b21367eb694c8958d6a229c5d0d1c07d/aspose-cells-24.11.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": "A powerful library for manipulating and converting Excel (XLS, XLSX, XLSB), ODS, CSV and HTML files.",
"version": "24.11.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": "d2185770a150140b3836bad894728c89d3001f4e0df616c25ddff34b8cc3e620",
"md5": "4000a3b6ef6bcb254b4999e746d8a75b",
"sha256": "65256f5f40d25b0d2fe2cff4db4cb8704f770c86f10aca80bc5a5d0a0451b078"
},
"downloads": -1,
"filename": "aspose_cells-24.11.0-py3-none-any.whl",
"has_sig": false,
"md5_digest": "4000a3b6ef6bcb254b4999e746d8a75b",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": "<3.13,>=3.7",
"size": 14558487,
"upload_time": "2024-11-13T10:35:59",
"upload_time_iso_8601": "2024-11-13T10:35:59.498979Z",
"url": "https://files.pythonhosted.org/packages/d2/18/5770a150140b3836bad894728c89d3001f4e0df616c25ddff34b8cc3e620/aspose_cells-24.11.0-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "df200b02d3e65580bdcc1c29864078b5b21367eb694c8958d6a229c5d0d1c07d",
"md5": "6f3315a41eb587082b68c46d04708d1f",
"sha256": "c0ddc7f96568ecc0c1a7f5ae71aa617d70912e97263ef29b8ddc1bdc939a946e"
},
"downloads": -1,
"filename": "aspose-cells-24.11.0.tar.gz",
"has_sig": false,
"md5_digest": "6f3315a41eb587082b68c46d04708d1f",
"packagetype": "sdist",
"python_version": "source",
"requires_python": "<3.13,>=3.7",
"size": 14583997,
"upload_time": "2024-11-13T10:36:59",
"upload_time_iso_8601": "2024-11-13T10:36:59.108111Z",
"url": "https://files.pythonhosted.org/packages/df/20/0b02d3e65580bdcc1c29864078b5b21367eb694c8958d6a229c5d0d1c07d/aspose-cells-24.11.0.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-11-13 10:36:59",
"github": false,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"lcname": "aspose-cells"
}
JSON