Slå samman flera Excel-filer till en Excel-fil|Aspose.Cells Cloud Documen

Parameternamn	Typ	Sökväg/Frågesträng/HTTPBody	Beskrivning
fil	fil	formData	Fil att ladda upp
formatera	sträng	fråga	xlsx
mergeToOneSheet	booleskt	fråga	Falsk

	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 AssemblyTestXlsx = "assemblytest.xlsx";
	String DataSourceXlsx = "datasource.xlsx";
	HashMap<String,File> fileMap = new HashMap<String,File>();
	fileMap.put(AssemblyTestXlsx , new File(remoteFolder + AssemblyTestXlsx));
	fileMap.put(DataSourceXlsx , new File(remoteFolder + DataSourceXlsx) );


	PostMergeRequest request = new PostMergeRequest();
	request.setFile(fileMap);
	request.setFormat("png");
	request.setMergeToOneSheet(false);
	request.setPassword("");
	request.setCheckExcelRestriction(false);



	FileInfo response = api.postMerge(request);


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

Slå samman flera Excel-filer till en Excel-fil

	// 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;
	using System.Collections.Generic;
	using System.IO;

	public partial class CellsApiExample
	{
	public void PostMergeExample()
	{
	CellsApi cellsApi = new CellsApi(Environment.GetEnvironmentVariable("CellsCloudTestClientId"), Environment.GetEnvironmentVariable("CellsCloudTestClientSecret"));
	IDictionary<string, Stream> mapFiles = new Dictionary<string, Stream>();
	mapFiles.Add("assemblytest.xlsx", File.OpenRead(@".\TestData\assemblytest.xlsx"));
	mapFiles.Add("datasource.xlsx", File.OpenRead(@".\TestData\datasource.xlsx"));
	PostMergeRequest request = new PostMergeRequest { File = mapFiles, format = "pdf", mergeToOneSheet = true };
	cellsApi.PostMerge(request);
	}
	}
	}