Merging several XLS/XLSX files into single XLS/XLSX file


#1

Hi Aspose Forum Support,

We are in the need of merging several excel files into single excel file. Where each of these files are having 1 sheet.

Can we achieve this by using Cells Cloud API or any other Cloud API you have?

Thanks.

Best Regards,
Alex


#2

@eleganttech

Thank you for contacting Aspose Support.

POST /cells/{name}/merge API let you merge one Excel file with another. The cURL example would look as follows:

// First get Access Token
// Get App Key and App SID from https://dashboard.aspose.cloud/
curl -v "https://api.aspose.cloud/oauth2/token" \
-X POST \
-d 'grant_type=client_credentials&client_id=0B17F60A-6D69-426B-9ABD-79F35A6E9F7B&client_secret=53b8b19adffa41a3e87dbbd8858977ae' \
-H "Content-Type: application/x-www-form-urlencoded" \
-H "Accept: application/json"
  
// cURL example to merge one excel file with another
curl -v "https://api.aspose.cloud/v1.1/cells/sample.xlsx/merge?mergeWith=SmartMarker.xlsx" \
-X POST \
-H "Content-Type: application/json" \
-H "Accept: application/json" \
-H "Authorization: Bearer vYnS6-kO7MK7hLNvf_hskJDInELvxNCYp-Z7xyQ3dUbZO7aJQ0aZJzXBkoC02lroK0YMH_oWUy49xjVBkdrEFOEdVJGpeQO3u4uUtaF32_b2Q3mvP6nH1jLILAHbsie5AsBfXe3QJLudihUpRHH7Xoe9OYA-JmhA42PgYOK3kowhvyiGCL6MfjpGwYI_AvTeJylcbPqkCto_D_9RuD5QYcFsEo-gdIyO-UQfip4v2v_mxHgPcukIEDlIRvoMtoZ6CBsWRdcOy835DdAnI__jZdpv_EhiH8-F3D3C2zDiGNyXZHQWSQL_LVq8cpaHkHoZEM2F-bY2zunjFhCL2269SaI-sd8eJJ42oTuvwGQ5VL0xYppzQLUC6aUJW4FyRc5JBwe59pXqXLB-Iqzi1SZlZ8ZF62nA28GGBv9OTLr9tLC11x1O"

https://github.com/aspose-cells-cloud repository contains Cloud SDKs to use Aspose.Cells REST APIs. An SDK takes care of a lot of low-level details of making requests and handling responses and lets you focus on writing code specific to your particular project.