Python API to merge multiple Excel files into a file.

Python library to merge multi Excel files into a file.

Use Cells Merge REST API to merge multiple Excel files into a file in Python. This professional solution merge multiple Excel files into a Microsoft Excel or OpenOffice Calc spreadsheet using Python.

Merge multiple Excel files into a file - Python REST API

API Request:
POST
https://api.aspose.cloud/v3.0/cells/merge

Merging multiple Excel files into a file is a complex task. Merging multiple Excel files into a file transitions is performed by our Python SDK while maintaining the source spreadsheet's main structural and logical content. Our Python library is a professional solution to merge multiple Excel files into a file online. This Cloud SDK gives Python developers powerful functionality and perfect API.

Code example in Python using REST API to merging multiple Excel files into a file

# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python
import os
from asposecellscloud.apis.cells_api import CellsApi
from asposecellscloud.models import *
from asposecellscloud.requests import *
CellsCloudClientId ='....' # get from https://dashboard.aspose.cloud/#/applications
CellsCloudClientSecret='....' # get from https://dashboard.aspose.cloud/#/applications
api = CellsApi(CellsCloudClientId,CellsCloudClientSecret)
request = PostMergeRequest( { 'assemblytest.xlsx': 'assemblytest.xlsx' ,'datasource.xlsx': 'datasource.xlsx' },out_format= 'pdf',merge_to_one_sheet= True)
api.post_merge(request)


How to use Python API to merge


  1. Create an account at Dashboard to get free API quota & authorization details
  2. Initialize CellsApi with Client Id, Client Secret, Base URL & API version
  3. Call post_merge method to get the resultant stream


System Requirements


  1. Python 2.7 or newer
  2. Python 3.10 or newer