Import 2 Dimension Integer Array into Excel Worksheet

This REST API import 2 dimension integer array data into Excel work sheet.

The request is an HTTP request with multipart content (see RFC 2046 or RFC 1341). The first part of the multipart content contains the Import2DimensionIntegerArrayOption data and the second contains a data file.

The important parameters are described in the following table:

RSET API


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

Import2DimensionIntegerArrayOption

Parameter Name	Type	Description
FirstRow	int
FirstColumn	int
Data	Integer[,]
DestinationWorksheet	string	destination work sheet name.
IsInsert	string	true/false.
ImportDataType	string	IntArray/DoubleArray/StringArray/TwoDimensionIntArray/TwoDimensionDoubleArray/TwoDimensionStringArray/BatchData/CSVData.
Source	FileSource	Indicates data file position when the BatchData parameter is null.

Example

{
    "Data": [
        [1, 2],
        [3, 4]
    ],
    "DestinationWorksheet": "Sheet2",
    "FirstRow": 4,
    "FirstColumn": 1,
    "importDataType": "TwoDimensionIntArray"
}

Cloud SDK Family

Using an SDK is the best way to speed up the development. An SDK takes care of low-level details and lets you focus on your project tasks. Please check out the GitHub repository for a complete list of Aspose.Cells Cloud SDKs.

The following code examples demonstrate how to make calls to Aspose.Cells web services using various SDKs:

	// 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;
	using System.Collections.Generic;

	public partial class CellsApiExample
	{
	public void PostImportData1Example()
	{
	CellsApi cellsApi = new CellsApi(Environment.GetEnvironmentVariable("CellsCloudTestClientId"), Environment.GetEnvironmentVariable("CellsCloudTestClientSecret"));
	PostImportDataRequest request = new PostImportDataRequest
	{
	name = "Book1.xlsx",
	importOption = new Model.ImportIntArrayOption {
	DestinationWorksheet = "Sheet1",
	FirstColumn = 1,
	FirstRow = 3,
	ImportDataType = "IntArray",
	IsVertical = true,
	Data = new List<int?> { 1, 2, 3, 4 }
	},
	folder = "TestData/In"
	};
	cellsApi.PostImportData(request);
	}
	}
	}

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\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('TwoDimensionIntArray');
	$data->setData(array(array(1, 2, 3, 4),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-2.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

Import Picture into Excel Worksheet Import Integer Array into Excel Worksheet