Manipulate Excel Spreadsheets in Cloud

Create, Manipulate, Convert or Protect Excel spreadsheets (10+ file formats) using Aspose.Cells Cloud SDK for Python.

  Start Free Trial
Aspose.Cells Cloud SDK for Python

Aspose.Cells Cloud SDK for Python


Excel Spreadsheet Processing using Python

In order to get started with Aspose.Cells Cloud SDK for Python, you don't need to install anything. All you need to do is create an account at Aspose for Cloud and get your application information. Once you have the App SID & key, you are ready to use Aspose.Cells Cloud SDK for Python to create, edit, and convert spreadsheets. It also allows you to extract data from the spreadsheets for further processing or storage.


Advanced Excel Spreadsheet Cloud SDK Features



Create spreadsheets from templates, XML or smart markers


Split spreadsheets to single worksheet spreadsheets


Merge multiple spreadsheets


Convert spreadsheets to different formats


Manipulate rows, columns, cells & data


Encrypt & de-crypt spreadsheets


Protect & unprotect workbooks & worksheets


Export worksheets to images


Auto fit rows


Set complex formula


Add & update text & images


Manipulate comments


Hide & show worksheets


Extract charts, pictures, shapes & other objects as images

Support for Various File Formats

Using Aspose.Cells Cloud SDK for Python, developers can easily open and save a multitude of file formats. These include XLS, XLSX, XLSM, XLTX, XLTM, ODS, Tab delim., CSV, TXT, PDF, SpreadsheetML, HTML, TIFF, JPG, PNG, BMP and SVG. The Office Open XML (OOXML) is a container format for several specialized XML-based markup languages. OOXML SpreadsheetML documents mostly come as XLSX files, which are ZIP packages. In addition to XLSX format, Aspose.Cells Cloud SDK for Python also offers an extensive support for converting SpreadsheetML documents.

Manage Worksheets using Python

Aspose.Cells Cloud SDK for Python gives you complete control over spreadsheets and the data in them. The Excel cloud SDK for Python helps you create formulas and make sophisticated calculations based on user input or external data sources. You may use it to work with individual cells in a spreadsheet, add comments, apply validation rules and manage hyperlinks & pictures. The SDK also allows to manipulate all aspects of the spreadsheets including worksheets, rows, columns, cells, text, data, images, links, comments, charts and many more. Aspose.Cells Cloud SDK for Python puts these features at your fingertips, through a cloud-based SDK.

Manage or Extract Contents from Excel Spreadsheet

Get the ability to add or remove data in cell elements. The data may include comments, pictures, hyperlinks and any validation rules applied over cells. In fact, Aspose.Cells Cloud SDK for Python is a complete solution in the cloud exposed as a REST interface. It also enables you to extract text, images, data and many other objects from the Excel spreadsheets while using simple interfaces exposed by Cloud based SDK for Python.

Set Formula for a Cell in Excel Worksheets - Python

#Instantiate Aspose.Cells Cloud SDK for Python
api_client = asposecellscloud.ApiClient.ApiClient(apiKey, appSid, True)
cellsApi = CellsApi(api_client);
#upload file to Aspose cloud storage
storageApi.PutCreate(Path=filename, file=data_folder + filename)
#invoke API to set formula for a cell in a worksheet
response = cellsApi.PostWorksheetCellSetValue(name="Sample_Test_Book.xls", sheetName="Sheet1", cellName=a12, type="int", formula="sum(a5:a10)")

if response.Status == "OK":
    #download updated Workbook from storage server
    response = storageApi.GetDownload(Path="Sample_Test_Book.xls")
    outfilename = "c:/temp/" + "Sample_Test_Book.xls"
    with open(outfilename, 'wb') as f:
        for chunk in response.InputStream:

Render Spreadsheets as Images

Aspose.Cells Cloud SDK for Python supports rendering Excel spreadsheets, Charts, AutoShapes and OleObjects to most commonly used image formats like JPG, BMP, GIF, PNG. During conversion, Aspose.Cells Cloud SDK for Python ensures accuracy and precision.

High Fidelity Conversion of Spreadsheets

The output of SDK conforms to PDF 1.5 or PDF/A-1b specifications and SDK goes an extra mile while performing the conversion of Microsoft Excel documents to PDF format with a high degree of precision. As a result, majority of conversions will be indistinguishable from the original Microsoft Excel document..

Convert Excel workbook to PDF - Python

#upload file to aspose cloud storage
storageApi.PutCreate(Path="Sample_Test_Book.xls", file="../../data/"+ "Sample_Test_Book.xls")
#invoke API to convert workbook to PDF format
response = cellsApi.PostDocumentSaveAs(name= "Sample_Test_Book.xls", body=SaveOptions.SaveOptions(), newfilename="Resultant.pdf")
#download Workbook from storage server
response = storageApi.GetDownload(Path=response.SaveResult.DestDocument.Href)

Handle Worksheet Data

Aspose.Cells Cloud SDK for Python allows you to manipulate spreadsheet data including text, numeric or alphanumeric with the help of simple API methods. You can add, modify or remove data from cells as well as add and calculating formulas in a worksheet cell to get the resultant value.


Support and Learning Resources


Aspose.Cells also offers individual Workbook processing SDKs for other popular languages as listed below: