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.5",
"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/35/b4/9a214adeda0ffd828d7a18ce47f56dc2b285b6032c3ff5049cd24c143711/aspose-cells-24.4.0.tar.gz",
"platform": "Operating System :: MacOS :: MacOS X",
"description": "\nPython Excel API\n================\n\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.\n\nPython Excel API Features\n-------------------------\n\n\n* Create Excel files via API.\n* Create & refresh Pivot Tables & charts.\n* Create & manipulate sparklines & conditional formatting.\n* Convert charts to images or PDF.\n* Manage comments & hyperlinks.\n* Set complex formulas & calculate results via API.\n* Set protection on workbook, worksheet, cell, column or row.\n* Create & manipulate named ranges.\n* Populate worksheets through Smart Markers.\n* Convert worksheets to PDF, XPS & SVG formats.\n* Inter-convert files to popular Excel formats.\n\nRead & Write Excel Files\n------------------------\n\n**Microsoft Excel:** XLS, XLSX, XLSB, XLTX, XLTM, XLSM, XML\n**OpenOffice:** ODS\n**Text:** CSV, Tab-Delimited, TXT, JSON\n**Web:** HTML, MHTML\n\nSave Excel Files As\n-------------------\n\n**Fixed Layout:** PDF, XPS\n**Images:** JPEG, PNG, BMP, SVG, TIFF, GIF, EMF\n**Text:** CSV, Tab-Delimited, JSON, SQL, XML\n\nCreate Excel File from Scratch using Python\n-------------------------------------------\n\n.. code-block:: python\n\n import jpype\n import asposecells\n jpype.startJVM()\n from asposecells.api import Workbook, FileFormatType\n\n workbook = Workbook(FileFormatType.XLSX)\n workbook.getWorksheets().get(0).getCells().get(\"A1\").putValue(\"Hello World\")\n workbook.save(\"output.xlsx\")\n\n jpype.shutdownJVM()\n\nConvert Excel XLSX File to PDF using Python\n-------------------------------------------\n\n.. code-block:: python\n\n import jpype\n import asposecells\n jpype.startJVM()\n from asposecells.api import Workbook, FileFormatType, PdfSaveOptions\n\n workbook = Workbook(\"example.xlsx\")\n saveOptions = PdfSaveOptions()\n saveOptions.setOnePagePerSheet(True)\n workbook.save(\"example.pdf\", saveOptions)\n\n jpype.shutdownJVM()\n\nCreate Excel Chart & Convert to Image via Python\n------------------------------------------------\n\n.. code-block:: python\n\n import jpype\n import asposecells\n jpype.startJVM()\n from asposecells.api import Workbook, Chart, ChartType, ImageOrPrintOptions\n\n workbook = Workbook()\n sheet = workbook.getWorksheets().get(0)\n cells = sheet.getCells()\n cells.get(0, 1).putValue(\"Income\")\n cells.get(1, 0).putValue(\"Company A\")\n cells.get(2, 0).putValue(\"Company B\")\n cells.get(3, 0).putValue(\"Company C\")\n cells.get(1, 1).putValue(10000)\n cells.get(2, 1).putValue(20000)\n cells.get(3, 1).putValue(30000)\n chartIndex = sheet.getCharts().add(ChartType.COLUMN, 9, 9, 21, 15)\n chart = sheet.getCharts().get(chartIndex)\n chart.getNSeries().add(\"B2:B4\", True)\n chart.getNSeries().setCategoryData(\"A2:A4\")\n aSeries = chart.getNSeries().get(0)\n aSeries.setName(\"=B1\")\n chart.setShowLegend(True)\n chart.getTitle().setText(\"Income Analysis\")\n\n options = ImageOrPrintOptions()\n options.setHorizontalResolution(300)\n options.setVerticalResolution(300)\n chart.toImage(\"chart.png\", options)\n\n jpype.shutdownJVM()\n\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>`_\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.4.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": "2719afbc1e20e9745da410a9acb3ab094c82582664cdd0f0b62b9cfac7c09d8c",
"md5": "f56c416c62dc462d497e87f571a5eb06",
"sha256": "cd9b385e7e80be973e54307e1aa3e071c2ff59a84d12196e0ad47908f0084ebf"
},
"downloads": -1,
"filename": "aspose_cells-24.4.0-py3-none-any.whl",
"has_sig": false,
"md5_digest": "f56c416c62dc462d497e87f571a5eb06",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.5",
"size": 14249861,
"upload_time": "2024-04-11T04:13:29",
"upload_time_iso_8601": "2024-04-11T04:13:29.090790Z",
"url": "https://files.pythonhosted.org/packages/27/19/afbc1e20e9745da410a9acb3ab094c82582664cdd0f0b62b9cfac7c09d8c/aspose_cells-24.4.0-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "35b49a214adeda0ffd828d7a18ce47f56dc2b285b6032c3ff5049cd24c143711",
"md5": "f85db38f00dce7e4af7752f32c8343cb",
"sha256": "8b3cb8f7d4ad31b32369a5fd4a4f458ed5ce7cb84de7818e46e6239aa97e7660"
},
"downloads": -1,
"filename": "aspose-cells-24.4.0.tar.gz",
"has_sig": false,
"md5_digest": "f85db38f00dce7e4af7752f32c8343cb",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.5",
"size": 14275121,
"upload_time": "2024-04-11T04:13:38",
"upload_time_iso_8601": "2024-04-11T04:13:38.897783Z",
"url": "https://files.pythonhosted.org/packages/35/b4/9a214adeda0ffd828d7a18ce47f56dc2b285b6032c3ff5049cd24c143711/aspose-cells-24.4.0.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-04-11 04:13:38",
"github": false,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"lcname": "aspose-cells"
}
JSON