Объединить Cells в рабочей таблице Excel

Этот REST API указывает на merge ячеек в файле Excel.

РСЕТ API

 
POST http://api.aspose.cloud/v3.0/cells/{name}/worksheets/{sheetName}/cells/merge

Параметры запроса:

Имя параметра	Тип	Путь/строка запроса/HTTPBody	Описание
имя	нить	путь	Имя рабочей книги.
имя листа	нить	путь	Имя рабочего листа.
startRow	целое число	запрос	Стартовый ряд.
startColumn	целое число	запрос	Стартовый столбец.
всего строк	целое число	запрос	Всего строк
итогостолбцы	целое число	запрос	Итоговые столбцы.
папка	нить	запрос	Папка рабочей книги.
имя_хранилища	нить	запрос	имя хранилища.

Спецификация OpenAPI определяет общедоступный интерфейс программирования и позволяет выполнять взаимодействие с REST непосредственно из веб-браузера.

Вы можете использовать инструмент командной строки cURL для легкого доступа к веб-службам Aspose.Cells. В следующем примере показано, как позвонить на Cloud API с помощью cURL.

Request

 
curl -v "https://api.aspose.cloud/v3.0/cells/test.xlsx/worksheets/Sheet1/cells/merge?startRow=10&startColumn=10&totalRows=10&totalColumns=10"  \
-X POST \
-H "Content-Type: application/json" \
-H "Accept: application/json" \
-H "Authorization: Bearer <jwt token>"

Response

{
"Code": 200,
"Status": "OK"
}

Семейство облачных SDK

Использование SDK — лучший способ ускорить разработку. SDK заботится о деталях низкого уровня и позволяет вам сосредоточиться на задачах проекта. Пожалуйста, ознакомьтесь сРепозиторий GitHub для получения полного списка Aspose.Cells Cloud SDK.

Следующие примеры кода демонстрируют, как выполнять вызовы веб-служб Aspose.Cells с использованием различных SDK:

	// 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 PostWorksheetMergeExample()
	{
	CellsApi cellsApi = new CellsApi(Environment.GetEnvironmentVariable("CellsCloudTestClientId"), Environment.GetEnvironmentVariable("CellsCloudTestClientSecret"));
	PostWorksheetMergeRequest request = new PostWorksheetMergeRequest { name = "Book1.xlsx", sheetName = "Sheet1", startColumn=0, startRow=0, totalColumns=10, totalRows=10, folder = "TestData/In" };
	cellsApi.PostWorksheetMerge(request);
	}
	}
	}
	// Obsolet
	//CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
	//string name = BOOK1;
	//string sheetName = SHEET1;
	//int? startRow = 1;
	//int? startColumn = 1;
	//int? totalRows = 4;
	//int? totalColumns = 4;
	//string folder = TEMPFOLDER;
	//instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
	//var response = instance.CellsPostWorksheetMerge(name, sheetName, startRow, startColumn, totalRows, totalColumns, folder);
	//Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
	//Assert.AreEqual(response.Status, "OK");

view raw Examples-DotNET-CSharp-Cells-MergeCellsWorksheet-1.cs 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\PostWorksheetMergeRequest;

	class Cell {

	public $instance;

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

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

	$localName = "Book1.xlsx";
	$remoteName = "Book1.xlsx";
	$request = new PostWorksheetMergeRequest();
	$request->setName( $remoteName);
	$request->setSheetName( "Sheet1");
	$request->setStartRow( 1);
	$request->setStartColumn( 1);
	$request->setTotalRows( 4);
	$request->setTotalColumns( 4);
	$request->setFolder( $remoteFolder);
	$request->setStorageName( "");
	$this->instance->postWorksheetMerge($request);
	}
	}

	$instance = new Cell();
	$instance->postWorksheetMerge();

	?>

view raw Examples-PHP-Cells-PostWorksheetMerge-.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 Worksheet

	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 cells.
	def merge_cells
	name = $BOOK1
	sheet_name = $SHEET1
	start_row = 1
	start_column = 1
	total_rows = 2
	total_columns = 2
	folder = $TEMPFOLDER
	storage = nil
	result = @instance.upload_file( folder+"/"+name, ::File.open(File.expand_path("data/"+name),"r") {\|io\| io.read(io.size) })
	expect(result.uploaded.size).to be > 0
	result = @instance.cells_post_worksheet_merge(name, sheet_name, start_row, start_column, total_rows, total_columns, { :folder=>folder})
	expect(result.code).to eql(200)
	end

	end

	worksheet = Worksheet.new()
	puts worksheet.merge_cells

view raw Examples-Ruby-Worksheet-merge_cells-.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 *

	api = CellsApi(os.getenv('CellsCloudClientId'),os.getenv('CellsCloudClientSecret'),"v3.0",os.getenv('CellsCloudApiBaseUrl'))
	request = PostWorksheetMergeRequest( 'Book1.xlsx', 'Sheet1', 1, 1, 4, 4,folder= 'PythonTest',storage_name= '')
	api.post_worksheet_merge(request)

view raw MergeCellsInExcelWorksheet.py hosted with ❤ by GitHub

Node.js

	const { CellsApi, UploadFileRequest, Cells_PostWorksheetMergeRequest } = 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 Cells_PostWorksheetMergeRequest();
	req.name = filename;
	req.sheetName = "Sheet1";
	req.startRow = 1;
	req.startColumn = 1;
	req.totalRows = 4;
	req.totalColumns = 4;
	req.folder = "Temp";
	cellsApi.cellsPostWorksheetMerge(req)
	.then((result) => {
	console.log("successful")

	})
	})

view raw Examples-Node.js-SDK-Cells-MergeCellsWorksheet-1.js hosted with ❤ by GitHub

Android

Objective C

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 $remoteName = 'Book1.xlsx';
	my $request = AsposeCellsCloud::Request::PostWorksheetMergeRequest->new();
	$request->{name} = $remoteName;
	$request->{sheet_name} = 'Sheet1';
	$request->{start_row} = 1;
	$request->{start_column} = 1;
	$request->{total_rows} = 4;
	$request->{total_columns} = 4;
	$request->{folder} = $remoteFolder;
	$request->{storage_name} = '';
	my $result = $api->post_worksheet_merge(request=> $request);

view raw Examples-Perl-Cells-MergeCellsWorksheet-1.pl hosted with ❤ by GitHub

Очистить Cells Форматирование в рабочем листе Excel Разъединить Cells в рабочей таблице Excel