Merge matching spreadsheet files into a file in a remote Folder.

Merge matching spreadsheet files from a remote cloud folder and export to 30+ supported formats like PDF, CSV, JSON, ODS, and XPS using Aspose.Cells Cloud API.

Merge Spreadsheets in Remote Folder API

API Endpoint

PUT http://api.aspose.cloud/v4.0/cells/merge/remote-spreadsheets

Request Parameters:

Parameter Name Type Path/Query String/HTTPBody Description
folder String Query The source folder path in cloud storage where the spreadsheet files to be merged are located.
fileMatchExpression String Query A string expression or pattern to filter and select matching files in the source folder for merging (e.g., "*report*.xlsx").
outFormat String Query Specifies the output file format after merging (e.g., PDF, CSV, JSON, XLSX). Supports 30+ common formats.
mergeInOneSheet Boolean Query When true, merges content from all matched files into a single worksheet. When false, each file’s content is kept in separate worksheets.
storageName String Query (Optional) The name of the cloud storage where source files reside. If omitted, the default cloud storage is used.
outPath String Query (Optional) Specifies the target folder path in cloud storage where the merged file will be saved. If omitted, the merged file is saved in the source folder.
outStorageName String Query The name of the cloud storage where the output merged file will be saved.
fontsLocation String Query (Optional) Specifies a custom folder path containing font files to ensure proper text rendering when exporting to PDF or image formats.
region String Query (Optional) Sets the locale/region for number, date, and currency formatting in the output file (e.g., "en-US", "de-DE").
password String Query (Optional) If any matched spreadsheet file is password-protected, provide the password to open the file.

Response

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

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 we use the Merge Spreadsheet in remote folder API?

When you need to merge multiple data files together, you can use this API.

Why should you use the Merge Spreadsheet in remote folder 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.

How to Use the Merge Spreadsheet in remote folder API with SDKs

Merge Spreadsheet in remote folder API Specification

The Merge Spreadsheet in remote folder API Specification provides a publicly accessible programming interface allowing 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 merge matching spreadsheet files into files in remote folder 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 interact with Aspose.Cells web services using various SDKs: