Python API to merge multiple Excel files into a file.
Python library to merge multi Excel files into a file.
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
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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
- Create an account at Dashboard to get free API quota & authorization details
- Initialize CellsApi with Client Id, Client Secret, Base URL & API version
- Call post_merge method to get the resultant stream
System Requirements
- Python 2.7 or newer
- Python 3.10 or newer