asposecellscloud 23.9

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.

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