Imposta lo zoom per un foglio di lavoro Excel Questo REST API indica set the zoom value of Excel worksheet.
RSETAPI
Copy
POST http://api.aspose.cloud/v3.0/cells/{ name} /worksheets/{ sheetName} /zoom
I parametri della richiesta sono:
Nome del parametro
Tipo
Percorso/Stringa di query/Corpo HTTP
Descrizione
nome
corda
sentiero
nomefoglio
corda
sentiero
valore
numero intero
domanda
cartella
corda
domanda
storageName
corda
domanda
nome dell’archivio.
ILSpecifiche OpenAPI definisce un’interfaccia di programmazione accessibile pubblicamente e consente di eseguire interazioni REST direttamente da un browser web.
È possibile utilizzare lo strumento da riga di comando cURL per accedere facilmente ai servizi Web Aspose.Cells. Nell’esempio seguente viene illustrato come effettuare chiamate al Cloud API con cURL.
Famiglia di SDK Cloud
Utilizzare un SDK è il modo migliore per accelerare lo sviluppo. Un SDK si prende cura dei dettagli di basso livello e ti consente di concentrarti sulle attività del tuo progetto. Si prega di controllare ilRepositorio GitHub per un elenco completo degli SDK Cloud Aspose.Cells.
I seguenti esempi di codice dimostrano come effettuare chiamate ai servizi Web Aspose.Cells utilizzando vari SDK:
C#
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// 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 PostSetCellRangeValueExample()
{
CellsApi cellsApi = new CellsApi(Environment.GetEnvironmentVariable("CellsCloudTestClientId"), Environment.GetEnvironmentVariable("CellsCloudTestClientSecret"));
PostSetCellRangeValueRequest request = new PostSetCellRangeValueRequest { name = "Book1.xlsx", sheetName = "Sheet1", cellarea="A1:C1", type="string" , value="Aspose.Cells Cloud", folder = "TestData/In" };
cellsApi.PostSetCellRangeValue(request);
}
}
}
// Obsolet
//CellsApi instance = new CellsApi(clientId, clientSecret, apiVersion, testbaseurl);
//string name = BOOK1;
//string sheetName = SHEET1;
//string cellarea = CELLAREA;
//string value = Value;
//string type = Type;
//string folder = TEMPFOLDER;
//instance.UploadFile(folder + @"\" + name, File.Open( @"C:\TestData\" +name));
//var response = instance.CellsPostSetCellRangeValue(name, sheetName, cellarea, value, type, folder);
//Assert.IsInstanceOf<CellsCloudResponse>(response, "response is CellsCloudResponse");
//Assert.AreEqual(response.Status, "OK");
Java
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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);
GetWorksheetCellsRangeValueRequest request = new GetWorksheetCellsRangeValueRequest();
request.setName(remoteName);
request.setSheetName("Sheet1");
request.setNamerange("");
request.setFirstRow(0);
request.setFirstColumn(0);
request.setRowCount(3);
request.setColumnCount(2);
request.setFolder(remoteFolder);
request.setStorageName("");
RangeValueResponse response = api.getWorksheetCellsRangeValue(request);
} catch (ApiException e) {
e.printStackTrace();
}catch (IOException e) {
e.printStackTrace();
}
}
}
PHP
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?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\PostSetCellRangeValueRequest;
class Cell {
public $instance;
public function __construct() {
$this->instance = new CellsApi(getenv("CellsCloudClientId"),getenv("CellsCloudClientSecret"),"v3.0",getenv("CellsCloudApiBaseUrl"));
}
public function postSetCellRangeValue() {
$remoteFolder = "TestData/In";
$localName = "Book1.xlsx";
$remoteName = "Book1.xlsx";
$request = new PostSetCellRangeValueRequest();
$request->setName( $remoteName);
$request->setSheetName( "Sheet1");
$request->setCellarea( "A1:C10");
$request->setValue( "Test");
$request->setType( "string");
$request->setFolder( $remoteFolder);
$request->setStorageName( "");
$this->instance->postSetCellRangeValue($request);
}
}
$instance = new Cell();
$instance->postSetCellRangeValue();
?>
Ruby
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-ruby
require 'aspose_cells_cloud'
class Cell
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
# Set cell range value
def set_cell_range_value
name = $BOOK1
sheet_name = $SHEET1
cellarea = $CELLAREA
value = 1
type = 'string'
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_set_cell_range_value(name, sheet_name, cellarea, value, type, { :folder=>folder})
expect(result.code).to eql(200)
end
end
cell = Cell.new()
puts cell.set_cell_range_value
Node.js
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
const { CellsApi, UploadFileRequest, Cells_PostSetCellRangeValueRequest } = 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_PostSetCellRangeValueRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.cellarea = "A1:C10";
req.folder = "Temp";
req.value = "1";
req.type = "int";
cellsApi.cellsPostSetCellRangeValue(req)
.then((result) => {
req.value = "12345";
req.type = "String";
cellsApi.cellsPostSetCellRangeValue(req)
.then((result) => {
req.value = "2017-10-1";
req.type = "DateTime";
cellsApi.cellsPostSetCellRangeValue(req)
.then((result) => {
console.log("cellsPostSetCellRangeValue test done.")
})
})
})
})
Python
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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 = PostSetCellRangeValueRequest( 'Book1.xlsx', 'Sheet1', 'A1:C10', 'Test', 'string',folder= 'PythonTest',storage_name= '')
api.post_set_cell_range_value(request)
Swift
Perl
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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::PostWorksheetCellSetValueRequest->new();
$request->{name} = $remoteName;
$request->{sheet_name} = 'Sheet1';
$request->{cell_name} = 'A1';
$request->{value} = '1';
$request->{type} = 'int';
$request->{folder} = $remoteFolder;
$request->{storage_name} = '';
my $result = $api->post_worksheet_cell_set_value(request=> $request);
Go
