Free Support Forum - aspose.cloud

How to merge/combine several Microsoft Excel files into single Workbook with Aspose.Cells REST API

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

@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.