Importa array di interi nel foglio di lavoro Excel

Questo foglio di lavoro REST API import int array data in Excel.

La richiesta è una richiesta HTTP con contenuto multiparte (vedereRFC 2046ORFC 1341). La prima parte del contenuto multiparte contiene i dati ImportIntegerArrayOption e la seconda contiene un file di dati.

RSET API


POST https://api.aspose.cloud/v3.0/cells/import
POST https://api.aspose.cloud/v3.0/cells/{name}/importdata

I parametri importanti sono descritti nella tabella seguente:

ImportIntegerArrayOption

Nome del parametro	Tipo	Descrizione
Prima fila	interno
Prima colonna	interno
È verticale	corda	vero/falso.
Dati	Intero[]
Foglio di lavoro di destinazione	corda	nome del foglio di lavoro di destinazione.
ÈInserimento	corda	vero/falso.
ImportDataType	corda	IntArray/DoubleArray/StringArray/TwoDimensionIntArray/TwoDimensionDoubleArray/TwoDimensionStringArray/BatchData/CSVData.
Fonte	FileSource	Indica la posizione del file di dati quando il parametro BatchData è null.

Esempio


{
    "Data": [1, 2, 4],
    "DestinationWorksheet": "Sheet1",
    "FirstRow": 1,
    "FirstColumn": 2,
    "IsVertical": true,
    "IsInsert": true,
    "importDataType": "IntArray"
}

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à del progetto. 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:

View raw

(Sorry about that, but we can’t show files that are this big right now.)

view raw Examples-DotNet-CSharp-ImportData-PostImportDataCloudFile-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\Model\ImportIntArrayOption;
	use \Aspose\Cells\Cloud\Request\PostImportDataRequest;

	class Workbook {

	public $cells;

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

	public function postImportDataCloudFile() {
	$name ='Book1.xlsx';
	$folder = "TestData/In";
	$data = new ImportIntArrayOption();
	$data->setDestinationWorksheet('Sheet1');
	$data->setFirstColumn(1);
	$data->setFirstRow(3);
	$data->setImportDataType('IntArray');
	$data->setIsVertical('true');
	$data->setData(array(1, 2, 3, 4)) ;
	$request = new PostImportDataRequest();
	$request->setName( $name);
	$request->setImportOption( $data);
	$request->setFolder( $folder);
	$request->setStorageName( "");
	$this->cells->postImportData($request);
	}
	}

	$workbook = new Workbook();
	$workbook->postImportDataCloudFile();

	?>

view raw Examples-PHP-Workbook-PostImportDataCloudFile-.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 Workbook

	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

	def upload_file(file_name)

	response = @cells_api.put_create(file_name, File.open("../../../data/" << file_name,"r") { \|io\| io.read } )
	end

	# Import data to workbook.
	def post_import_data
	import_batch_data_option = ImportBatchDataOption.new
	import_batch_data_option.destination_worksheet = "Sheet1"
	import_batch_data_option.is_insert = false
	import_batch_data_option.import_data_type = "BatchData"
	import_source = ImportSource.new
	import_source.file_source_type = "CloudFileSystem"
	import_source.file_path = "Batch_data_json.txt"
	import_batch_data_option.source = import_source

	import_string_array_option = ImportStringArrayOption.new
	import_string_array_option.first_row = 1
	import_string_array_option.first_column = 2
	import_string_array_option.is_vertical = true
	import_string_array_option.destination_worksheet = "Sheet1"
	import_string_array_option.is_insert = true
	import_string_array_option.import_data_type = "StringArray"
	import_source = ImportSource.new
	import_source.file_source_type = "CloudFileSystem"
	import_source.file_path = "Array_string_json.txt"
	import_string_array_option.source = import_source

	import_int_array_option = ImportIntArrayOption.new
	import_int_array_option.first_row = 1
	import_int_array_option.first_column = 2
	import_int_array_option.is_vertical = true
	import_int_array_option.destination_worksheet = "Sheet1"
	import_int_array_option.is_insert = true
	import_int_array_option.import_data_type = "IntArray"
	import_source = ImportSource.new
	import_source.file_source_type = "CloudFileSystem"
	import_source.file_path = "Array_int_json.txt"
	import_int_array_option.source = import_source

	import_double_array_option = ImportDoubleArrayOption.new
	import_double_array_option.first_row = 1
	import_double_array_option.first_column = 2
	import_double_array_option.is_vertical = true
	import_double_array_option.destination_worksheet = "Sheet1"
	import_double_array_option.is_insert = true
	import_double_array_option.import_data_type = "DoubleArray"
	import_source = ImportSource.new
	import_source.file_source_type = "CloudFileSystem"
	import_source.file_path = "Array_double_json.txt"
	import_double_array_option.source = import_source

	import_data_options = [import_batch_data_option, import_string_array_option, import_int_array_option, import_double_array_option]
	data_files = ["Batch_data_json.txt", "Array_string_json.txt", "Array_int_json.txt", "Array_double_json.txt"]

	import_data_options.each_with_index { \|option, index\|
	data_file = data_files.at(index)

	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.upload_file( folder+"/"+data_file, ::File.open(File.expand_path("data/"+data_file),"r") {\|io\| io.read(io.size) })
	expect(result.uploaded.size).to be > 0

	response = @cells_api.cells_workbook_post_import_data(file_name, option,{ :folder=>folder})
	expect(response.code).to eql(200)
	}

	end

	end

	workbook = Workbook.new()
	puts workbook.post_import_data

view raw Examples-Ruby-Workbook-post_import_data-.rb hosted with ❤ by GitHub

Esporta oggetto OLE Importa dati Json in Exce