PDF、組版と文書変換のアンテナハウス株式会社

サイトマップ

Antenna House Office Servers SpreadSheet API Usage Example
~Merge multiple Excel files into one file~

This page introduces how to use the Excel sheet feature of the "Antenna House Office Servers SpreadSheet API" to merge multiple Excel files into one file. The sample file is free to download, so please use it together with the evaluation version.

Using sample files
  • You are free to modify the file after downloading, but commercial use and reprinting are strictly prohibited.
  • In principle, the sample files shown here are corresponding to the latest version of "Antenna House Office Servers SpreadSheet API".

Sales report for each department

The Excel file of the sales report for each individual product submitted by each department in the company can be merged into one file with the "Antenna House Office Servers SpreadSheet API". The file name of each Excel file is reflected in the sheet name.

Sample file Download:sellmerge.zip

  • cover.xlsx: The file to be merged. Cover of the sales report.
  • "Product A Sales.xlsx" to "Product E Sales.xlsx": 5 Excel files to be merged.
cover
The file to be merged. (cover.xlsx)

monthlyreport-en
5 Excel files to be merged ("Product A Sales.xlsx" to "Product E Sales.xlsx")

report-en
Result of merging (salesreport.xlsx)

スペース