|
import { CellsApi,ImportIntArrayOption,PostImportDataRequest,UploadFileRequest } from "asposecellscloud"; |
|
var fs = require('fs'); |
|
var path = require('path'); |
|
var process = require('process'); |
|
const _ = require('asposecellscloud'); |
|
|
|
const CellsCloudClientId ="....";//get from https://dashboard.aspose.cloud/#/applications |
|
const CellsCloudClientSecret="...";//get from https://dashboard.aspose.cloud/#/applications |
|
const cellsApi = new CellsApi(CellsCloudClientId, CellsCloudClientSecret); |
|
|
|
var remoteFolder = "TestData/In" |
|
var localPath = "TestData/CellsCloud/" |
|
var localName = "Book1.xlsx" |
|
var remoteName = "Book1.xlsx" |
|
|
|
|
|
describe('example', function(){ |
|
it("should call successfully" , function(){ |
|
var localNameRequest = new UploadFileRequest(); |
|
localNameRequest.uploadFiles ={localName:fs.createReadStream(localPath + localName)}; |
|
localNameRequest.path = remoteFolder + "/" + remoteName ; |
|
localNameRequest.storageName =""; |
|
cellsApi.uploadFile(localNameRequest ); |
|
|
|
var importOptionData = new Array<number>();importOptionData.push(1); |
|
importOptionData.push(2); |
|
importOptionData.push(3); |
|
importOptionData.push(4); |
|
var importOption = new ImportIntArrayOption(); |
|
importOption.destinationWorksheet = "Sheet1" ; |
|
importOption.firstColumn = 1 ; |
|
importOption.firstRow = 3 ; |
|
importOption.importDataType = "IntArray" ; |
|
importOption.isInsert = true ; |
|
importOption.isVertical = true ; |
|
importOption.data = importOptionData ; |
|
|
|
var request = new PostImportDataRequest(); |
|
request.name = remoteName; |
|
request.importOption = importOption; |
|
request.folder = remoteFolder; |
|
request.storageName = ""; |
|
return cellsApi.postImportData(request) |
|
}); |