使用粘贴选项复制工作表中的范围

此 REST API 表示在 Excel 工作表上复制工作表中的范围。

重新设置 API

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

请求参数为：

参数名称	类型	路径/查询字符串/HTTPBody	描述
姓名	细绳	小路	工作簿名称
工作表名称	细绳	小路	工作表名称
范围操作		身体	复制数据、复制样式、复制到、复制值
文件夹	细绳	询问	工作簿文件夹。
存储名称	细绳	询问	存储名称。

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

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

Request

 
curl -v "https://api.aspose.cloud/v3.0/cells/Book1.xlsx/worksheets/Sheet1/ranges" \
-X POST \
-H "Content-Type: application/json" \
-H "Accept: application/json" \
-H "Authorization: Bearer <jwt token>"
-d "{ \"Operate\": \"string\", \"Source\": { \"ColumnCount\": 0, \"ColumnWidth\": 0, \"FirstColumn\": 0, \"FirstRow\": 0, \"Name\": \"string\", \"RefersTo\": \"string\", \"RowCount\": 0, \"RowHeight\": 0, \"Worksheet\": \"string\" }, \"Target\": { \"ColumnCount\": 0, \"ColumnWidth\": 0, \"FirstColumn\": 0, \"FirstRow\": 0, \"Name\": \"string\", \"RefersTo\": \"string\", \"RowCount\": 0, \"RowHeight\": 0, \"Worksheet\": \"string\" }, \"PasteOptions\": { \"OnlyVisibleCells\": true, \"PasteType\": \"string\", \"SkipBlanks\": true, \"Transpose\": true }}"

Response

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

Cloud SDK 系列

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

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

	namespace Aspose.Cells.Cloud.SDK.Tests.Api.Example
	{
	using Microsoft.VisualStudio.TestTools.UnitTesting;
	using Aspose.Cells.Cloud.SDK.Request;
	using System.Collections.Generic;
	using Aspose.Cells.Cloud.SDK.Api;
	using System;
	using System.IO;

	[TestClass]
	public class CellsApiExample
	{
	string CellsCloudClientId ="....";//get from https://dashboard.aspose.cloud/#/applications
	string CellsCloudClientSecret="...";//get from https://dashboard.aspose.cloud/#/applications
	private readonly string remoteFolder = "TestData/In";
	string localName = "Book1.xlsx";
	string remoteName = "remote_book1.xlsx";
	string localPath = "D:/TestData/CellsCloud";
	[TestCategory("Cells")]
	[TestMethod]
	public void Example()
	{


	UploadFileRequest uploadFileRequest = new UploadFileRequest();
	FileInfo fileInfo = new FileInfo(localPath + "/" + localName);
	uploadFileRequest.path = remoteFolder + "/" + remoteName;
	uploadFileRequest.storageName = "";
	uploadFileRequest.UploadFiles = new Dictionary<string, Stream>() { { localName, File.OpenRead(localPath +"/"+ localName) } };
	cellsApi.UploadFile(uploadFileRequest);



	var rangeOperateSource = new Range()
	{
	ColumnCount = 1,
	ColumnWidth = 10.0f,
	FirstRow = 1,
	RowCount = 10
	};
	var rangeOperateTarget = new Range()
	{
	ColumnCount = 1,
	ColumnWidth = 10.0f,
	FirstRow = 10,
	RowCount = 10
	};
	var rangeOperate = new RangeCopyRequest()
	{
	Operate = "copydata",
	Source = rangeOperateSource,
	Target = rangeOperateTarget
	};
	var request = new PostWorksheetCellsRangesCopyRequest(
	name: remoteName,
	sheetName: "Sheet1",
	rangeOperate: rangeOperate,
	folder: remoteFolder,
	storageName: ""
	);
	cellsApi.PostWorksheetCellsRangesCopy(request);











	}


	}
	}

view raw ExamplePostWorksheetCellsRangesCopy.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);

	PostWorksheetCellsRangesCopyRequest request = new PostWorksheetCellsRangesCopyRequest();
	request.setName(remoteName);

	request.setSheetName("Sheet1");

	RangeCopyRequest rangeOperate = new RangeCopyRequest();
	rangeOperate.setOperate("copydata");


	Range source = new Range();
	source.setColumnCount(1);


	source.setColumnWidth(10.0);


	source.setFirstRow(1);


	source.setRowCount(10);

	rangeOperate.setSource(source);


	Range target = new Range();
	target.setColumnCount(1);


	target.setColumnWidth(10.0);


	target.setFirstRow(10);


	target.setRowCount(10);

	rangeOperate.setTarget(target);

	request.setRangeOperate(rangeOperate);

	request.setFolder(remoteFolder);

	request.setStorageName("");

	this.api.postWorksheetCellsRangesCopy(request);

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

view raw Example_PostWorksheetCellsRangesCopy.java hosted with ❤ by GitHub

PHP

	<?php
	require_once('vendor\autoload.php');
	use \Aspose\Cells\Cloud\Api\CellsApi;
	use \Aspose\Cells\Cloud\Request\PostWorksheetCellsRangesCopyRequest;

	$CellsCloudClientId = "...." ; # get from https://dashboard.aspose.cloud/#/applications
	$CellsCloudClientSecret = "...."; # get from https://dashboard.aspose.cloud/#/applications
	$cellsApi = new CellsApi($CellsCloudClientId , $CellsCloudClientSecret );

	$remoteFolder = "TestData/In";

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

	$rangeOperateSource = new \Aspose\Cells\Cloud\Model\Range();
	$rangeOperateSource->setColumnCount(1 );
	$rangeOperateSource->setColumnWidth(10.0 );
	$rangeOperateSource->setFirstRow(1 );
	$rangeOperateSource->setRowCount(10 );
	$rangeOperateTarget = new \Aspose\Cells\Cloud\Model\Range();
	$rangeOperateTarget->setColumnCount(1 );
	$rangeOperateTarget->setColumnWidth(10.0 );
	$rangeOperateTarget->setFirstRow(10 );
	$rangeOperateTarget->setRowCount(10 );
	$rangeOperate = new \Aspose\Cells\Cloud\Model\RangeCopyRequest();
	$rangeOperate->setOperate("copydata" );
	$rangeOperate->setSource($rangeOperateSource );
	$rangeOperate->setTarget($rangeOperateTarget );


	$request = new PostWorksheetCellsRangesCopyRequest();
	$request->setName( $remoteName);
	$request->setSheetName( "Sheet1");
	$request->setRangeOperate( $rangeOperate);
	$request->setFolder( $remoteFolder);
	$request->setStorageName( "");
	$cellsApi->postWorksheetCellsRangesCopy($request);

view raw Example_PostWorksheetCellsRangesCopy.php hosted with ❤ by GitHub

Ruby

	require 'openssl'
	require 'bundler'
	require 'aspose_cells_cloud'


	CellsCloudClientId = "...." # get from https://dashboard.aspose.cloud/#/applications
	CellsCloudClientSecret = "...." # get from https://dashboard.aspose.cloud/#/applications
	@instance = AsposeCellsCloud::CellsApi.new(CellsCloudClientId, CellsCloudClientSecret)

	remote_folder = 'TestData/In'

	local_name = 'Book1.xlsx'
	remote_name = 'Book1.xlsx'


	mapFiles = { }
	mapFiles[local_name] = ::File.open(File.expand_path("TestData/"+local_name),"r")

	uploadrequest = AsposeCellsCloud::UploadFileRequest.new( { :UploadFiles=>mapFiles,:path=>remote_folder })
	@instance.upload_file(uploadrequest)
	rangeOperateSource = AsposeCellsCloud::Range.new(:ColumnCount=>1 ,:ColumnWidth=>10.0 ,:FirstRow=>1 ,:RowCount=>10 );
	rangeOperateTarget = AsposeCellsCloud::Range.new(:ColumnCount=>1 ,:ColumnWidth=>10.0 ,:FirstRow=>10 ,:RowCount=>10 );
	rangeOperate = AsposeCellsCloud::RangeCopyRequest.new(:Operate=>'copydata' ,:Source=>rangeOperateSource ,:Target=>rangeOperateTarget );
	request = AsposeCellsCloud::PostWorksheetCellsRangesCopyRequest.new(:name=>remote_name,:sheetName=>'Sheet1',:rangeOperate=>rangeOperate,:folder=>remote_folder,:storageName=>'');
	@instance.post_worksheet_cells_ranges_copy(request);

view raw Example_PostWorksheetCellsRangesCopy.rb hosted with ❤ by GitHub

Node.js

	import { CellsApi,Range,RangeCopyRequest,PostWorksheetCellsRangesCopyRequest,UploadFileRequest } from "asposecellscloud";
	var fs = require('fs');
	var path = require('path');
	var process = require('process');
	const _ = require('asposecellscloud');

	const CellsCloudClientId ="....";//get from https://dashboard.aspose.cloud/#/applications
	const CellsCloudClientSecret="...";//get from https://dashboard.aspose.cloud/#/applications
	const cellsApi = new CellsApi(CellsCloudClientId, CellsCloudClientSecret);

	var remoteFolder = "TestData/In"
	var localPath = "TestData/CellsCloud/"
	var localName = "Book1.xlsx"
	var remoteName = "Book1.xlsx"

	describe('example', function(){
	it("should call successfully" , function(){

	var localNameRequest = new UploadFileRequest();
	localNameRequest.uploadFiles ={localName:fs.createReadStream(localPath + localName)};
	localNameRequest.path = remoteFolder + "/" + remoteName ;
	localNameRequest.storageName ="";
	cellsApi.uploadFile(localNameRequest );

	var rangeOperateSource = new Range();
	rangeOperateSource.columnCount = 1 ;
	rangeOperateSource.columnWidth = 10.0 ;
	rangeOperateSource.firstRow = 1 ;
	rangeOperateSource.rowCount = 10 ;
	var rangeOperateTarget = new Range();
	rangeOperateTarget.columnCount = 1 ;
	rangeOperateTarget.columnWidth = 10.0 ;
	rangeOperateTarget.firstRow = 10 ;
	rangeOperateTarget.rowCount = 10 ;
	var rangeOperate = new RangeCopyRequest();
	rangeOperate.operate = "copydata" ;
	rangeOperate.source = rangeOperateSource ;
	rangeOperate.target = rangeOperateTarget ;

	var request = new PostWorksheetCellsRangesCopyRequest();
	request.name = remoteName;
	request.sheetName = "Sheet1";
	request.rangeOperate = rangeOperate;
	request.folder = remoteFolder;
	request.storageName = "";
	return cellsApi.postWorksheetCellsRangesCopy(request)

	});
	});

view raw Example_PostWorksheetCellsRangesCopy.ts hosted with ❤ by GitHub

Python

	import os
	import sys

	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)
	rangeOperateSource = Range(column_count= 1 ,column_width= 10.0 ,first_row= 1 ,row_count= 10 )
	rangeOperateTarget = Range(column_count= 1 ,column_width= 10.0 ,first_row= 10 ,row_count= 10 )
	rangeOperate = RangeCopyRequest(operate= 'copydata' ,source= rangeOperateSource ,target= rangeOperateTarget )
	request = PostWorksheetCellsRangesCopyRequest( 'Book1.xlsx', 'Sheet1', rangeOperate,folder= 'PythonTest',storage_name= '')
	api.post_worksheet_cells_ranges_copy(request)

view raw Example_PostWorksheetCellsRangesCopy.py hosted with ❤ by GitHub

Perl

	use lib 'lib';
	use strict;
	use warnings;
	use File::Slurp;
	use MIME::Base64;
	use AsposeCellsCloud::CellsApi;

	my $CellsCloudClientId = "...."; # get from https://dashboard.aspose.cloud/#/applications
	my $CellsCloudClientSecret = "...."; # get from https://dashboard.aspose.cloud/#/applications
	my $config = AsposeCellsCloud::Configuration->new( client_id => $CellsCloudClientId , client_secret => $CellsCloudClientSecret );

	my $instance = AsposeCellsCloud::CellsApi->new(AsposeCellsCloud::ApiClient->new( $config));

	my $remoteFolder = 'TestData/In';

	my $localName = 'Book1.xlsx';
	my $remoteName = 'Book1.xlsx';

	my $upload_file_request = AsposeCellsCloud::Request::UploadFileRequest->new( 'UploadFiles'=>{ $localName => $localName } ,'path'=>$remoteFolder . '/' . $remoteName );

	my $range_operate_source = AsposeCellsCloud::Object::Range->new();
	$range_operate_source->{column_count} = 1 ;
	$range_operate_source->{column_width} = 10.0 ;
	$range_operate_source->{first_row} = 1 ;
	$range_operate_source->{row_count} = 10 ;
	my $range_operate_target = AsposeCellsCloud::Object::Range->new();
	$range_operate_target->{column_count} = 1 ;
	$range_operate_target->{column_width} = 10.0 ;
	$range_operate_target->{first_row} = 10 ;
	$range_operate_target->{row_count} = 10 ;
	my $range_operate = AsposeCellsCloud::Object::RangeCopyRequest->new();
	$range_operate->{operate} = 'copydata' ;
	$range_operate->{source} = $range_operate_source ;
	$range_operate->{target} = $range_operate_target ;

	my $request = AsposeCellsCloud::Request::PostWorksheetCellsRangesCopyRequest->new();
	$request->{name} = $remoteName;
	$request->{sheet_name} = 'Sheet1';
	$request->{range_operate} = $range_operate;
	$request->{folder} = $remoteFolder;
	$request->{storage_name} = '';
	$instance->post_worksheet_cells_ranges_copy(request=> $request);

view raw Example_PostWorksheetCellsRangesCopy.pl hosted with ❤ by GitHub

	package main

	import (
	. "github.com/aspose-cells-cloud/aspose-cells-cloud-go/v25"
	)

	func main() {
	CellsCloudClientId := "...." // get from https://dashboard.aspose.cloud/#/applications
	CellsCloudClientSecret := "...." // get from https://dashboard.aspose.cloud/#/applications
	instance := NewCellsApiService(CellsCloudClientId, CellsCloudClientSecret)
	remoteFolder := "TestData/In"

	localName := "Book1.xlsx"
	remoteName := "Book1.xlsx"

	localNameRequest := new(UploadFileRequest)
	localNameRequest.UploadFiles = make(map[string]string)
	localNameRequest.UploadFiles[localName] = localName
	localNameRequest.Path = remoteFolder + "/" + remoteName
	localNameRequest.StorageName = ""
	instance.UploadFile(localNameRequest)

	var rangeOperateSource = new(Range)
	rangeOperateSource.ColumnCount = int64(1)
	rangeOperateSource.ColumnWidth = 10.0
	rangeOperateSource.FirstRow = int64(1)
	rangeOperateSource.RowCount = int64(10)
	var rangeOperateTarget = new(Range)
	rangeOperateTarget.ColumnCount = int64(1)
	rangeOperateTarget.ColumnWidth = 10.0
	rangeOperateTarget.FirstRow = int64(10)
	rangeOperateTarget.RowCount = int64(10)
	var rangeOperate = new(RangeCopyRequest)
	rangeOperate.Operate = "copydata"
	rangeOperate.Source = rangeOperateSource
	rangeOperate.Target = rangeOperateTarget

	request := new(PostWorksheetCellsRangesCopyRequest)
	request.Name = remoteName
	request.SheetName = "Sheet1"
	request.RangeOperate = rangeOperate
	request.Folder = remoteFolder
	request.StorageName = ""
	_, httpResponse, err := instance.PostWorksheetCellsRangesCopy(request)
	if err != nil {
	println(err.Error())
	} else if httpResponse.StatusCode < 200 \|\| httpResponse.StatusCode > 299 {
	println("Fail")
	}
	}

view raw Example_PostWorksheetCellsRangesCopy.go hosted with ❤ by GitHub