|
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); |
|
}) |
|
}) |