Working with ImportData Task

REST API

API	Type	Description	Resource Link
/cells/task/runtask	POST	Run Task	PostRunTask

The OpenAPI Specification defines a publicly accessible programming interface and lets you carry out REST interactions directly from a web browser.

You can use cURL command-line tool to access Aspose.Cells web services easily. The following example shows how to make calls to Cloud API with cURL.

Request


curl -X POST "https://api.aspose.cloud/v3.0/cells/task/runtask" -H "accept: application/json" -H "Content-Type: application/json" -H "x-aspose-client: Containerize.Swagger" -d "{<Tasks> <TaskDescription> <TaskType>ImportData</TaskType> <ImportDataTaskParameter> <Workbook> <FileSourceType>CloudFileSystem</FileSourceType> <FilePath>TaskBook.xlsx</FilePath> </Workbook> <ImportBatchDataOption> <DestinationWorksheet>Sheet1</DestinationWorksheet> <IsInsert>true</IsInsert> <Source> <FileSourceType>RequestFiles</FileSourceType> <FilePath>Batch_data_xml.txt</FilePath> </Source> </ImportBatchDataOption> </ImportDataTaskParameter> </TaskDescription> <TaskDescription> <TaskType>ImportData</TaskType> <ImportDataTaskParameter> <Workbook> <FileSourceType>InMemoryFiles</FileSourceType> <FilePath>TaskBook.xlsx</FilePath> </Workbook> <ImportBatchDataOption> <DestinationWorksheet>Sheet2</DestinationWorksheet> <IsInsert>true</IsInsert> <Source> <FileSourceType>RequestFiles</FileSourceType> <FilePath>Batch_data_xml_2.txt</FilePath> </Source> </ImportBatchDataOption> </ImportDataTaskParameter> </TaskDescription> <TaskDescription> <TaskType>SaveResult</TaskType> <SaveResultTaskParameter> <ResultSource>InMemoryFiles</ResultSource> <ResultDestination> <DestinationType>CloudFileSystem</DestinationType> <InputFile>TaskBook.xlsx</InputFile> <OutputFile>ImpDataBook.xlsx</OutputFile> </ResultDestination> </SaveResultTaskParameter> </TaskDescription> </Tasks></TaskData>}"

Response


HttpResponseMessage with the operation result.

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.Model;
	using Aspose.Cells.Cloud.SDK.Request;
	using System;
	using System.Collections.Generic;

	public partial class CellsApiExample
	{
	public void PostRunTaskExample()
	{
	CellsApi cellsApi = new CellsApi(Environment.GetEnvironmentVariable("CellsCloudTestClientId"), Environment.GetEnvironmentVariable("CellsCloudTestClientSecret"));
	TaskData taskData = new TaskData();
	taskData.Tasks = new List<TaskDescription>();
	TaskDescription task1 = new TaskDescription();
	task1.TaskType = "ImportData";

	ImportDataTaskParameter param1 = new ImportDataTaskParameter();
	ImportBatchDataOption importOption = new ImportBatchDataOption();
	importOption.IsInsert = true;
	importOption.DestinationWorksheet = "Sheet1";
	importOption.Source = new FileSource();
	importOption.Source.FilePath = "Batch_data_xml.txt";
	importOption.Source.FileSourceType = "CloudFileSystem";
	param1.ImportOption = importOption;
	param1.Workbook = new FileSource();
	param1.Workbook.FileSourceType = "CloudFileSystem";
	param1.Workbook.FilePath = "Book1.xlsx";
	task1.TaskParameter = param1;
	taskData.Tasks.Add(task1);
	TaskDescription task2 = new TaskDescription();
	task2.TaskType = "SaveResult";
	SaveResultTaskParameter param2 = new SaveResultTaskParameter();
	param2.ResultDestination = new ResultDestination();
	param2.ResultDestination.DestinationType = "CloudFileSystem";
	param2.ResultDestination.OutputFile = "BOOK1.pdf";
	param2.ResultDestination.InputFile = "Book1.xlsx";
	param2.ResultSource = "InMemoryFiles";
	task2.TaskParameter = param2;
	taskData.Tasks.Add(task2);
	PostRunTaskRequest request = new PostRunTaskRequest
	{
	TaskData = taskData,
	};
	cellsApi.PostRunTask(request);
	}
	}
	}

view raw Examples-DotNet-CSharp-Tasks-ImportTaskData-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\Request\PostRunTaskRequest;
	use \Aspose\Cells\Cloud\Model\TaskDescription;
	use \Aspose\Cells\Cloud\Model\SplitWorkbookTaskParameter;
	use \Aspose\Cells\Cloud\Model\FileSource;
	use \Aspose\Cells\Cloud\Model\TaskData;
	class Workbook {

	public $instance;

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

	public function postTaskDataMultipartContent() {
	$name ='Book1.xlsx';
	$sheet_name ='Sheet1';
	$folder = "TestData/In";
	$task1 = new TaskDescription();
	$task1->setTaskType('SplitWorkbook');
	$param1 = new SplitWorkbookTaskParameter ();
	$param1->setDestinationFileFormat('xlsx');
	$fileSource =new FileSource();
	$fileSource->setFileSourceType('CloudFileSystem');
	$param1->setDestinationFilePosition($fileSource);
	$param1->setSplitNameRule('sheetname');
	$workbook =new FileSource();
	$workbook->setFilePath( $folder. "\\". $name);
	$workbook->setFileSourceType('CloudFileSystem');
	$param1->setWorkbook($workbook);
	$task1->setTaskParameter($param1);
	$taskData = new TaskData();
	$tasks = array($task1);
	$taskData->setTasks($tasks);

	$request = new PostRunTaskRequest();
	$request->setTaskData($taskData);
	$result = $this->instance->postRunTask($request);
	}
	}

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

	?>

view raw Examples-PHP-Workbook-PostTaskDataMultipart-.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 post_run_task
	param1 = AsposeCellsCloud::SplitWorkbookTaskParameter.new({:DestinationFileFormat=>'xlsx' ,:DestinationFilePosition=> AsposeCellsCloud::FileSource.new({:FileSourceType=>'CloudFileSystem'}),:SplitNameRule=>'sheetname',:Workbook=>AsposeCellsCloud::FileSource.new({:FilePath=>$TEMPFOLDER +'\\' + $BOOK1,:FileSourceType=>'CloudFileSystem'})})
	task1 =AsposeCellsCloud::TaskDescription.new({:TaskType=>'SplitWorkbook',:TaskParameter=>param1})
	task_data = AsposeCellsCloud::TaskData.new(:Tasks=>[task1])
	result = @instance.cells_task_post_run_task(task_data)

	expect(result).not_to be_empty

	end

	end

	workbook = Workbook.new()
	puts workbook.post_run_task

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

Node.js

	const { CellsApi, UploadFileRequest, CellsTask_PostRunTaskRequest, TaskData, TaskDescription, SplitWorkbookTaskParameter, FileSource } = 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 CellsTask_PostRunTaskRequest();

	const taskData = new TaskData();
	taskData.tasks = new Array<model.TaskDescription>();
	const task1 = new TaskDescription();
	task1.taskType = "SplitWorkbook";
	const param1 = new SplitWorkbookTaskParameter();
	param1.destinationFileFormat = "xlsx";
	const destinationFilePosition = new FileSource();
	param1.destinationFilePosition.fileSourceType = "CloudFileSystem";
	param1.splitNameRule = "sheetname";
	param1.workbook = new model.FileSource();
	param1.workbook.fileSourceType = "CloudFileSystem";
	param1.workbook.filePath = "Temp" + "\\" + filename;
	task1.taskParameter = param1;
	taskData.tasks.push(task1);
	req.taskData = taskData;
	cellsApi.cellsTaskPostRunTask(req)
	.then((result) => {
	console.log("successful")

	}).catch((error) => {
	console.error('Unhandled Promise Rejection:', error);
	})
	})

view raw Examples-Node.js-SDK-Tasks-ImportTaskData-1.js hosted with ❤ by GitHub

Perl

	# 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 $result =undef;
	my $BOOK1 = 'Book1.xlsx';
	my $MYDOC = 'myDocument.xlsx';
	my $PVTESTFILE = 'TestCase.xlsx';
	my $TEMPFOLDER = 'PerlTest';
	my $SHEET1 = 'Sheet1';
	my $SHEET2 = 'Sheet2';
	my $SHEET3 = 'Sheet3';
	my $SHEET4 = 'Sheet4';
	my $SHEET5 = 'Sheet5';
	my $SHEET6 = 'Sheet6';
	my $SHEET7 = 'Sheet7';
	my $SHEET8 = 'Sheet8';
	my $CELLNAME = 'A1';
	my $RANGE = 'A1:C10';
	my $CELLAREA = 'A1:C10';
	my $api = get_client();

	my $name = $BOOK1; # replace NULL with a proper value
	my @intarray = qw(1 2 3 4) ;
	my $importdata = "<ImportBatchDataOption><DestinationWorksheet>Sheet1</DestinationWorksheet><IsInsert>false</IsInsert><ImportDataType>BatchData</ImportDataType><Source><FileSourceType>CloudSystem</FileSourceType><FilePath>Batch_data_xml_2.txt</FilePath></Source></ImportBatchDataOption>";
	my $folder = $TEMPFOLDER; # replace NULL with a proper value
	ready_file('api'=> $api, 'file'=>$name ,'folder' =>$folder) ;
	$result = $api->cells_workbook_post_import_data(name => $name, importdata => $importdata, folder => $folder);
	ok($result->status eq 'OK' ,'cells_workbook_post_import_data OK');

view raw Examples-Perl-ImportData-postImportDataMultipartContent-1.pl hosted with ❤ by GitHub

Working with Convert Task Working with SaveResult Task