How to Export the Remote Spreadsheet Range to other formats: Step-by-Step Guide

Export a cloud spreadsheet/Excel range to a format file. The format file can be saved in the cloud or exported to the local storage.

Export Range as Format API

API Endpoint

GET http://api.aspose.cloud/v4.0/cells/{name}/worksheets/{worksheet}/ranges/{range}

Request Parameters:

Parameter Name Type Path/Query String/HTTPBody Description
name String Path (Required) The name of the workbook file to be retrieved.
worksheet String Path The The worksheet name of Spreadsheet/Excel
range String Path The range to be converted (e.g., A1:C12).
format String Query (Required) The desired output format (e.g., “png”, “pdf”, “svg”).
folder String Query (Optional) The folder path where the workbook is stored. Defaults to null.
storageName String Query (Optional) The name of the storage if using custom cloud storage. Defaults to default storage if omitted.
outPath String Query (Optional) The folder path for the output file. Defaults to null.
outStorageName String Query The name of the output file storage.
fontsLocation String Query Custom fonts location.
region String Query The region setting of the spreadsheet.
password String Query The password required to open the spreadsheet file.

Response

[
    {
        "Name": "ResponseFile",
        "DataType": {
            "Identifier": "File",
            "Reference": "Stream"
        }
    }
]

Error Codes

  • 400 Bad Request: Invalid Aspose.Cells Cloud API URI.
  • 401 Unauthorized: Invalid access token. Or invalid client id and secret.
  • 404 Not Found: The spreadsheet file not accessible.
  • 500 Server Error: The spreadsheet has encountered an anomaly in obtaining calculation data.

Where should you use the Export Range to another format API?

Data Export & Migration Scenarios

  • Database Integration: Export specific Excel ranges directly to database systems
  • Application Integration: Feed selected spreadsheet data into SaaS applications
  • System Migration: Transfer specific data ranges between legacy and modern systems
  • Cross-Platform Sharing: Share focused data subsets across different platforms

Reporting & Analytics

  • Targeted Reporting: Export specific report sections to other format for focused analysis
  • Dashboard Data Feeds: Supply specific data ranges to BI dashboard tools
  • Performance Metrics: Extract KPI ranges for performance tracking systems
  • Financial Reporting: Export financial statement sections for external auditing

Development & Testing

  • Test Data Management: Export specific data ranges for testing purposes
  • Development Environments: Share sample data ranges with development teams
  • API Testing: Generate CSV test data from specific spreadsheet sections
  • Prototype Development: Provide focused data sets for application prototypes

Business Operations

  • Selective Data Sharing: Share specific data ranges with external partners
  • Partial Data Backup: Backup critical data ranges in data format
  • Departmental Data Transfer: Share specific data between departments
  • Compliance Reporting: Export regulatory data ranges for compliance submissions

Automation Workflows

  • Scheduled Range Exports: Automatically export specific ranges on schedule
  • Trigger-Based Extraction: Export ranges based on business events or triggers
  • Workflow Integration: Integrate range exports into business process workflows
  • Batch Range Processing: Process multiple specific ranges in batch operations

Why should you use the Export Range to another format API?

  • Developer-Friendly: Aspose.Cells Cloud offers SDK libraries in multiple languages, enabling quick development and comes with comprehensive documentation. Compared to building custom chart rendering solutions, this significantly reduces the development workload.
  • Reduced Labor Costs: Reduced the need for positions dedicated to document consolidation.
  • Pay-per-use: No upfront investment, only pay for API calls actually used.
  • Zero Maintenance Costs: No need to maintain servers, update software, or deal with compatibility issues.
  • Preserves complex Excel formatting in universally accessible PDF format.

How to Use the Export Spreadsheet Range as Format API with SDKs?

Export Range as Format API Specification

The Export Range as Format API Specification provides a publicly accessible programming interface, enabling REST interactions directly from a web browser.

Use Aspose.Cells Cloud SDKs

Using the SDK is the fastest way to develop, as it abstracts away the low-level details, allowing you to export a spreadsheet data of range to a format file with short code. Please check out the GitHub repository for a complete list of Aspose.Cells Cloud SDKs.

The following code examples demonstrate how to call Aspose.Cells web services using various SDKs:

Aspose.Cells Cloud Web API - Convert Local Excel Range to a CSV file - Free Online Tool