Combine Multiple Excel Files into One - Batch Merge Spreadsheets to 30+ Formats"

Batch merge multiple local spreadsheet files into one unified file. Convert the merged result to 30+ formats, including PDF, CSV, HTML, ODS, and XPS with Aspose.Cells Cloud Web API.

Merge Spreadsheet API

API Endpoint

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

Request Parameters:

Parameter Name Type Path/Query String/HTTP Body Description
Spreadsheet File FormData The local spreadsheet file to upload and process. Supports formats including XLSX, XLS, CSV, ODS, etc.
outFormat String Query The format of the output file after merging (e.g., XLSX, PDF, CSV, HTML). Supports 30+ common formats.
mergeInOneSheet Boolean Query When set to true, all data from the input file(s) is merged into a single worksheet. When false, each original sheet is preserved.
outPath String Query (Optional) Specifies the cloud folder path where the merged output file will be saved. If not provided, the file is stored in the default location.
outStorageName String Query The cloud storage name where the output file should be saved (e.g., default cloud storage or custom storage name).
fontsLocation String Query (Optional) Specifies a custom cloud folder path containing font files to ensure correct text rendering in PDF/image outputs.
region String Query (Optional) Sets the locale for formatting numbers, dates, and currency (e.g., en-US, zh-CN, de-DE) in the output file.
password String Query (Optional) If the uploaded spreadsheet is password-protected, provide the password for opening the 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 we use the Merge Local Spreadsheet API?

Education and Academic Applications

  • Student Assignment Grading: Merge multiple student assignment files for unified comments and grading
  • Research Data Collection: Merge data collection spreadsheets from different experimental groups
  • Teaching Material Creation: Merge exercises from multiple chapters into a unified question bank file

Data Processing and Analysis

  • Small Data Set Integration: Merge CSV or Excel data files exported from different sources
  • Data Analysis Preprocessing: Merge relevant data source files before conducting data analysis
  • Template Data Filling: Combine data files into pre-set report templates

Development and Technical Support

  • Test Data Preparation: Merge multiple test case files for automated testing
  • Log File Analysis: Merge Excel reports of system logs from different time periods
  • Configuration Management: Merge multiple configuration spreadsheets into a unified configuration file

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

OpenAPI Specification

The OpenAPI Specification provides a publicly accessible programming interface, allowing users to perform 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 multiple spreadsheets into a spreadsheet 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 make calls to Aspose.Cells web services using various SDKs: