| Name | aspose-cells-python JSON |
| Version |
24.11.0
JSON |
| download |
| home_page | https://products.aspose.com/cells/ |
| Summary | A powerful library for manipulating and converting Excel (XLS, XLSX, XLSB), CSV, ODS, PDF, JSON, JPG, PNG, BMP, EMF, SVG and HTML files. |
| upload_time | 2024-11-13 12:13:34 |
| maintainer | None |
| docs_url | None |
| author | aspose-cells |
| requires_python | <3.14,>=3.6 |
| license | https://company.aspose.com/legal/eula |
| keywords |
excel
xls
xlsx
xlsb
csv
pdf
jpg
png
html
ods
numbers
xlsm
ooxml
spreadsheet
markdown
xps
docx
pptx
mhtml
txt
json
svg
emf
tiff
|
| VCS |
|
| bugtrack_url |
|
| requirements |
No requirements were recorded.
|
| Travis-CI |
No Travis.
|
| coveralls test coverage |
No coveralls.
|
Product description
==================================
`Product Page <https://products.aspose.com/cells/python-net>`_ | `Docs <https://docs.aspose.com/cells/python-net/>`_ | `API Reference <https://reference.aspose.com/cells/python-net/>`_ | `Demos <https://products.aspose.app/cells/family/>`_ | `Blog <https://blog.aspose.com/category/cells/>`_ | `Code Samples <https://github.com/aspose-cells/Aspose.Cells-for-Python-via-.NET>`_ | `Free Support <https://forum.aspose.com/c/cells>`_ | `Temporary License <https://purchase.aspose.com/temporary-license>`_ | `EULA <https://company.aspose.com/legal/eula>`_
Try our `free online apps <https://products.aspose.app/cells/family>`_ demonstrating some of the most popular Aspose.Cells functionality.
A powerful library for manipulating and converting Excel (XLS, XLSX, XLSB), CSV, ODS, PDF, JSON, JPG, PNG, BMP, SVG, EMF and HTML files.
Aspsoe.Cells API Features
-------------------------
Aspose.Cells offers a wide arrange of features for creating, reading, manipulating and saving Excel® files:
* Spreadsheet generation & manipulation via API.
* High-quality file format conversion & rendering.
* Print Microsoft Excel® files to physical or virtual printers.
* Combine, modify, protect, or parse Excel® sheets.
* Apply worksheet formatting.
* Configure and apply page setup for the worksheets.
* Create & customize Excel® charts, Pivot Tables, conditional formatting rules, slicers, tables & spark-lines.
* Convert Excel® charts to images & PDF.
* Convert Excel® files to various other formats.
* Formula calculation engine that supports all basic and advanced Excel functions.
Supported Read & Write Formats
-----------------------------------
* Microsoft Excel®: XLS, XLSX, XLSB, XLSM, XLT, XLTX, XLTM, SpreadsheetML
* OpenOffice: ODS, SXC, FODS
* Text: JSON, TXT, CSV, TSV, Tab-Delimited
* Web: HTML, MHTML
* iWork®: Numbers
Save Excel® Files As
-----------------------------------
* Microsoft Word®: DOCX
* Microsoft PowerPoint®: PPTX
* Microsoft Excel®: XLAM
* Fixed Layout: PDF, XPS
* Text: JSON, TXT, CSV, TSV, Tab-Delimited, XML
* Image: TIFF, PNG, BMP, JPEG, GIF, SVG
* Metafile: EMF
* Markdown: MD
Create Excel file from scratch
-------------------------------------------
.. code-block:: python
# import the python package
import aspose.cells
from aspose.cells import License, Workbook, FileFormatType
# Create a new Workbook
workbook = Workbook()
# Get the first worksheet
worksheet = workbook.worksheets[0]
# Get the "A1" cell
cells = worksheet.cells
cell = cells.get("A1")
# Write "Hello World" to "A1" in the first sheet
cell.put_value("Hello World!")
# save this workbook to XLSX
workbook.save("HelloWorld.xlsx")
Convert Excel XLSX file to PDF
-----------------------------------------------------
.. code-block:: python
# import the python package
import aspose.cells
from aspose.cells import License, Workbook, FileFormatType
workbook = Workbook("HelloWorld.xlsx")
# save this workbook to resultFile,you can see a chart while open the file with MS-Excel*/
workbook.save("HelloWorld.pdf");
Create a simple pivot table
------------------------------------------------
.. code-block:: python
from aspose.cells import Workbook
from aspose.cells.pivot import PivotFieldType
# Instantiating a Workbook object
workbook = Workbook()
# Obtaining the reference of the newly added worksheet
sheet = workbook.worksheets[0]
cells = sheet.cells
# Setting the value to the cells
cell = cells.get("A1")
cell.put_value("Sport")
cell = cells.get("B1")
cell.put_value("Quarter")
cell = cells.get("C1")
cell.put_value("Sales")
cell = cells.get("A2")
cell.put_value("Golf")
cell = cells.get("A3")
cell.put_value("Golf")
cell = cells.get("A4")
cell.put_value("Tennis")
cell = cells.get("A5")
cell.put_value("Tennis")
cell = cells.get("A6")
cell.put_value("Tennis")
cell = cells.get("A7")
cell.put_value("Tennis")
cell = cells.get("A8")
cell.put_value("Golf")
cell = cells.get("B2")
cell.put_value("Qtr3")
cell = cells.get("B3")
cell.put_value("Qtr4")
cell = cells.get("B4")
cell.put_value("Qtr3")
cell = cells.get("B5")
cell.put_value("Qtr4")
cell = cells.get("B6")
cell.put_value("Qtr3")
cell = cells.get("B7")
cell.put_value("Qtr4")
cell = cells.get("B8")
cell.put_value("Qtr3")
cell = cells.get("C2")
cell.put_value(1500)
cell = cells.get("C3")
cell.put_value(2000)
cell = cells.get("C4")
cell.put_value(600)
cell = cells.get("C5")
cell.put_value(1500)
cell = cells.get("C6")
cell.put_value(4070)
cell = cells.get("C7")
cell.put_value(5000)
cell = cells.get("C8")
cell.put_value(6430)
pivotTables = sheet.pivot_tables
# Adding a PivotTable to the worksheet
index = pivotTables.add("=A1:C8", "E3", "PivotTable2")
# Accessing the instance of the newly added PivotTable
pivotTable = pivotTables[index]
# Unshowing grand totals for rows.
pivotTable.row_grand = False
# Draging the first field to the row area.
pivotTable.add_field_to_area(PivotFieldType.ROW, 0)
# Draging the second field to the column area.
pivotTable.add_field_to_area(PivotFieldType.COLUMN, 1)
# Draging the third field to the data area.
pivotTable.add_field_to_area(PivotFieldType.DATA, 2)
# Saving the Excel file
workbook.save("pivotTable_test_out.xls")
Convert Excel workbook to JSON
------------------------------------------------
.. code-block:: python
from aspose.cells import Workbook
# Instantiating a Workbook object
workbook = Workbook()
# Obtaining the reference of the newly added worksheet
sheet = workbook.worksheets[0]
cells = sheet.cells
# Setting the value to the cells
cell = cells.get("A1")
cell.put_value("First name")
cell = cells.get("A2")
cell.put_value("Simon")
cell = cells.get("A3")
cell.put_value("Kevin")
cell = cells.get("A4")
cell.put_value("Leo")
cell = cells.get("A5")
cell.put_value("Johnson")
cell = cells.get("B1")
cell.put_value("Age")
cell = cells.get("C1")
cell.put_value("Value")
cell = cells.get("B2")
cell.put_value(32)
cell = cells.get("B3")
cell.put_value(33)
cell = cells.get("B4")
cell.put_value(34)
cell = cells.get("B5")
cell.put_value(35)
cell = cells.get("C2")
cell.put_value(123.546)
cell = cells.get("C3")
cell.put_value(56.78)
cell = cells.get("C4")
cell.put_value(34)
cell = cells.get("C5")
cell.put_value(9)
# Saving the Excel file to json
workbook.save("Out.json")
`Product Page <https://products.aspose.com/cells/python-net>`_ | `Docs <https://docs.aspose.com/cells/python-net/>`_ | `API Reference <https://reference.aspose.com/cells/python-net/>`_ | `Demos <https://products.aspose.app/cells/family/>`_ | `Blog <https://blog.aspose.com/category/cells/>`_ | `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/",
"name": "aspose-cells-python",
"maintainer": null,
"docs_url": null,
"requires_python": "<3.14,>=3.6",
"maintainer_email": null,
"keywords": "Excel, XLS, XLSX, XLSB, CSV, PDF, JPG, PNG, HTML, ODS, Numbers, XLSM, OOXML, Spreadsheet, Markdown, XPS, DOCX, PPTX, MHTML, TXT, JSON, SVG, EMF, TIFF",
"author": "aspose-cells",
"author_email": null,
"download_url": null,
"platform": "linux_x86_64",
"description": "Product description \n==================================\n\n\n`Product Page <https://products.aspose.com/cells/python-net>`_ | `Docs <https://docs.aspose.com/cells/python-net/>`_ | `API Reference <https://reference.aspose.com/cells/python-net/>`_ | `Demos <https://products.aspose.app/cells/family/>`_ | `Blog <https://blog.aspose.com/category/cells/>`_ | `Code Samples <https://github.com/aspose-cells/Aspose.Cells-for-Python-via-.NET>`_ | `Free Support <https://forum.aspose.com/c/cells>`_ | `Temporary License <https://purchase.aspose.com/temporary-license>`_ | `EULA <https://company.aspose.com/legal/eula>`_\n\nTry our `free online apps <https://products.aspose.app/cells/family>`_ demonstrating some of the most popular Aspose.Cells functionality.\n\nA powerful library for manipulating and converting Excel (XLS, XLSX, XLSB), CSV, ODS, PDF, JSON, JPG, PNG, BMP, SVG, EMF and HTML files.\n\n\n\nAspsoe.Cells API Features\n-------------------------\n\nAspose.Cells offers a wide arrange of features for creating, reading, manipulating and saving Excel\u00ae files:\n\n* Spreadsheet generation & manipulation via API.\n* High-quality file format conversion & rendering.\n* Print Microsoft Excel\u00ae files to physical or virtual printers.\n* Combine, modify, protect, or parse Excel\u00ae sheets.\n* Apply worksheet formatting.\n* Configure and apply page setup for the worksheets.\n* Create & customize Excel\u00ae charts, Pivot Tables, conditional formatting rules, slicers, tables & spark-lines.\n* Convert Excel\u00ae charts to images & PDF.\n* Convert Excel\u00ae files to various other formats.\n* Formula calculation engine that supports all basic and advanced Excel functions.\n\nSupported Read & Write Formats\n-----------------------------------\n\n* Microsoft Excel\u00ae: XLS, XLSX, XLSB, XLSM, XLT, XLTX, XLTM, SpreadsheetML\n* OpenOffice: ODS, SXC, FODS\n* Text: JSON, TXT, CSV, TSV, Tab-Delimited\n* Web: HTML, MHTML\n* iWork\u00ae: Numbers\n\nSave Excel\u00ae Files As\n-----------------------------------\n* Microsoft Word\u00ae: DOCX\n* Microsoft PowerPoint\u00ae: PPTX\n* Microsoft Excel\u00ae: XLAM\n* Fixed Layout: PDF, XPS\n* Text: JSON, TXT, CSV, TSV, Tab-Delimited, XML\n* Image: TIFF, PNG, BMP, JPEG, GIF, SVG\n* Metafile: EMF\n* Markdown: MD\n\nCreate Excel file from scratch\n-------------------------------------------\n\n.. code-block:: python\n\n # import the python package\n import aspose.cells\n from aspose.cells import License, Workbook, FileFormatType\n\n # Create a new Workbook\n workbook = Workbook()\n # Get the first worksheet\n worksheet = workbook.worksheets[0]\n # Get the \"A1\" cell\n cells = worksheet.cells\n cell = cells.get(\"A1\")\n # Write \"Hello World\" to \"A1\" in the first sheet\n cell.put_value(\"Hello World!\")\n # save this workbook to XLSX\n workbook.save(\"HelloWorld.xlsx\")\n\n\n\n\nConvert Excel XLSX file to PDF\n-----------------------------------------------------\n\n.. code-block:: python\n\n # import the python package\n import aspose.cells\n from aspose.cells import License, Workbook, FileFormatType\n\n workbook = Workbook(\"HelloWorld.xlsx\")\n # save this workbook to resultFile,you can see a chart while open the file with MS-Excel*/\n workbook.save(\"HelloWorld.pdf\");\n\n\n\nCreate a simple pivot table\n------------------------------------------------\n\n.. code-block:: python\n\n from aspose.cells import Workbook\n from aspose.cells.pivot import PivotFieldType\n \n # Instantiating a Workbook object\n workbook = Workbook()\n # Obtaining the reference of the newly added worksheet\n sheet = workbook.worksheets[0]\n cells = sheet.cells\n # Setting the value to the cells\n cell = cells.get(\"A1\")\n cell.put_value(\"Sport\")\n cell = cells.get(\"B1\")\n cell.put_value(\"Quarter\")\n cell = cells.get(\"C1\")\n cell.put_value(\"Sales\")\n cell = cells.get(\"A2\")\n cell.put_value(\"Golf\")\n cell = cells.get(\"A3\")\n cell.put_value(\"Golf\")\n cell = cells.get(\"A4\")\n cell.put_value(\"Tennis\")\n cell = cells.get(\"A5\")\n cell.put_value(\"Tennis\")\n cell = cells.get(\"A6\")\n cell.put_value(\"Tennis\")\n cell = cells.get(\"A7\")\n cell.put_value(\"Tennis\")\n cell = cells.get(\"A8\")\n cell.put_value(\"Golf\")\n cell = cells.get(\"B2\")\n cell.put_value(\"Qtr3\")\n cell = cells.get(\"B3\")\n cell.put_value(\"Qtr4\")\n cell = cells.get(\"B4\")\n cell.put_value(\"Qtr3\")\n cell = cells.get(\"B5\")\n cell.put_value(\"Qtr4\")\n cell = cells.get(\"B6\")\n cell.put_value(\"Qtr3\")\n cell = cells.get(\"B7\")\n cell.put_value(\"Qtr4\")\n cell = cells.get(\"B8\")\n cell.put_value(\"Qtr3\")\n cell = cells.get(\"C2\")\n cell.put_value(1500)\n cell = cells.get(\"C3\")\n cell.put_value(2000)\n cell = cells.get(\"C4\")\n cell.put_value(600)\n cell = cells.get(\"C5\")\n cell.put_value(1500)\n cell = cells.get(\"C6\")\n cell.put_value(4070)\n cell = cells.get(\"C7\")\n cell.put_value(5000)\n cell = cells.get(\"C8\")\n cell.put_value(6430)\n pivotTables = sheet.pivot_tables\n # Adding a PivotTable to the worksheet\n index = pivotTables.add(\"=A1:C8\", \"E3\", \"PivotTable2\")\n # Accessing the instance of the newly added PivotTable\n pivotTable = pivotTables[index]\n # Unshowing grand totals for rows.\n pivotTable.row_grand = False\n # Draging the first field to the row area.\n pivotTable.add_field_to_area(PivotFieldType.ROW, 0)\n # Draging the second field to the column area.\n pivotTable.add_field_to_area(PivotFieldType.COLUMN, 1)\n # Draging the third field to the data area.\n pivotTable.add_field_to_area(PivotFieldType.DATA, 2)\n # Saving the Excel file\n workbook.save(\"pivotTable_test_out.xls\")\n\n\n\nConvert Excel workbook to JSON\n------------------------------------------------\n\n.. code-block:: python\n\n from aspose.cells import Workbook\n \n # Instantiating a Workbook object\n workbook = Workbook()\n # Obtaining the reference of the newly added worksheet\n sheet = workbook.worksheets[0]\n cells = sheet.cells\n # Setting the value to the cells\n cell = cells.get(\"A1\")\n cell.put_value(\"First name\")\n cell = cells.get(\"A2\")\n cell.put_value(\"Simon\")\n cell = cells.get(\"A3\")\n cell.put_value(\"Kevin\")\n cell = cells.get(\"A4\")\n cell.put_value(\"Leo\")\n cell = cells.get(\"A5\")\n cell.put_value(\"Johnson\")\n cell = cells.get(\"B1\")\n cell.put_value(\"Age\")\n cell = cells.get(\"C1\")\n cell.put_value(\"Value\")\n cell = cells.get(\"B2\")\n cell.put_value(32)\n cell = cells.get(\"B3\")\n cell.put_value(33)\n cell = cells.get(\"B4\")\n cell.put_value(34)\n cell = cells.get(\"B5\")\n cell.put_value(35)\n cell = cells.get(\"C2\")\n cell.put_value(123.546)\n cell = cells.get(\"C3\")\n cell.put_value(56.78)\n cell = cells.get(\"C4\")\n cell.put_value(34)\n cell = cells.get(\"C5\")\n cell.put_value(9)\n # Saving the Excel file to json\n workbook.save(\"Out.json\")\n\n\n`Product Page <https://products.aspose.com/cells/python-net>`_ | `Docs <https://docs.aspose.com/cells/python-net/>`_ | `API Reference <https://reference.aspose.com/cells/python-net/>`_ | `Demos <https://products.aspose.app/cells/family/>`_ | `Blog <https://blog.aspose.com/category/cells/>`_ | `Free Support <https://forum.aspose.com/c/cells>`_ | `Temporary License <https://purchase.aspose.com/temporary-license>`_ | `EULA <https://company.aspose.com/legal/eula>`_\n\n\n",
"bugtrack_url": null,
"license": "https://company.aspose.com/legal/eula",
"summary": "A powerful library for manipulating and converting Excel (XLS, XLSX, XLSB), CSV, ODS, PDF, JSON, JPG, PNG, BMP, EMF, SVG and HTML files.",
"version": "24.11.0",
"project_urls": {
"Homepage": "https://products.aspose.com/cells/"
},
"split_keywords": [
"excel",
" xls",
" xlsx",
" xlsb",
" csv",
" pdf",
" jpg",
" png",
" html",
" ods",
" numbers",
" xlsm",
" ooxml",
" spreadsheet",
" markdown",
" xps",
" docx",
" pptx",
" mhtml",
" txt",
" json",
" svg",
" emf",
" tiff"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "9f86520944c179fa5dafe57094b68edfe89894661b7212d51074c1878422c5f2",
"md5": "dacb2b3ade576a63d60434d9f4c27b30",
"sha256": "375a9d29b3c4557595afdd910c14e2a8ca7fe9b537e9ee39a0cb69a7008a38e3"
},
"downloads": -1,
"filename": "aspose_cells_python-24.11.0-py3-none-macosx_10_14_x86_64.whl",
"has_sig": false,
"md5_digest": "dacb2b3ade576a63d60434d9f4c27b30",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": "<3.14,>=3.6",
"size": 86782224,
"upload_time": "2024-11-13T12:13:34",
"upload_time_iso_8601": "2024-11-13T12:13:34.691954Z",
"url": "https://files.pythonhosted.org/packages/9f/86/520944c179fa5dafe57094b68edfe89894661b7212d51074c1878422c5f2/aspose_cells_python-24.11.0-py3-none-macosx_10_14_x86_64.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "8b7cc0abb43c5b08a9eeb8df6b362aa77158ed21759394084491289e1ed52972",
"md5": "ce609f94e2dec7948fee9503508332c3",
"sha256": "3a99998680cc5ec553cb96e7e9d69baaba9444d8c1ae6f83a36004d2b9c1f547"
},
"downloads": -1,
"filename": "aspose_cells_python-24.11.0-py3-none-macosx_11_0_arm64.whl",
"has_sig": false,
"md5_digest": "ce609f94e2dec7948fee9503508332c3",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": "<3.14,>=3.6",
"size": 72333856,
"upload_time": "2024-11-13T12:12:29",
"upload_time_iso_8601": "2024-11-13T12:12:29.432068Z",
"url": "https://files.pythonhosted.org/packages/8b/7c/c0abb43c5b08a9eeb8df6b362aa77158ed21759394084491289e1ed52972/aspose_cells_python-24.11.0-py3-none-macosx_11_0_arm64.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "2c6fa20913f427db1f7b0da281ab9c9f4b994d5dd3e2c325f669a468cb2550dc",
"md5": "c4d3c3db7de0d82076bc5451ef8bd25b",
"sha256": "3459d852b27c4fba6ec3f84a022e7b35b154a5c31c7f1bd0bbfbe37961896b7d"
},
"downloads": -1,
"filename": "aspose_cells_python-24.11.0-py3-none-manylinux1_x86_64.whl",
"has_sig": false,
"md5_digest": "c4d3c3db7de0d82076bc5451ef8bd25b",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": "<3.14,>=3.6",
"size": 91283508,
"upload_time": "2024-11-13T12:12:01",
"upload_time_iso_8601": "2024-11-13T12:12:01.218778Z",
"url": "https://files.pythonhosted.org/packages/2c/6f/a20913f427db1f7b0da281ab9c9f4b994d5dd3e2c325f669a468cb2550dc/aspose_cells_python-24.11.0-py3-none-manylinux1_x86_64.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "e5d449d0939111a16e508df2c1977ba66fc5a2a3fcc66c89632451e58ed353d0",
"md5": "35ab47c935c66e3540f56b14bc3ebc1e",
"sha256": "c6a14d2646c8cec4e7aac7feeae3db85144a933375dd79e9ebf5120ca678e45a"
},
"downloads": -1,
"filename": "aspose_cells_python-24.11.0-py3-none-win32.whl",
"has_sig": false,
"md5_digest": "35ab47c935c66e3540f56b14bc3ebc1e",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": "<3.14,>=3.6",
"size": 52770223,
"upload_time": "2024-11-13T12:22:58",
"upload_time_iso_8601": "2024-11-13T12:22:58.630602Z",
"url": "https://files.pythonhosted.org/packages/e5/d4/49d0939111a16e508df2c1977ba66fc5a2a3fcc66c89632451e58ed353d0/aspose_cells_python-24.11.0-py3-none-win32.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "aa62097b8eac23256ce64f600c43b8e5105d3476d240c440f4569215e393e477",
"md5": "44f184808ff22646f74046b954c5a633",
"sha256": "6f8fe8a021e1460dabc8ba91bbc7011ed4600f7d1d867130f575e76f1bfd3108"
},
"downloads": -1,
"filename": "aspose_cells_python-24.11.0-py3-none-win_amd64.whl",
"has_sig": false,
"md5_digest": "44f184808ff22646f74046b954c5a633",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": "<3.14,>=3.6",
"size": 62178664,
"upload_time": "2024-11-13T12:14:09",
"upload_time_iso_8601": "2024-11-13T12:14:09.197488Z",
"url": "https://files.pythonhosted.org/packages/aa/62/097b8eac23256ce64f600c43b8e5105d3476d240c440f4569215e393e477/aspose_cells_python-24.11.0-py3-none-win_amd64.whl",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-11-13 12:13:34",
"github": false,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"lcname": "aspose-cells-python"
}
