Blocco batch Excel File

Questo REST API indica batch lock file idonei.

RSET API

 
POST http://api.aspose.cloud/v3.0/cells/batch/lock

I parametri della richiesta sono:

Nome del parametro	Tipo	Percorso/Stringa di query/Corpo HTTP	Descrizione
Richiesta di blocco batch		corpo

Proprietà BatchLockRequest

Nome	Tipo	Descrizione	Note
SourceFolder	stringa		[facoltativo]MatchCondition

Nome	Tipo	Descrizione	Note
RegexPattern	stringa		[facoltativo]FullMatchConditions

È possibile utilizzare lo strumento da riga di comando cURL per accedere facilmente ai servizi web Aspose.Cells. L’esempio seguente mostra come effettuare chiamate al Cloud API con cURL.

Request

 
curl -v "http://api.aspose.cloud/v3.0/cells/batch/lock" \
-X POST \
-H "Content-Type: application/json" \
-H "Accept: application/json" \
-H "Authorization: Bearer <jwt token>"
-D "{\"SourceFolder\":\"CellsTests\",\"OutFolder\":\"Output\",\"MatchCondition\":{\"RegexPattern\":\"(^Book)(.+)(xlsx$)\"},\"Password\":\"123456\"}"

Response

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

Famiglia Cloud SDK

Utilizzare un SDK è il modo migliore per accelerare lo sviluppo. Un SDK si occupa dei dettagli di basso livello e ti consente di concentrarti sulle attività di blocco. Dai un’occhiata aRepository GitHub per un elenco completo di Aspose.Cells Cloud SDK.

I seguenti esempi di codice mostrano come effettuare chiamate ai servizi Web Aspose.Cells utilizzando vari SDK:

	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 batchLockRequestMatchCondition = new MatchConditionRequest()
	{
	RegexPattern = "(^Book)(.+)(xlsx$)"
	};
	var batchLockRequest = new BatchLockRequest()
	{
	SourceFolder = remoteFolder,
	Password = "123456",
	OutFolder = "OutResult",
	MatchCondition = batchLockRequestMatchCondition
	};
	var request = new PostBatchLockRequest(
	batchLockRequest: batchLockRequest
	);
	cellsApi.PostBatchLock(request);






	}


	}
	}

view raw ExamplePostBatchLock.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 localBook1 = "Book1.xlsx";
	String remoteBook1 = "Book1.xlsx";
	String localMyDoc = "myDocument.xlsx";
	String remoteMyDoc = "myDocument.xlsx";

	UploadFileRequest uploadFileRequest = new UploadFileRequest();
	uploadFileRequest.setPath( remoteFolder + "/" + remoteBook1 );
	uploadFileRequest.setStorageName( "");
	HashMap<String,File> files = new HashMap<String,File>();
	files.put( localBook1 , new File(localBook1 ));
	uploadFileRequest.setUploadFiles(files);
	api.uploadFile(uploadFileRequest);
	UploadFileRequest uploadFileRequest = new UploadFileRequest();
	uploadFileRequest.setPath( remoteFolder + "/" + remoteMyDoc );
	uploadFileRequest.setStorageName( "");
	HashMap<String,File> files = new HashMap<String,File>();
	files.put( localMyDoc , new File(localMyDoc ));
	uploadFileRequest.setUploadFiles(files);
	api.uploadFile(uploadFileRequest);

	PostBatchLockRequest request = new PostBatchLockRequest();
	BatchLockRequest batchLockRequest = new BatchLockRequest();
	batchLockRequest.setSourceFolder(remoteFolder);


	batchLockRequest.setPassword("123456");


	batchLockRequest.setOutFolder("OutResult");


	MatchConditionRequest matchCondition = new MatchConditionRequest();
	matchCondition.setRegexPattern("(^Book)(.+)(xlsx$)");

	batchLockRequest.setMatchCondition(matchCondition);

	request.setBatchLockRequest(batchLockRequest);

	this.api.postBatchLock(request);

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

view raw Example_PostBatchLock.java hosted with ❤ by GitHub

PHP

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

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

	$remoteFolder = "TestData/In";

	$localBook1 = "Book1.xlsx";
	$remoteBook1 = "Book1.xlsx";
	$localMyDoc = "myDocument.xlsx";
	$remoteMyDoc = "myDocument.xlsx";

	$batchLockRequestMatchCondition = new \Aspose\Cells\Cloud\Model\MatchConditionRequest();
	$batchLockRequestMatchCondition->setRegexPattern("(^Book)(.+)(xlsx$)" );
	$batchLockRequest = new \Aspose\Cells\Cloud\Model\BatchLockRequest();
	$batchLockRequest->setSourceFolder($remoteFolder );
	$batchLockRequest->setPassword("123456" );
	$batchLockRequest->setOutFolder("OutResult" );
	$batchLockRequest->setMatchCondition($batchLockRequestMatchCondition );


	$request = new PostBatchLockRequest();
	$request->setBatchLockRequest( $batchLockRequest);
	$cellsApi->postBatchLock($request);

view raw Example_PostBatchLock.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_book1 = 'Book1.xlsx'
	remote_book1 = 'Book1.xlsx'
	local_my_doc = 'myDocument.xlsx'
	remote_my_doc = 'myDocument.xlsx'


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

	uploadrequest = AsposeCellsCloud::UploadFileRequest.new( { :UploadFiles=>mapFiles,:path=>remote_folder })
	@instance.upload_file(uploadrequest)
	batchLockRequestMatchCondition = AsposeCellsCloud::MatchConditionRequest.new(:RegexPattern=>'(^Book)(.+)(xlsx$)' );
	batchLockRequest = AsposeCellsCloud::BatchLockRequest.new(:SourceFolder=>remote_folder ,:Password=>'123456' ,:OutFolder=>'OutResult' ,:MatchCondition=>batchLockRequestMatchCondition );
	request = AsposeCellsCloud::PostBatchLockRequest.new(:batchLockRequest=>batchLockRequest);
	@instance.post_batch_lock(request);

view raw Example_PostBatchLock.rb hosted with ❤ by GitHub

Node.js

	import { CellsApi,MatchConditionRequest,BatchLockRequest,PostBatchLockRequest,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"
	var localMyDoc = "myDocument.xlsx"
	var remoteMyDoc = "myDocument.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 localMyDocRequest = new UploadFileRequest();
	localMyDocRequest.uploadFiles ={localMyDoc:fs.createReadStream(localPath + localMyDoc)};
	localMyDocRequest.path = remoteFolder + "/" + remoteMyDoc ;
	localMyDocRequest.storageName ="";
	cellsApi.uploadFile(localMyDocRequest );


	var batchLockRequestMatchCondition = new MatchConditionRequest();
	batchLockRequestMatchCondition.regexPattern = "(^Book)(.+)(xlsx$)" ;
	var batchLockRequest = new BatchLockRequest();
	batchLockRequest.sourceFolder = remoteFolder ;
	batchLockRequest.password = "123456" ;
	batchLockRequest.outFolder = "OutResult" ;
	batchLockRequest.matchCondition = batchLockRequestMatchCondition ;

	var request = new PostBatchLockRequest();
	request.batchLockRequest = batchLockRequest;
	return cellsApi.postBatchLock(request)
	});
	});

view raw Example_PostBatchLock.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)
	batchLockRequestMatchCondition = MatchConditionRequest(regex_pattern= '(^Book)(.+)(xlsx$)' )
	batchLockRequest = BatchLockRequest(source_folder= 'PythonTest' ,password= '123456' ,out_folder= 'OutResult' ,match_condition= batchLockRequestMatchCondition )
	request = PostBatchLockRequest( batchLockRequest)
	api.post_batch_lock(request)

view raw Example_PostBatchLock.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 $localBook1 = 'Book1.xlsx';
	my $remoteBook1 = 'Book1.xlsx';
	my $localMyDoc = 'myDocument.xlsx';
	my $remoteMyDoc = 'myDocument.xlsx';

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

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

	my $batch_lock_request_match_condition = AsposeCellsCloud::Object::MatchConditionRequest->new();
	$batch_lock_request_match_condition->{regex_pattern} = '(^Book)(.+)(xlsx$)' ;
	my $batch_lock_request = AsposeCellsCloud::Object::BatchLockRequest->new();
	$batch_lock_request->{source_folder} = $remoteFolder ;
	$batch_lock_request->{password} = '123456' ;
	$batch_lock_request->{out_folder} = 'OutResult' ;
	$batch_lock_request->{match_condition} = $batch_lock_request_match_condition ;

	my $request = AsposeCellsCloud::Request::PostBatchLockRequest->new();
	$request->{batch_lock_request} = $batch_lock_request;
	$instance->post_batch_lock(request=> $request);

view raw Example_PostBatchLock.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"

	localBook1 := "Book1.xlsx"
	remoteBook1 := "Book1.xlsx"
	localMyDoc := "myDocument.xlsx"
	remoteMyDoc := "myDocument.xlsx"

	localBook1Request := new(UploadFileRequest)
	localBook1Request.UploadFiles = make(map[string]string)
	localBook1Request.UploadFiles[localBook1] = localBook1
	localBook1Request.Path = remoteFolder + "/" + remoteBook1
	localBook1Request.StorageName = ""
	instance.UploadFile(localBook1Request)
	localMyDocRequest := new(UploadFileRequest)
	localMyDocRequest.UploadFiles = make(map[string]string)
	localMyDocRequest.UploadFiles[localMyDoc] = localMyDoc
	localMyDocRequest.Path = remoteFolder + "/" + remoteMyDoc
	localMyDocRequest.StorageName = ""
	instance.UploadFile(localMyDocRequest)

	var batchLockRequestMatchCondition = new(MatchConditionRequest)
	batchLockRequestMatchCondition.RegexPattern = "(^Book)(.+)(xlsx$)"
	var batchLockRequest = new(BatchLockRequest)
	batchLockRequest.SourceFolder = remoteFolder
	batchLockRequest.Password = "123456"
	batchLockRequest.OutFolder = "OutResult"
	batchLockRequest.MatchCondition = batchLockRequestMatchCondition

	request := new(PostBatchLockRequest)
	request.BatchLockRequest = batchLockRequest
	_, httpResponse, err := instance.PostBatchLock(request)
	if err != nil {
	println(err.Error())
	} else if httpResponse.StatusCode < 200 \|\| httpResponse.StatusCode > 299 {
	println("Fail")
	}
	}

view raw Example_PostBatchLock.go hosted with ❤ by GitHub