Skip to main content

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

PyPI PyPI - Python Version PyPI - Downloads GitHub license GitHub commits since latest release (by date)

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 24.1.2

  • Update time operate question for iron python.

Feature & Enhancements in Version 24.1.3

  • Fix lost request files.

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

    cellsApi = CellsApi("YourClientId","YourClientSecret","v3.0","https://api.aspose.cloud")
    remote_folder = 'TestData/In'
    local_name = 'Book1.xlsx'
    report_data_xml = 'ReportData.xml'
    remote_name = 'Book1.xlsx'
    
    request =  PostWorkbookGetSmartMarkerResultRequest( remote_name,xml_file= remote_folder + '/' +report_data_xml,folder= remote_folder,out_path= 'OutResult/SmartMarkerResult.xlsx',storage_name= '',out_storage_name= '')
    cellsApi.post_workbook_get_smart_marker_result(request)

Convert Excel to PDF via Python

    #Instantiate Aspose Cells API SDK
    cellsApi = CellsApi("YourClientId","YourClientSecret","v3.0","https://api.aspose.cloud")
    local_name = 'Book1.xlsx'
    format = 'pdf'
    mapFiles = { 
        local_name:  "TestData/" +local_name             
    }
    request =  PutConvertWorkbookRequest( mapFiles,format= format)
    cellsApi.put_convert_workbook(request)

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


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

asposecellscloud-24.1.3.tar.gz (386.2 kB view hashes)

Uploaded Source

Built Distribution

asposecellscloud-24.1.3-py3-none-any.whl (1.6 MB view hashes)

Uploaded Python 3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page