aspose-cells-python

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 using Python

.. 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 using Python

.. 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 using Aspose.Cells

.. 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>_