将 Excel 工作簿合并到其他 Excel 文件

此 REST API 表示将 Excel workbook 合并到其他 Excel 工作簿中。

查询参数

参数名称	类型	描述
文件夹	细绳	原始工作簿文件夹。
存储名称	细绳	存储名称。

休息 API

API	类型	描述	Swagger 链接
/单元格/{名称}/合并	邮政	合并 Excel 工作簿	工作簿合并

这OpenAPI 规范定义一个可公开访问的编程接口，并允许您直接从 Web 浏览器执行 REST 交互。

您可以使用cURL命令行工具可轻松访问 Aspose.Cells Web 服务。以下示例显示如何使用 cURL 调用云 API。

Request


curl -X POST "https://api.aspose.cloud/v3.0/cells/test.xlsx/merge?mergeWith=test2.xlsx" -H "accept: application/json"

Response


{

  "Workbook": {

    "FileName": "test.xlsx",

    "Links": [

      {

        "Href": "/test.xlsx",

        "Rel": "self",

        "Title": null,

        "Type": null

      },

      {

        "Href": "/test.xlsx",

        "Rel": "alternate",

        "Title": "Download As CSV",

        "Type": "text/csv"

      },

      {

        "Href": "/test.xlsx",

        "Rel": "alternate",

        "Title": "Download As HTML",

        "Type": "text/html"

      },

      {

        "Href": "/test.xlsx",

        "Rel": "alternate",

        "Title": "Download As ODS",

        "Type": "application/vnd.oasis.opendocument.spreadsheet"

      },

      {

        "Href": "/test.xlsx",

        "Rel": "alternate",

        "Title": "Download As PDF",

        "Type": "application/pdf"

      },

      {

        "Href": "/test.xlsx",

        "Rel": "alternate",

        "Title": "Download As Table Delimited Text Format",

        "Type": "text/plain"

      },

      {

        "Href": "/test.xlsx",

        "Rel": "alternate",

        "Title": "Download As TIFF",

        "Type": "image/tiff"

      },

      {

        "Href": "/test.xlsx",

        "Rel": "alternate",

        "Title": "Download As Microsoft Excel 2003",

        "Type": "application/vnd.ms-excel"

      },

      {

        "Href": "/test.xlsx",

        "Rel": "alternate",

        "Title": "Download As Microsoft Excel 2007",

        "Type": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"

      },

      {

        "Href": "/test.xlsx",

        "Rel": "alternate",

        "Title": "Download As XPS",

        "Type": "application/vnd.ms-xpsdocument"

      }

    ],

    "Worksheets": {

      "link": {

        "Href": "/worksheets",

        "Rel": "self",

        "Title": null,

        "Type": null

      }

    },

    "DefaultStyle": {

      "link": {

        "Href": "/defaultstyle",

        "Rel": "self",

        "Title": null,

        "Type": null

      }

    },

    "DocumentProperties": {

      "link": {

        "Href": "/documentproperties",

        "Rel": "self",

        "Title": null,

        "Type": null

      }

    },

    "Names": {

      "link": {

        "Href": "/names",

        "Rel": "self",

        "Title": null,

        "Type": null

      }

    },

    "Settings": {

      "link": {

        "Href": "/settings",

        "Rel": "self",

        "Title": null,

        "Type": null

      }

    },

    "IsWriteProtected": "False",

    "IsProtected": "False",

    "IsEncryption": "false",

    "Password": null

  },

  "Code": 200,

  "Status": "OK"

}


Response headers

Cloud SDK 系列

使用 SDK 是加快开发速度的最佳方式。SDK 负责处理底层细节，让您专注于项目任务。请查看GitHub 存储库获得 Aspose.Cells Cloud SDKs 的完整列表。

以下代码示例演示了如何使用各种 SDK 调用 Aspose.Cells Web 服务：

	// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/
	namespace Aspose.Cells.Cloud.SDK.Example
	{
	using Aspose.Cells.Cloud.SDK.Api;
	using Aspose.Cells.Cloud.SDK.Request;
	using System;

	public partial class CellsApiExample
	{
	public void PostWorkbooksMergeExample()
	{
	string CellsCloudClientId ="....";//get from https://dashboard.aspose.cloud/#/applications
	string CellsCloudClientSecret="...";//get from https://dashboard.aspose.cloud/#/applications
	PostWorkbooksMergeRequest request = new PostWorkbooksMergeRequest { name = "Book1.xlsx", mergeWith = "myDocument.xlsx", folder = "TestData/In" };
	cellsApi.PostWorkbooksMerge(request);
	}
	}
	}
	// Obsolete
	//CellsWorkbookApi instance = new CellsWorkbookApi(GetConfiguration());
	//string name = "Book1.xlsx";
	//string mergeWith = "myDocument.xlsx";
	//string folder = null;
	//UpdateDataFile(folder, name);
	//UpdateDataFile("", mergeWith);
	//var response = instance.CellsWorkbookPostWorkbooksMerge(name, mergeWith, folder);

view raw Examples-.NET-CellsWorkbookPostWorkbooksMerge.cs hosted with ❤ by GitHub

Java

	package com.aspose.cloud.cells.api;
	import com.aspose.cloud.cells.client.*;
	import com.aspose.cloud.cells.model.*;
	import com.aspose.cloud.cells.request.*;
	import java.io.IOException;
	import org.junit.Test;
	import java.util.ArrayList;
	import java.util.List;
	import java.io.File;
	import java.util.HashMap;

	public class Example {
	private CellsApi api;
	public Example(){
	try {
	api = new CellsApi(
	System.getenv("CellsCloudClientId"),
	System.getenv("CellsCloudClientSecret"),
	"v3.0",
	System.getenv("CellsCloudApiBaseUrl")
	);
	} catch (ApiException e) {
	e.printStackTrace();
	}
	}
	public void Run(){
	try{
	String remoteFolder = "TestData/In";

	String localName = "Book1.xlsx";
	String remoteName = "Book1.xlsx";

	UploadFileRequest uploadFileRequest = new UploadFileRequest();
	uploadFileRequest.setPath( remoteFolder + "/" + remoteName );
	uploadFileRequest.setStorageName( "");
	HashMap<String,File> files = new HashMap<String,File>();
	files.put( localName , new File(localName ));
	uploadFileRequest.setUploadFiles(files);
	api.uploadFile(uploadFileRequest);
	PostWorkbooksMergeRequest request = new PostWorkbooksMergeRequest();
	request.setName(remoteName);
	request.setMergeWith("myDocument.xlsx");
	request.setFolder(remoteFolder);
	request.setStorageName("");
	request.setMergedStorageName("");


	WorkbookResponse response = api.postWorkbooksMerge(request);

	} catch (ApiException e) {
	e.printStackTrace();
	}catch (IOException e) {
	e.printStackTrace();
	}
	}
	}

view raw Examples-Java-workbook-MergeWorkbooks-merge-excel-workbooks.java hosted with ❤ by GitHub

PHP

	<?php
	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
	require_once('vendor\autoload.php');
	use \Aspose\Cells\Cloud\Api\CellsApi;
	use \Aspose\Cells\Cloud\Request\PostWorkbooksMergeRequest;

	class Workbook {

	public $instance;

	public function __construct() {
	$this->instance = new CellsApi(getenv("CellsCloudClientId"),getenv("CellsCloudClientSecret"),"v3.0",getenv("CellsCloudApiBaseUrl"));
	}

	public function postWorkbooksMerge() {
	$remoteFolder = "TestData/In";

	$localName = "Book1.xlsx";
	$myDocumentXLSX = "myDocument.xlsx";
	$remoteName = "Book1.xlsx";
	$request = new PostWorkbooksMergeRequest();
	$request->setName( $remoteName);
	$request->setMergeWith( $remoteFolder . "/myDocument.xlsx");
	$request->setFolder( $remoteFolder);
	$request->setStorageName( "");
	$request->setMergedStorageName( "");
	$this->instance->postWorkbooksMerge($request);
	}
	}

	$workbook = new Workbook();
	$workbook->postWorkbooksMerge();

	?>

view raw Examples-PHP-Workbook-PostWorkbooksMerge-.php hosted with ❤ by GitHub

Ruby

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-ruby
	require 'aspose_cells_cloud'

	class Workbook

	include AsposeCellsCloud

	def initialize
	#Get client_id and client_secret from https://cloud.aspose.com

	@instance = AsposeCellsCloud::CellsApi.new($client_id,$client_secret,$api_version,$baseurl)
	end

	# Merge workbooks.
	def merge_workbooks
	name = $BOOK1
	merge_with = 'myDocument.xlsx'
	folder = $TEMPFOLDER
	result = @instance.upload_file( folder+"/"+name, ::File.open(File.expand_path("data/"+name),"r") {\|io\| io.read(io.size) })
	result = @instance.upload_file( folder+"/"+merge_with, ::File.open(File.expand_path("data/"+merge_with),"r") {\|io\| io.read(io.size) })
	expect(result.uploaded.size).to be > 0
	result = @instance.cells_workbook_post_workbooks_merge(name,(folder+"/"+ merge_with), { :folder=>folder})
	expect(result.code).to eql(200)
	end

	end

	workbook = Workbook.new()
	puts workbook.merge_workbooks

view raw Examples-Ruby-Workbook-merge_workbooks-.rb hosted with ❤ by GitHub

Python

	# 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 = PostWorkbooksMergeRequest( 'Book1.xlsx', 'myDocument.xlsx',folder= 'PythonTest',storage_name= '',merged_storage_name= '')
	api.post_worksheet_merge(request)

view raw MergeExcelWorkbooks.py hosted with ❤ by GitHub

Node.js

	const { CellsApi, UploadFileRequest, CellsWorkbook_PostWorkbooksMergeRequest } = require("asposecellscloud");
	const clientId = process.env.CellsCloudClientId;
	const clientSecret = process.env.CellsCloudClientSecret;
	const ApiURL = process.env.CellsCloudApiBaseUrl;
	const fs = require('fs');
	const path = require('path');
	const cellsApi = new CellsApi(clientId, clientSecret,"v3.0",ApiURL);
	const localPath = "D:/aspose-cells-cloud-node/TestData/"

	const filename = "Book1.xlsx";
	const data =fs.createReadStream(path.join(localPath, filename));

	const req = new UploadFileRequest({
	path: "Temp/" + filename,
	file: data
	});
	cellsApi.uploadFile(req)
	.then((result) => {

	const req = new CellsWorkbook_PostWorkbooksMergeRequest();
	req.name = filename;
	req.folder = "Temp";
	req.mergeWith = "myDocument.xlsx";
	cellsApi.cellsWorkbookPostWorkbooksMerge(req)
	.then((result) => {
	console.log("successful")

	}).catch((error) => {
	console.error('Unhandled Promise Rejection:', error);
	})
	})

view raw Examples-Node.js-SDK-Workbook-MergeWorkbooks-1.js hosted with ❤ by GitHub

Android

Swift

Perl

	# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-perl/
	use strict;
	use warnings;
	use utf8;
	use File::Slurp;
	use MIME::Base64;
	use AsposeCellsCloud::CellsApi;
	my $config = AsposeCellsCloud::Configuration->new( client_id => $ENV{'ProductClientId'}, client_secret => $ENV{'ProductClientSecret'});
	my $instance = AsposeCellsCloud::CellsApi->new(AsposeCellsCloud::ApiClient->new( $config));

	my $remoteFolder = 'TestData/In';

	my $localName = 'Book1.xlsx';
	my $myDocumentXLSX = 'myDocument.xlsx';
	my $remoteName = 'Book1.xlsx';
	my $request = AsposeCellsCloud::Request::PostWorkbooksMergeRequest->new();
	$request->{name} = $remoteName;
	$request->{merge_with} = $remoteFolder . $myDocumentXLSX;
	$request->{folder} = $remoteFolder;
	$request->{storage_name} = '';
	$request->{merged_storage_name} = '';
	my $result = $api->post_workbooks_merge(request=> $request);

view raw Examples-Perl-Workbook-MergeWorkbooks-1.pl hosted with ❤ by GitHub

Swift

将多个 Excel 文件合并为一个 Excel 文件