Python Cloud SDK wraps Aspose.Cells REST API so you could seamlessly integrate Microsoft Excel® spreadsheet generation, manipulation, conversion & inspection features into your own Python applications.
Project description
Python SDK for Spreadsheet Processing in Cloud
Python Cloud SDK wraps Aspose.Cells REST API so you could seamlessly integrate Microsoft Excel® spreadsheet generation, manipulation, conversion & inspection features into your own Python applications.
Aspose.Cells Cloud SDK for Python offers Excel® file creation, editing, 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 built-in and custom formulas and much more.
Manipulate Excel Files in the Cloud with Python
- Create Excel files via API.
- Create & refresh Pivot Tables & charts.
- Create & manipulate spark-lines & conditional formatting.
- Convert charts, worksheets or data ranges 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.
Feature & Enhancements in Version 23.9
Full list of issues covering all changes in this release:
- Support to data sorting on range controller.
- Support to remove duplicate data on list object.
- Support to insert slicer for list object.
- Optimize list object and related objects.
Read & Write Spreadsheet Formats
Microsoft Excel: XLS, XLSX, XLSB, XLSM, XLT, XLTX, XLTM OpenOffice: ODS SpreadsheetML: XML Text: CSV, TSV, TXT (TabDelimited) Web: HTML, MHTML
Save Spreadsheets As
Microsoft Excel: XLS, XLSX, XLSB OpenOffice: ODS SpreadsheetML: XML Text: CSV, TSV, TXT (TabDelimited) Web: HTML, MHTML Fixed Layout: PDF, XPS Images: PNG, JPG, TIFF, SVG Markdown: MD Other: DIF
Read Other Formats
SXC, FODS
Integrated Storage API
Since version 19.9, SDK includes support of storage operations for better user experience and unification. It gives you an ability to;
- Upload, download, copy, move and delete files, including versions handling (if you are using Cloud storage that supports this feature - true by default).
- Create, copy, move and delete folders.
- Copy and move files and folders across separate storages in scope of a single operation.
- Check if certain file, folder or storage exists.
Gett Started with Aspose.Cells Cloud SDK for Python
Firstly, create an account at Aspose for Cloud to get your application information. Next, execute pip install asposecellscloud
from the command line to get the SDK from PIP. The complete source code is also available at GitHub Repository.
Create Spreadsheet from a Template in the Cloud via Python
#Instantiate Aspose Cells API SDK
cellsApi = asposecellscloud.apis.cells_api.CellsApi(GetClientId(),GetClientSecret(),"v3.0")
templateFile ='Book1.xlsx'
folder = "Temp"
name = "NewBook" + datetime.now().strftime("%Y%m%d%H%M%S") + ".xlsx"
dataFile = "ReportData.xml"
template_file = folder + "/" + templateFile
data_file = folder + "/" + dataFile
fullfilename = os.path.dirname(os.path.realpath(__file__)) + "/" + templateFile
api.upload_file(template_file, fullfilename)
fullfilename = os.path.dirname(os.path.realpath(__file__)) + "/" + data_file
api.upload_file(data_file, fullfilename)
result = cellsApi.cells_workbook_put_workbook_create(name, template_file=template_file, data_file=data_file, folder=folder)
self.assertEqual(result.code,200)
Convert Excel to PDF via Python
#Instantiate Aspose Cells API SDK
cellsApi = asposecellscloud.apis.cells_api.CellsApi(GetClientId(),GetClientSecret(),"v3.0")
fullfilename = os.path.dirname(os.path.realpath(__file__)) + "/../TestData/" + "Book1.xlsx"
format ='pdf'
password = None
outPath = None
result = cellsApi.cells_workbook_put_convert_workbook(fullfilename,format=format)
# self.assertEqual(result.code,200)
Aspose.Cells Cloud SDKs in Popular Languages
.NET | Java | PHP | Ruby | Node.js | Android | Swift | Perl | GO |
---|---|---|---|---|---|---|---|---|
GitHub | GitHub | GitHub | GitHub | GitHub | GitHub | GitHub | GitHub | GitHub |
NuGet | Maven | Composer | GEM | NPM | Maven | POD | CPAN | GO |
Product Page | Documentation | Live Demo | API Reference | Code Samples | Blog | Free Support | Free Trial
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for asposecellscloud-23.9-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6b542911d38696fc83ab313d04c9dec1c1d4c00bba65f091f05262235be0747b |
|
MD5 | 7cf6acb31d7c8836567ec82baf3d3d2f |
|
BLAKE2b-256 | d46d9cc3c4ce3e62ffd5ae85dbbce84ef19188cd2cff38c7b1a6112f99d08c95 |