Split the Spreadsheet into separate files.

Split the local spreadsheet into separate files with 30 output file formats without requiring cloud storage.

Split Spreadsheet API

PUT http://api.aspose.cloud/v4.0/cells/split/spreadsheet

Request Parameters:

Parameter Name Type Path/Query String/HTTPBody Description
Spreadsheet File FormData Upload the spreadsheet file to be split.
from Integer Query Specify the beginning worksheet index.
to Integer Query Specify the ending worksheet index.
outFormat String Query Define the output file format.
outPath String Query (Optional) The folder path for storing the output workbook. Defaults to null.
outStorageName String Query Define the output file storage name.
fontsLocation String Query Specify custom fonts if required.
regoin String Query Set the spreadsheet region.
password String Query Provide the password for accessing the spreadsheet file.

Response

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

Error Codes

  • 400 Bad Request: Invalid Apose.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 we use the Split Spreadsheet API?

When you need to split a spreadsheet to more files, you can use this API.

Why should you use the Split Spreadsheet API?

  • No need for cloud storage space, just split directly.
  • Development can be quickly completed through the existing SDK.

How to Use the Split Spreadsheet API with SDKs

Split Spreadsheet API Specification

The Split Spreadsheet API Specification provides a publicly accessible programming interface for performing 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 split spreadsheet into separate files with short code. Please check out the GitHub repository for a complete list of Aspose.Cells Cloud SDKs.

The following code examples illustrate how to invoke Aspose.Cells web services using different SDKs: