Importa dati batch nel foglio di lavoro Excel

Questo foglio di lavoro REST API import batch data in Excel.

La richiesta è una richiesta HTTP con contenuto multiparte (vedereRFC 2046ORFC 1341). La prima parte del contenuto multiparte contiene i dati ImportBatchDataOption 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:

ImportBatchDataOption

Nome del parametro	Tipo	Descrizione
Dati batch	Lista	dati batch
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.

CellValue

Nome del parametro	Tipo	Descrizione
indice di riga	interno
indice di colonna	interno
tipo	corda	tipo di dati
valore	corda
stile	Stile(oggetto)

FileSource

Nome del parametro	Tipo	Descrizione
Tipo di origine file	corda	InMemoryFiles/CloudFileSystem/RequestFiles
Percorso file	corda	posizione del file

Esempio

<ImportIntArrayOption>
    <DestinationWorksheet>Sheet1</DestinationWorksheet>
    <IsInsert>false</IsInsert>
    <ImportDataType>IntArray</ImportDataType>
    <FirstRow>1</FirstRow>
    <FirstColumn>1</FirstColumn>
    <IsVertical>true</IsVertical>
    <Source>
        <FileSourceType>CloudFileSystem</FileSourceType>
        <FilePath>Array_int_xml.txt</FilePath>
    </Source>
</ImportIntArrayOption>

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

	require_once('vendor\autoload.php');
	use \Aspose\Cells\Cloud\Api\CellsApi;
	use \Aspose\Cells\Cloud\Model\ImportBatchDataOption;
	use \Aspose\Cells\Cloud\Model\CellValue;
	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 postImportBatchDataCloudFile() {

	$v1 = new CellValue();
	$v1->setRowIndex(1);
	$v1->setColumnIndex(1);
	$v1->setType('string');
	$v1->setValue('1111');

	$v2 = new CellValue();
	$v2->setRowIndex(1);
	$v2->setColumnIndex(2);
	$v2->setType('int');
	$v2->setValue('1111');

	$name ='Book1.xlsx';
	$folder ="TestData/In";
	$data = new ImportBatchDataOption();
	$data->setDestinationWorksheet('Sheet1');
	$data->setImportDataType('BatchData');
	$data->setBatchData(array($v1, $v2)) ;

	$request = new PostImportDataRequest();
	$request->setName( $name);
	$request->setImportOption( $data);
	$request->setFolder( $folder);
	$request->setStorageName( "");
	$this->cells->postImportData($request);
	}
	}

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

	?>

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

Importa dati senza utilizzare l'archiviazione Esporta carattere