Merge Excel Files in Cloud - Combine Spreadsheets Online with Aspose.Cells Cloud API

Quickly merge Excel files stored in the cloud with other spreadsheets using Aspose.Cells Cloud API, and flexibly specify the output data format and storage location.

Merge Remote Spreadsheet API

API Endpoint

PUT http://api.aspose.cloud/v4.0/cells/{name}/merge/spreadsheet

Request Parameters:

Parameter Name Type Path/Query String/HTTPBody Description
name String Path The name of the source workbook file to be merged.
mergedSpreadsheet String Query A comma-separated list of spreadsheet file names to merge into the source workbook.
folder String Query The folder path in cloud storage containing the source workbook.
outFormat String Query The desired format for the merged output file (e.g., XLSX, PDF, CSV).
mergeInOneSheet Boolean Query If set to true, merges data from all source files into a single worksheet. If false, each file’s content is placed in separate worksheets.
storageName String Query (Optional) The name of the cloud storage where the source workbook resides. If omitted, the default cloud storage is used.
outPath String Query (Optional) The target folder path in cloud storage for saving the merged file. If omitted, the merged file is saved in the source folder.
outStorageName String Query The name of the cloud storage for saving the output file.
fontsLocation String Query (Optional) Specifies a custom folder path for font files used during conversion to image/PDF formats.
region String Query (Optional) Sets the locale/region for date, number, and currency formatting in the output file (e.g., en-US, de-DE).
password String Query (Optional) The password required to open the source workbook if it is password-protected.

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 we use the Merge Remote Spreadsheet API?

Enterprise-Grade Data Integration

  • Multi-Department Report Consolidation: Consolidate separate Excel reports submitted by sales, marketing, finance, and more.
  • Branch Data Summary: A performance data file that summarizes the performance data of each branch nationwide or globally.
  • Partner Data Consolidation: Consolidate data submissions from multiple partners.

Cloud Document Processing Process

  • Cloud Storage File Processing: Directly merge Excel files stored in AWS S3, Azure Blob, and Google Cloud Storage.
  • Multi-Source Data Consolidation: Consolidate files from different cloud locations into a single file.
  • Automated Data Pipelines: Integrate into data ETL processes to automate file merging.

Document Management Automation

  • Version Control Consolidation: Consolidate different versions of a project plan or budget file.
  • Template Data Population: Incorporate data files into standardized reporting templates.
  • Regular Report Generation: Automate the generation of weekly, monthly, and quarterly summary reports.

Cross-Platform Collaboration

  • Remote Team Collaboration: Consolidate work submitted by dispersed team members.
  • Customer Data Organization: Consolidate order or feedback data from different customers.
  • Supplier Information Summary: Consolidate quotes or product information from multiple suppliers.

Why should you use the Merge Remote Spreadsheet 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 Remote Spreadsheet API with SDKs

Merge Remote Spreadsheet API Specification

The Merge Remote Spreadsheet API Specification provides a publicly accessible programming interface for executing REST interactions directly from a web browser.

Excel API SDK

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 a spreadsheet into another spreadsheet 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 interact with Aspose.Cells web services using various SDKs: