Skip to content

Instantly share code, notes, and snippets.

@aspose-cloud

aspose-cloud/Aspose.Cells-Cloud-SDK-Node

Last active January 5, 2021 02:25
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save aspose-cloud/04e9dd952c704f334a4eceb3925d479e to your computer and use it in GitHub Desktop.
Save aspose-cloud/04e9dd952c704f334a4eceb3925d479e to your computer and use it in GitHub Desktop.
Download ZIP
Aspose.Cells-Cloud-SDK-Node
Raw
Aspose.Cells-Cloud-SDK-Node
Aspose.Cells-Cloud-SDK-Node
Raw
Examples-Node.js-SDK-Cells-ApplyRichTextFormatting-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
const localPath = "TestData/";
describe('cellsPostCellCharacters', function() {
it('should call cellsPostCellCharacters successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.Cells_PostCellCharactersRequest();
req.name = filename;
req.cellName = "G8";
req.sheetName = "Sheet2";
req.folder = "Temp";
var font = new model.Font();
font.size = 10;
var fs1 = new model.FontSetting();
fs1.font = font;
fs1.length = 2;
fs1.startIndex = 0;
var options = new Array<model.FontSetting>();
options.push(fs1);
req.options = options;
return cellsApi.cellsPostCellCharacters(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Cells-CalculateCellFormula-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsPostWorksheetCellSetValue', function() {
it('should call cellsPostWorksheetCellSetValue successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.Cells_PostWorksheetCellSetValueRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.cellName = "A1";
req.folder = "Temp";
req.value = "1";
req.type = "int";
req.formula = null;
return cellsApi.cellsPostWorksheetCellSetValue(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
req.value = "1";
req.type = "String";
return cellsApi.cellsPostWorksheetCellSetValue(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
req.value = "2018/10/09";
req.type = "DateTime";
req.formula = "=Now()";
return cellsApi.cellsPostWorksheetCellSetValue(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
console.log("cellsPostWorksheetCellSetValue test done.")
});
});
});
});
});
});
Raw
Examples-Node.js-SDK-Cells-ChangeCellStyleWorksheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsPostUpdateWorksheetCellStyle', function() {
it('should call cellsPostUpdateWorksheetCellStyle successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.Cells_PostUpdateWorksheetCellStyleRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.cellName = "A1";
var font = new model.Font();
font.size = 19;
var style = new model.Style();
style.font = font;
req.style = style;
req.folder = "Temp";
return cellsApi.cellsPostUpdateWorksheetCellStyle(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Cells-ClearCellContentStyleWorksheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsPostClearContents', function() {
it('should call cellsPostClearContents successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.Cells_PostClearContentsRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.range = "A1:C10";
req.startRow = 1;
req.startColumn = 1;
req.endRow = 3;
req.endColumn = 3;
req.folder = "Temp";
return cellsApi.cellsPostClearContents(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Cells-ClearCellFormattingWorksheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsPostClearFormats', function() {
it('should call cellsPostClearFormats successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.Cells_PostClearFormatsRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.range = "A1:C10";
req.startRow = 1;
req.startColumn = 1;
req.endRow = 3;
req.endColumn = 10;
req.folder = "Temp";
return cellsApi.cellsPostClearFormats(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Cells-GetCellStyleWorksheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsGetWorksheetCellStyle', function() {
it('should call cellsGetWorksheetCellStyle successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.Cells_GetWorksheetCellStyleRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.cellName = "A1";
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCellStyle(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Cells-GetCellWorksheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsGetWorksheetCell', function() {
it('should call cellsGetWorksheetCell successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.Cells_GetWorksheetCellRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.cellOrMethodName = 'A1';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'firstcell';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'endcell';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'maxrow';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'maxdatarow';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'maxcolumn';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'maxdatacolumn';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'minrow';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'mindatarow';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'mincolumn';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'mindatacolumn';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
console.log("cellsGetWorksheetCell test done.")
});
});
});
});
});
});
});
});
});
});
});
});
});
});
Raw
Examples-Node.js-SDK-Cells-GetFirstCellWorksheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsGetWorksheetCell', function() {
it('should call cellsGetWorksheetCell successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.Cells_GetWorksheetCellRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.cellOrMethodName = 'A1';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'firstcell';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'endcell';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'maxrow';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'maxdatarow';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'maxcolumn';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'maxdatacolumn';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'minrow';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'mindatarow';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'mincolumn';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'mindatacolumn';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
console.log("cellsGetWorksheetCell test done.")
});
});
});
});
});
});
});
});
});
});
});
});
});
});
Raw
Examples-Node.js-SDK-Cells-GetLastCellWorksheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsGetWorksheetCell', function() {
it('should call cellsGetWorksheetCell successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.Cells_GetWorksheetCellRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.cellOrMethodName = 'A1';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'firstcell';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'endcell';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'maxrow';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'maxdatarow';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'maxcolumn';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'maxdatacolumn';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'minrow';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'mindatarow';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'mincolumn';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'mindatacolumn';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
console.log("cellsGetWorksheetCell test done.")
});
});
});
});
});
});
});
});
});
});
});
});
});
});
Raw
Examples-Node.js-SDK-Cells-GetMaxColumnWorksheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsGetWorksheetCell', function() {
it('should call cellsGetWorksheetCell successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.Cells_GetWorksheetCellRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.cellOrMethodName = 'A1';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'firstcell';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'endcell';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'maxrow';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'maxdatarow';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'maxcolumn';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'maxdatacolumn';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'minrow';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'mindatarow';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'mincolumn';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'mindatacolumn';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
console.log("cellsGetWorksheetCell test done.")
});
});
});
});
});
});
});
});
});
});
});
});
});
});
Raw
Examples-Node.js-SDK-Cells-GetMaxDataColumnWorksheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsGetWorksheetCell', function() {
it('should call cellsGetWorksheetCell successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.Cells_GetWorksheetCellRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.cellOrMethodName = 'A1';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'firstcell';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'endcell';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'maxrow';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'maxdatarow';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'maxcolumn';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'maxdatacolumn';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'minrow';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'mindatarow';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'mincolumn';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'mindatacolumn';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
console.log("cellsGetWorksheetCell test done.")
});
});
});
});
});
});
});
});
});
});
});
});
});
});
Raw
Examples-Node.js-SDK-Cells-GetMaxDataRowWorksheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsGetWorksheetCell', function() {
it('should call cellsGetWorksheetCell successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.Cells_GetWorksheetCellRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.cellOrMethodName = 'A1';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'firstcell';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'endcell';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'maxrow';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'maxdatarow';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'maxcolumn';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'maxdatacolumn';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'minrow';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'mindatarow';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'mincolumn';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'mindatacolumn';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
console.log("cellsGetWorksheetCell test done.")
});
});
});
});
});
});
});
});
});
});
});
});
});
});
Raw
Examples-Node.js-SDK-Cells-GetMaxRowWorksheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsGetWorksheetCell', function() {
it('should call cellsGetWorksheetCell successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.Cells_GetWorksheetCellRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.cellOrMethodName = 'A1';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'firstcell';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'endcell';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'maxrow';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'maxdatarow';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'maxcolumn';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'maxdatacolumn';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'minrow';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'mindatarow';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'mincolumn';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'mindatacolumn';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
console.log("cellsGetWorksheetCell test done.")
});
});
});
});
});
});
});
});
});
});
});
});
});
});
Raw
Examples-Node.js-SDK-Cells-GetMergedCellWorksheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsWorksheetsGetWorksheetMergedCell', function() {
it('should call cellsWorksheetsGetWorksheetMergedCell successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsWorksheets_GetWorksheetMergedCellRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.mergedCellIndex = 1;
req.folder = "Temp";
return cellsApi.cellsWorksheetsGetWorksheetMergedCell(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Cells-GetMinColumnWorksheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsGetWorksheetCell', function() {
it('should call cellsGetWorksheetCell successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.Cells_GetWorksheetCellRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.cellOrMethodName = 'A1';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'firstcell';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'endcell';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'maxrow';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'maxdatarow';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'maxcolumn';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'maxdatacolumn';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'minrow';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'mindatarow';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'mincolumn';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'mindatacolumn';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
console.log("cellsGetWorksheetCell test done.")
});
});
});
});
});
});
});
});
});
});
});
});
});
});
Raw
Examples-Node.js-SDK-Cells-GetMinDataColumnWorksheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsGetWorksheetCell', function() {
it('should call cellsGetWorksheetCell successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.Cells_GetWorksheetCellRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.cellOrMethodName = 'A1';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'firstcell';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'endcell';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'maxrow';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'maxdatarow';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'maxcolumn';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'maxdatacolumn';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'minrow';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'mindatarow';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'mincolumn';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'mindatacolumn';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
console.log("cellsGetWorksheetCell test done.")
});
});
});
});
});
});
});
});
});
});
});
});
});
});
Raw
Examples-Node.js-SDK-Cells-GetMinDataRowWorksheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsGetWorksheetCell', function() {
it('should call cellsGetWorksheetCell successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.Cells_GetWorksheetCellRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.cellOrMethodName = 'A1';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'firstcell';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'endcell';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'maxrow';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'maxdatarow';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'maxcolumn';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'maxdatacolumn';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'minrow';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'mindatarow';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'mincolumn';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'mindatacolumn';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
console.log("cellsGetWorksheetCell test done.")
});
});
});
});
});
});
});
});
});
});
});
});
});
});
Raw
Examples-Node.js-SDK-Cells-GetMinRowWorksheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsGetWorksheetCell', function() {
it('should call cellsGetWorksheetCell successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.Cells_GetWorksheetCellRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.cellOrMethodName = 'A1';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'firstcell';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'endcell';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'maxrow';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'maxdatarow';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'maxcolumn';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'maxdatacolumn';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'minrow';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'mindatarow';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'mincolumn';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
req.cellOrMethodName = 'mindatacolumn';
req.folder = "Temp";
return cellsApi.cellsGetWorksheetCell(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
console.log("cellsGetWorksheetCell test done.")
});
});
});
});
});
});
});
});
});
});
});
});
});
});
Raw
Examples-Node.js-SDK-Cells-MergeCellsWorksheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsPostWorksheetMerge', function() {
it('should call cellsPostWorksheetMerge successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.Cells_PostWorksheetMergeRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.startRow = 1;
req.startColumn = 1;
req.totalRows = 4;
req.totalColumns = 4;
req.folder = "Temp";
return cellsApi.cellsPostWorksheetMerge(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Cells-SetFormulaForCellWorksheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsPostWorksheetCellSetValue', function() {
it('should call cellsPostWorksheetCellSetValue successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.Cells_PostWorksheetCellSetValueRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.cellName = "A1";
req.folder = "Temp";
req.value = "1";
req.type = "int";
req.formula = null;
return cellsApi.cellsPostWorksheetCellSetValue(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
req.value = "1";
req.type = "String";
return cellsApi.cellsPostWorksheetCellSetValue(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
req.value = "2018/10/09";
req.type = "DateTime";
req.formula = "=Now()";
return cellsApi.cellsPostWorksheetCellSetValue(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
console.log("cellsPostWorksheetCellSetValue test done.")
});
});
});
});
});
});
Raw
Examples-Node.js-SDK-Cells-SetRangeValueWorksheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsPostSetCellRangeValue', function() {
it('should call cellsPostSetCellRangeValue successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.Cells_PostSetCellRangeValueRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.cellarea = "A1:C10";
req.folder = "Temp";
req.value = "1";
req.type = "int";
return cellsApi.cellsPostSetCellRangeValue(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
req.value = "12345";
req.type = "String";
return cellsApi.cellsPostSetCellRangeValue(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
req.value = "2017-10-1";
req.type = "DateTime";
return cellsApi.cellsPostSetCellRangeValue(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
console.log("cellsPostSetCellRangeValue test done.")
});
});
});
});
});
});
Raw
Examples-Node.js-SDK-Cells-SetValueOfCell-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsPostWorksheetCellSetValue', function() {
it('should call cellsPostWorksheetCellSetValue successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.Cells_PostWorksheetCellSetValueRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.cellName = "A1";
req.folder = "Temp";
req.value = "1";
req.type = "int";
req.formula = null;
return cellsApi.cellsPostWorksheetCellSetValue(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
req.value = "1";
req.type = "String";
return cellsApi.cellsPostWorksheetCellSetValue(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
req.value = "2018/10/09";
req.type = "DateTime";
req.formula = "=Now()";
return cellsApi.cellsPostWorksheetCellSetValue(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
console.log("cellsPostWorksheetCellSetValue test done.")
});
});
});
});
});
});
Raw
Examples-Node.js-SDK-Cells-UnmergeCellsWorksheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsPostWorksheetUnmerge', function() {
it('should call cellsPostWorksheetUnmerge successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.Cells_PostWorksheetUnmergeRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.startRow = 1;
req.startColumn = 1;
req.totalRows = 4;
req.totalColumns = 4;
req.folder = "Temp";
return cellsApi.cellsPostWorksheetUnmerge(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Charts-AddChart-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsChartsPutWorksheetAddChart', function() {
it('should call cellsChartsPutWorksheetAddChart successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "myDocument.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsCharts_PutWorksheetAddChartRequest();
req.name = filename;
req.sheetName = "Sheet4";
req.chartType = "Pie";
req.upperLeftRow = 5;
req.upperLeftColumn = 5;
req.lowerRightRow = 10;
req.lowerRightColumn = 10;
req.area = "C7:D11";
req.isVertical = true;
req.isAutoGetSerialName = null;
req.folder = "Temp";
return cellsApi.cellsChartsPutWorksheetAddChart(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Charts-ConvertChartToImage-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsChartsGetWorksheetChart', function() {
it('should call cellsChartsGetWorksheetChart successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "myDocument.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsCharts_GetWorksheetChartRequest();
req.name = filename;
req.sheetName = "Sheet3";
req.chartNumber = 0;
req.format = "png";
req.folder = "Temp";
return cellsApi.cellsChartsGetWorksheetChart(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Charts-DeleteAllCharts-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsChartsDeleteWorksheetClearCharts', function() {
it('should call cellsChartsDeleteWorksheetClearCharts successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "myDocument.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsCharts_DeleteWorksheetClearChartsRequest();
req.name = filename;
req.sheetName = "Sheet3";
req.folder = "Temp";
return cellsApi.cellsChartsDeleteWorksheetClearCharts(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Charts-DeleteChart-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsChartsDeleteWorksheetDeleteChart', function() {
it('should call cellsChartsDeleteWorksheetDeleteChart successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "myDocument.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsCharts_DeleteWorksheetDeleteChartRequest();
req.name = filename;
req.sheetName = "Sheet3";
req.chartIndex = 0;
req.folder = "Temp";
return cellsApi.cellsChartsDeleteWorksheetDeleteChart(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Charts-DeleteChartTitle-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsChartsDeleteWorksheetChartTitle', function() {
it('should call cellsChartsDeleteWorksheetChartTitle successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "myDocument.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsCharts_DeleteWorksheetChartTitleRequest();
req.name = filename;
req.sheetName = "Sheet3";
req.chartIndex = 0;
req.folder = "Temp";
return cellsApi.cellsChartsDeleteWorksheetChartTitle(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Charts-GetChart-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsChartsGetWorksheetChart', function() {
it('should call cellsChartsGetWorksheetChart successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "myDocument.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsCharts_GetWorksheetChartRequest();
req.name = filename;
req.sheetName = "Sheet3";
req.chartNumber = 0;
req.format = "png";
req.folder = "Temp";
return cellsApi.cellsChartsGetWorksheetChart(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Charts-GetChartArea-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsChartAreaGetChartArea', function() {
it('should call cellsChartAreaGetChartArea successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "myDocument.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsChartArea_GetChartAreaRequest();
req.name = filename;
req.sheetName = "Sheet3";
req.chartIndex = 0;
req.folder = "Temp";
return cellsApi.cellsChartAreaGetChartArea(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Charts-GetChartFillFormat-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsChartAreaGetChartAreaFillFormat', function() {
it('should call cellsChartAreaGetChartAreaFillFormat successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "myDocument.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsChartArea_GetChartAreaFillFormatRequest();
req.name = filename;
req.sheetName = "Sheet3";
req.chartIndex = 0;
req.folder = "Temp";
return cellsApi.cellsChartAreaGetChartAreaFillFormat(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
});
Raw
Examples-Node.js-SDK-Charts-GetChartLegend-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsChartsGetWorksheetChartLegend', function() {
it('should call cellsChartsGetWorksheetChartLegend successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "myDocument.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsCharts_GetWorksheetChartLegendRequest();
req.name = filename;
req.sheetName = "Sheet3";
req.chartIndex = 0;
req.folder = "Temp";
return cellsApi.cellsChartsGetWorksheetChartLegend(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Charts-HideChartLegend-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsChartsDeleteWorksheetChartLegend', function() {
it('should call cellsChartsDeleteWorksheetChartLegend successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "myDocument.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsCharts_DeleteWorksheetChartLegendRequest();
req.name = filename;
req.sheetName = "Sheet3";
req.chartIndex = 1;
req.folder = "Temp";
return cellsApi.cellsChartsDeleteWorksheetChartLegend(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Charts-SetChartTitle-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsChartsPutWorksheetChartTitle', function() {
it('should call cellsChartsPutWorksheetChartTitle successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "myDocument.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsCharts_PutWorksheetChartTitleRequest();
req.name = filename;
req.sheetName = "Sheet3";
req.chartIndex = 0;
req.folder = "Temp";
var title = new model.Title();
title.text = "New title";
req.title = title;
return cellsApi.cellsChartsPutWorksheetChartTitle(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
});
Raw
Examples-Node.js-SDK-Charts-ShowChartLegend-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsChartsPutWorksheetChartLegend', function() {
it('should call cellsChartsPutWorksheetChartLegend successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "myDocument.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsCharts_PutWorksheetChartLegendRequest();
req.name = filename;
req.sheetName = "Sheet3";
req.chartIndex = 0;
req.folder = "Temp";
return cellsApi.cellsChartsPutWorksheetChartLegend(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Charts-UpdateChartLegend-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsChartsPostWorksheetChartLegend', function() {
it('should call cellsChartsPostWorksheetChartLegend successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "myDocument.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsCharts_PostWorksheetChartLegendRequest();
req.name = filename;
req.sheetName = "Sheet3";
req.chartIndex = 0;
req.folder = "Temp";
var legend = new model.Legend();
legend.width = 10;
req.legend = legend;
return cellsApi.cellsChartsPostWorksheetChartLegend(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Charts-UpdateChartProperties-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsChartsPostWorksheetChart', function() {
it('should call cellsChartsPostWorksheetChart successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "myDocument.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsCharts_PostWorksheetChartRequest();
req.name = filename;
req.sheetName = "Sheet3";
req.chartIndex = 0;
req.folder = "Temp";
var chart = new model.Chart();
chart.autoScaling = true;
req.chart = chart;
return cellsApi.cellsChartsPostWorksheetChart(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Charts-UpdateChartTitle-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsChartsPutWorksheetChartTitle', function() {
it('should call cellsChartsPutWorksheetChartTitle successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "myDocument.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsCharts_PutWorksheetChartTitleRequest();
req.name = filename;
req.sheetName = "Sheet3";
req.chartIndex = 0;
req.folder = "Temp";
var title = new model.Title();
title.text = "New title";
req.title = title;
return cellsApi.cellsChartsPutWorksheetChartTitle(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
});
Raw
Examples-Node.js-SDK-ConditionalFormatting-AddConditionforFormatCondition-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsConditionalFormattingsPutWorksheetFormatConditionCondition', function() {
it('should call cellsConditionalFormattingsPutWorksheetFormatConditionCondition successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsConditionalFormattings_PutWorksheetFormatConditionConditionRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.index = 0;
req.type = "CellValue";
req.operatorType = "Between";
req.formula1 = "v1";
req.formula2 = "v2";
req.folder = "Temp";
return cellsApi.cellsConditionalFormattingsPutWorksheetFormatConditionCondition(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-ConditionalFormatting-AddFormatCondition-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsConditionalFormattingsPutWorksheetFormatCondition', function() {
it('should call cellsConditionalFormattingsPutWorksheetFormatCondition successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsConditionalFormattings_PutWorksheetFormatConditionRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.index = 0;
req.cellArea = "A1:C10";
req.type = "CellValue";
req.operatorType = "Between";
req.formula1 = "v1";
req.formula2 = "v2";
req.folder = "Temp";
return cellsApi.cellsConditionalFormattingsPutWorksheetFormatCondition(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-ConditionalFormatting-ClearConditionFormattings-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsConditionalFormattingsDeleteWorksheetConditionalFormattings', function() {
it('should call cellsConditionalFormattingsDeleteWorksheetConditionalFormattings successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsConditionalFormattings_DeleteWorksheetConditionalFormattingsRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.folder = "Temp";
return cellsApi.cellsConditionalFormattingsDeleteWorksheetConditionalFormattings(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-ConditionalFormatting-FormatConditionArea-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsConditionalFormattingsPutWorksheetFormatConditionArea', function() {
it('should call cellsConditionalFormattingsPutWorksheetFormatConditionArea successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsConditionalFormattings_PutWorksheetFormatConditionAreaRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.index = 0;
req.cellArea = "A1:C10";
req.folder = "Temp";
return cellsApi.cellsConditionalFormattingsPutWorksheetFormatConditionArea(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-ConditionalFormatting-GetConditionalFormatting-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsConditionalFormattingsGetWorksheetConditionalFormatting', function() {
it('should call cellsConditionalFormattingsGetWorksheetConditionalFormatting successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsConditionalFormattings_GetWorksheetConditionalFormattingRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.index = 0;
req.folder = "Temp";
return cellsApi.cellsConditionalFormattingsGetWorksheetConditionalFormatting(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-ConditionalFormatting-GetWorksheetConditionalFormatting-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsConditionalFormattingsGetWorksheetConditionalFormattings', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsConditionalFormattings_GetWorksheetConditionalFormattingsRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.folder = "Temp";
return cellsApi.cellsConditionalFormattingsGetWorksheetConditionalFormattings(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-ConditionalFormatting-RemoveCellAreaFromConditionalFormatting-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsConditionalFormattingsDeleteWorksheetConditionalFormattingArea', function() {
it('should call cellsConditionalFormattingsDeleteWorksheetConditionalFormattingArea successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsConditionalFormattings_DeleteWorksheetConditionalFormattingAreaRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.startRow = 1;
req.startColumn = 1;
req.totalRows = 4;
req.totalColumns = 6;
req.folder = "Temp";
return cellsApi.cellsConditionalFormattingsDeleteWorksheetConditionalFormattingArea(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-ConditionalFormatting-RemoveConditionalFormatting-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsConditionalFormattingsDeleteWorksheetConditionalFormatting', function() {
it('should call cellsConditionalFormattingsDeleteWorksheetConditionalFormatting successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsConditionalFormattings_DeleteWorksheetConditionalFormattingRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.index = 0;
req.folder = "Temp";
return cellsApi.cellsConditionalFormattingsDeleteWorksheetConditionalFormatting(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Document-Properties-GetAllProperties-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsPropertiesGetDocumentProperties', function() {
it('should call cellsPropertiesGetDocumentProperties successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "TestCase.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsProperties_GetDocumentPropertiesRequest();
req.name = filename;
req.folder = "Temp";
return cellsApi.cellsPropertiesGetDocumentProperties(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Document-Properties-GetParticularProperty-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsPropertiesGetDocumentProperty', function() {
it('should call cellsPropertiesGetDocumentProperty successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "TestCase.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsProperties_GetDocumentPropertyRequest();
req.name = filename;
req.propertyName = "Author";
req.folder = "Temp";
return cellsApi.cellsPropertiesGetDocumentProperty(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Document-Properties-RemoveAllProperties-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsPropertiesDeleteDocumentProperties', function() {
it('should call cellsPropertiesDeleteDocumentProperties successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "TestCase.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsProperties_DeleteDocumentPropertiesRequest();
req.name = filename;
req.folder = "Temp";
return cellsApi.cellsPropertiesDeleteDocumentProperties(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Document-Properties-RemoveParticularProperty-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsPropertiesDeleteDocumentProperty', function() {
it('should call cellsPropertiesDeleteDocumentProperty successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "TestCase.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsProperties_DeleteDocumentPropertyRequest();
req.name = filename;
req.propertyName = "Author";
req.folder = "Temp";
return cellsApi.cellsPropertiesDeleteDocumentProperty(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Document-Properties-SetParticularProperty-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsPropertiesPutDocumentProperty', function() {
it('should call cellsPropertiesPutDocumentProperty successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "TestCase.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsProperties_PutDocumentPropertyRequest();
req.name = filename;
req.propertyName = "Name";
var property = new model.CellsDocumentProperty();
property.name = "Author";
property.value = "Val";
req.property = property;
req.folder = "Temp";
return cellsApi.cellsPropertiesPutDocumentProperty(req)
.then((result) => {
expect(result.body.code).to.equal(201);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
});
Raw
Examples-Node.js-SDK-Images-AutoShapeToImageWorksheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsAutoshapesGetWorksheetAutoshape', function() {
it('should call cellsAutoshapesGetWorksheetAutoshape successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "myDocument.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
// var data = fs.createReadStream(BaseTest.localTestDataFolder + "threeD.pdf");//readFileSync -> error
// var req = new model.uploadFileRequest();
// req.path = "3DTestNodejs/threeD3.pdf";
// req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsAutoshapes_GetWorksheetAutoshapeRequest();
req.name = filename;
req.sheetName = "Sheet2";
req.autoshapeNumber = 4;
req.folder = "Temp";
return cellsApi.cellsAutoshapesGetWorksheetAutoshape(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-ImportData-PostImportDataCloudFile-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsWorkbookPostImportData', function() {
it('should call cellsWorkbookPostImportData successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsWorkbook_PostImportDataRequest();
req.name = filename;
req.folder = "Temp";
var data = new model.ImportIntArrayOption();
data.destinationWorksheet = "Sheet1";
data.firstColumn = 1;
data.firstRow = 3;
data.importDataType = "IntArray";
data.isVertical = true;
data.data = [ 1, 2, 3, 4 ];
req.importData = data;
return cellsApi.cellsWorkbookPostImportData(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-ImportData-postImportDataMultipartContent-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsWorkbookPostImportData', function() {
it('should call cellsWorkbookPostImportData successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsWorkbook_PostImportDataRequest();
req.name = filename;
req.folder = "Temp";
var data = new model.ImportIntArrayOption();
data.destinationWorksheet = "Sheet1";
data.firstColumn = 1;
data.firstRow = 3;
data.importDataType = "IntArray";
data.isVertical = true;
data.data = [ 1, 2, 3, 4 ];
req.importData = data;
return cellsApi.cellsWorkbookPostImportData(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Oleobjects-AddOleObjectsWorksheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
escribe('cellsOleObjectsPutWorksheetOleObject', function() {
it('should call cellsOleObjectsPutWorksheetOleObject successfully', function() {
const filename = "Book1.xlsx";
const filename1 = "OLEDoc.docx";
const filename2 = "word.jpg";
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
const filename1= "word.jpg";
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
var data =fs.createReadStream(localPath + filename1);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename1;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
const filename2 = "OLEDoc.docx";
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
var data =fs.createReadStream(localPath + filename2);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename2;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsOleObjects_PutWorksheetOleObjectRequest();
req.name = filename;
req.sheetName = "Sheet6";
req.folder = "Temp";
req.oleObject = null;
req.upperLeftRow = 1;
req.upperLeftColumn = 1;
req.height = 100;
req.width = 80;
req.oleFile = filename1;
req.imageFile = filename2;
return cellsApi.cellsOleObjectsPutWorksheetOleObject(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
});
});
});
Raw
Examples-Node.js-SDK-Oleobjects-ConvertOleObjectToImage-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsOleObjectsGetWorksheetOleObject', function() {
it('should call cellsOleObjectsGetWorksheetOleObject successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsOleObjects_GetWorksheetOleObjectRequest();
req.name = filename;
req.sheetName = "Sheet6";
req.objectNumber = 0;
req.folder = "Temp";
return cellsApi.cellsOleObjectsGetWorksheetOleObject(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Oleobjects-DeleteAllOleObjectsWorksheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsOleObjectsDeleteWorksheetOleObjects', function() {
it('should call cellsOleObjectsDeleteWorksheetOleObjects successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsOleObjects_DeleteWorksheetOleObjectsRequest();
req.name = filename;
req.sheetName = "Sheet6";
req.folder = "Temp";
return cellsApi.cellsOleObjectsDeleteWorksheetOleObjects(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Oleobjects-DeleteSpecificOleObjectWorksheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsOleObjectsDeleteWorksheetOleObject', function() {
it('should call cellsOleObjectsDeleteWorksheetOleObject successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsOleObjects_DeleteWorksheetOleObjectRequest();
req.name = filename;
req.sheetName = "Sheet6";
req.oleObjectIndex = 0;
req.folder = "Temp";
return cellsApi.cellsOleObjectsDeleteWorksheetOleObject(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Oleobjects-GetOleObjectWorksheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsOleObjectsGetWorksheetOleObject', function() {
it('should call cellsOleObjectsGetWorksheetOleObject successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsOleObjects_GetWorksheetOleObjectRequest();
req.name = filename;
req.sheetName = "Sheet6";
req.objectNumber = 0;
req.folder = "Temp";
return cellsApi.cellsOleObjectsGetWorksheetOleObject(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Oleobjects-UpdateSpecificOleObjectsWorksheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsOleObjectsPostUpdateWorksheetOleObject', function() {
it('should call cellsOleObjectsPostUpdateWorksheetOleObject successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsOleObjects_PostUpdateWorksheetOleObjectRequest();
req.name = filename;
req.sheetName = "Sheet6";
req.folder = "Temp";
req.oleObjectIndex = 0;
var ole = new model.OleObject();
ole.left = 10;
ole.right = 10;
ole.height = 90;
ole.width = 78;
req.ole = ole;
return cellsApi.cellsOleObjectsPostUpdateWorksheetOleObject(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Pictures-AddPicturesWorksheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsPicturesPutWorksheetAddPicture', function() {
it('should call cellsPicturesPutWorksheetAddPicture successfully', function() {
const picturePath = "WaterMark.png";
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var data =fs.createReadStream(localPath + picturePath);
var req = new model.UploadFileRequest();
req.path = "Temp/" + picturePath;
req.file = data;
return cellsApi.uploadFile(req)
.then(() => {
var req = new model.CellsPictures_PutWorksheetAddPictureRequest();
req.name = filename;
req.sheetName = "Sheet6";
req.picture = null;
req.upperLeftRow = 1;
req.upperLeftColumn = 1;
req.lowerRightRow = 10;
req.lowerRightColumn = 10;
req.picturePath = "Temp/WaterMark.png";
req.folder = "Temp";
return cellsApi.cellsPicturesPutWorksheetAddPicture(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
});
Raw
Examples-Node.js-SDK-Pictures-ConvertPictureToImage-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsPicturesGetWorksheetPicture', function() {
it('should call cellsPicturesGetWorksheetPicture successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsPictures_GetWorksheetPictureRequest();
req.name = filename;
req.sheetName = "Sheet6";
req.pictureIndex = 0;
req.folder = "Temp";
return cellsApi.cellsPicturesGetWorksheetPicture(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Pictures-DeleteAllPicturesWorksheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsPicturesDeleteWorksheetPictures', function() {
it('should call cellsPicturesDeleteWorksheetPictures successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsPictures_DeleteWorksheetPicturesRequest();
req.name = filename;
req.sheetName = "Sheet6";
req.folder = "Temp";
return cellsApi.cellsPicturesDeleteWorksheetPictures(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Pictures-DeleteSpecificPictureWorksheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsPicturesDeleteWorksheetPicture', function() {
it('should call cellsPicturesDeleteWorksheetPicture successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsPictures_DeleteWorksheetPictureRequest();
req.name = filename;
req.sheetName = "Sheet6";
req.pictureIndex = 0;
req.folder = "Temp";
return cellsApi.cellsPicturesDeleteWorksheetPicture(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Pictures-GetPictureWorksheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsPicturesGetWorksheetPicture', function() {
it('should call cellsPicturesGetWorksheetPicture successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsPictures_GetWorksheetPictureRequest();
req.name = filename;
req.sheetName = "Sheet6";
req.pictureIndex = 0;
req.folder = "Temp";
return cellsApi.cellsPicturesGetWorksheetPicture(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Pictures-UpdateSpecificPictureWorksheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsPicturesPostWorksheetPicture', function() {
it('should call cellsPicturesPostWorksheetPicture successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsPictures_PostWorksheetPictureRequest();
req.name = filename;
req.sheetName = "Sheet6";
req.pictureIndex = 0;
req.picture = new model.Picture();
req.picture.left = 10;
req.folder = "Temp";
return cellsApi.cellsPicturesPostWorksheetPicture(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-PivotTables-AddPivotFieldInPivottable-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsPivotTablesPutPivotTableField', function() {
it('should call cellsPivotTablesPutPivotTableField successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "TestCase.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsPivotTables_PutPivotTableFieldRequest();
req.name = filename;
req.sheetName = "Sheet4";
req.pivotTableIndex = 0;
req.pivotFieldType = "Row";
req.request = new model.PivotTableFieldRequest();
req.request.data = [1];
req.needReCalculate = null;
req.folder = "Temp";
return cellsApi.cellsPivotTablesPutPivotTableField(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-PivotTables-AddPivottableWorksheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsPivotTablesPutWorksheetPivotTable', function() {
it('should call cellsPivotTablesPutWorksheetPivotTable successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "TestCase.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsPivotTables_PutWorksheetPivotTableRequest();
req.name = filename;
req.sheetName = "Sheet4";
req.request = null;
req.folder = "Temp";
req.sourceData = "Sheet1!C6:E13";
req.destCellName = "C1";
req.tableName = "TestPivot";
req.useSameSource = true;
return cellsApi.cellsPivotTablesPutWorksheetPivotTable(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-PivotTables-DeleteWorksheetPivotTable-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsPivotTablesDeleteWorksheetPivotTables', function() {
it('should call cellsPivotTablesDeleteWorksheetPivotTables successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "TestCase.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsPivotTables_DeleteWorksheetPivotTablesRequest();
req.name = filename;
req.sheetName = "Sheet4";
req.folder = "Temp";
return cellsApi.cellsPivotTablesDeleteWorksheetPivotTables(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-PivotTables-DeleteWorksheetPivotTableIndex-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsPivotTablesDeleteWorksheetPivotTable', function() {
it('should call cellsPivotTablesDeleteWorksheetPivotTable successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "TestCase.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsPivotTables_DeleteWorksheetPivotTableRequest();
req.name = filename;
req.sheetName = "Sheet4";
req.pivotTableIndex = 0;
req.folder = "Temp";
return cellsApi.cellsPivotTablesDeleteWorksheetPivotTable(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-PivotTables-GetWorksheetPivotTableByIndex-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsPivotTablesGetWorksheetPivotTable', function() {
it('should call cellsPivotTablesGetWorksheetPivotTable successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "TestCase.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsPivotTables_GetWorksheetPivotTableRequest();
req.name = filename;
req.sheetName = "Sheet4";
req.pivottableIndex = 0;
req.folder = "Temp";
return cellsApi.cellsPivotTablesGetWorksheetPivotTable(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-PivotTables-GetWorksheetPivotTables-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsPivotTablesGetWorksheetPivotTables', function() {
it('should call cellsPivotTablesGetWorksheetPivotTables successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "TestCase.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsPivotTables_GetWorksheetPivotTablesRequest();
req.name = filename;
req.sheetName = "Sheet4";
req.folder = "Temp";
return cellsApi.cellsPivotTablesGetWorksheetPivotTables(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Rows-AddEmptyRowInWorksheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsPutInsertWorksheetRow', function() {
it('should call cellsPutInsertWorksheetRow successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.Cells_PutInsertWorksheetRowRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.rowIndex = 1;
req.folder = "Temp";
return cellsApi.cellsPutInsertWorksheetRow(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Rows-AutoFitRowsInWorksheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsWorkbookPostAutofitWorkbookRows', function() {
it('should call cellsWorkbookPostAutofitWorkbookRows successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsWorkbook_PostAutofitWorkbookRowsRequest();
req.name = filename;
req.folder = "Temp";
req.autoFitterOptions = null;
req.startRow = 1;
req.endRow = 100;
req.onlyAuto = true;
return cellsApi.cellsWorkbookPostAutofitWorkbookRows(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Rows-CopyRowsInWorksheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsPostCopyWorksheetRows', function() {
it('should call cellsPostCopyWorksheetRows successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.Cells_PostCopyWorksheetRowsRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.worksheet = "Sheet2";
req.sourceRowIndex = 1;
req.destinationRowIndex = 1;
req.rowNumber = 1;
req.folder = "Temp";
return cellsApi.cellsPostCopyWorksheetRows(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Rows-DeleteRowFromWorksheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsDeleteWorksheetRow', function() {
it('should call cellsDeleteWorksheetRow successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.Cells_DeleteWorksheetRowRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.rowIndex = 1;
req.folder = "Temp";
return cellsApi.cellsDeleteWorksheetRow(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Rows-GetRowFromWorksheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsGetWorksheetRow', function() {
it('should call cellsGetWorksheetRow successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.Cells_GetWorksheetRowRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.rowIndex = 1;
req.folder = "Temp";
return cellsApi.cellsGetWorksheetRow(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Rows-GroupRowsInWorksheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsPostGroupWorksheetRows', function() {
it('should call cellsPostGroupWorksheetRows successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.Cells_PostGroupWorksheetRowsRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.firstIndex = 1;
req.lastIndex = 1;
req.hide = true;
req.folder = "Temp";
return cellsApi.cellsPostGroupWorksheetRows(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Rows-HideRowsInWorksheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsPostHideWorksheetRows', function() {
it('should call cellsPostHideWorksheetRows successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.Cells_PostHideWorksheetRowsRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.startrow = 1;
req.totalRows = 2;
req.folder = "Temp";
return cellsApi.cellsPostHideWorksheetRows(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Rows-UngroupRowsInWorksheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsPostUngroupWorksheetRows', function() {
it('should call cellsPostUngroupWorksheetRows successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.Cells_PostUngroupWorksheetRowsRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.firstIndex = 1;
req.lastIndex = 5;
req.isAll = true;
req.folder = "Temp";
return cellsApi.cellsPostUngroupWorksheetRows(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Rows-UnhideRowsInWorksheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsPostUnhideWorksheetRows', function() {
it('should call cellsPostUnhideWorksheetRows successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.Cells_PostUnhideWorksheetRowsRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.startrow = 1;
req.totalRows = 8;
req.height = 18;
req.folder = "Temp";
return cellsApi.cellsPostUnhideWorksheetRows(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Table-SortTableData-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsListObjectsPostWorksheetListObjectSortTable', function() {
it('should call cellsListObjectsPostWorksheetListObjectSortTable successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsListObjects_PostWorksheetListObjectSortTableRequest();
req.name = filename;
req.sheetName = "Sheet7";
req.listObjectIndex = 0;
req.dataSorter = new model.DataSorter();
req.dataSorter.caseSensitive = true;
req.folder = "Temp";
return cellsApi.cellsListObjectsPostWorksheetListObjectSortTable(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Tasks-ImportTaskData-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
const localPath = "TestData/";
var fs = require('fs');
var path = require('path');
var assert = require('assert');
describe('CellsTaskApi', function() {
this.timeout(200000);
describe('cellsTaskPostRunTask', function() {
it('should call cellsTaskPostRunTask successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsTask_PostRunTaskRequest();
var taskData = new model.TaskData();
taskData.tasks = new Array<model.TaskDescription>();
var task1 = new model.TaskDescription();
task1.taskType = "SplitWorkbook";
var param1 = new model.SplitWorkbookTaskParameter();
param1.destinationFileFormat = "xlsx";
param1.destinationFilePosition = new model.FileSource();
// param1.destinationFilePosition.filePath = "Temp";
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;
return cellsApi.cellsTaskPostRunTask(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
});
});
});
});
});
Raw
Examples-Node.js-SDK-Text-FindTextWorkbook-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsWorkbookPostWorkbooksTextSearch', function() {
it('should call cellsWorkbookPostWorkbooksTextSearch successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsWorkbook_PostWorkbooksTextSearchRequest();
req.name = filename;
req.folder = "Temp";
req.text = "test";
return cellsApi.cellsWorkbookPostWorkbooksTextSearch(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Text-FindTextWorksheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsWorksheetsPostWorksheetTextSearch', function() {
it('should call cellsWorksheetsPostWorksheetTextSearch successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsWorksheets_PostWorksheetTextSearchRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.text = "123456";
req.folder = "Temp";
return cellsApi.cellsWorksheetsPostWorksheetTextSearch(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Text-GetTextItemWorkbook-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsWorkbookGetWorkbookTextItems', function() {
it('should call cellsWorkbookGetWorkbookTextItems successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsWorkbook_GetWorkbookTextItemsRequest();
req.name = filename;
req.folder = "Temp";
return cellsApi.cellsWorkbookGetWorkbookTextItems(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Text-GetTextItemWorksheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsWorksheetsGetWorksheetTextItems', function() {
it('should call cellsWorksheetsGetWorksheetTextItems successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsWorksheets_GetWorksheetTextItemsRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.folder = "Temp";
return cellsApi.cellsWorksheetsGetWorksheetTextItems(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Text-ReplaceTextWorkbook-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsWorkbookPostWorkbooksTextReplace', function() {
it('should call cellsWorkbookPostWorkbooksTextReplace successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsWorkbook_PostWorkbooksTextReplaceRequest();
req.name = filename;
req.folder = "Temp";
req.oldValue = "!22";
req.newValue = "22";
return cellsApi.cellsWorkbookPostWorkbooksTextReplace(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Text-ReplaceTextWorksheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsWorksheetsPostWorsheetTextReplace', function() {
it('should call cellsWorksheetsPostWorsheetTextReplace successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsWorksheets_PostWorsheetTextReplaceRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.oldValue = "1234";
req.newValue = "56678";
req.folder = "Temp";
return cellsApi.cellsWorksheetsPostWorsheetTextReplace(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Workbook-ConvertToAnotherFormat-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsSaveAsPostDocumentSaveAs 1', function() {
it('should call cellsSaveAsPostDocumentSaveAs successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsSaveAs_PostDocumentSaveAsRequest();
req.name = filename;
req.saveOptions = new model.OoxmlSaveOptions();
req.saveOptions.saveFormat = "xlsx";
req.newfilename = "temp/newbook.pdf";
req.isAutoFitRows = true;
req.isAutoFitColumns = true;
req.folder = "Temp";
return cellsApi.cellsSaveAsPostDocumentSaveAs(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
Raw
Examples-Node.js-SDK-Workbook-ConvertWorkbookToAnotherFormatWithoutStorage-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsWorkbookPutConvertWorkbook', function() {
it('should call cellsWorkbookPutConvertWorkbook successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
// var data =fs.createReadStream(localPath + filename);
var req = new model.CellsWorkbook_PutConvertWorkbookRequest({
workbook : fs.createReadStream(localPath + filename),
format : "pdf",
});
return cellsApi.cellsWorkbookPutConvertWorkbook(req)
.then((result) => {
var req = new model.CellsWorkbook_PutConvertWorkbookRequest({
workbook : fs.createReadStream(localPath + filename),
format : "pdf",
});
return cellsApi.cellsWorkbookPutConvertWorkbook(req)
.then((result) => {
expect(result.body.toString().length).to.greaterThan(0);
});
});
});
});
Raw
Examples-Node.js-SDK-Workbook-ConvertWorkbookWithAdditionalSettings-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsWorkbookPutConvertWorkbook', function() {
it('should call cellsWorkbookPutConvertWorkbook successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
// var data =fs.createReadStream(localPath + filename);
var req = new model.CellsWorkbook_PutConvertWorkbookRequest({
workbook : fs.createReadStream(localPath + filename),
format : "pdf",
});
return cellsApi.cellsWorkbookPutConvertWorkbook(req)
.then((result) => {
var req = new model.CellsWorkbook_PutConvertWorkbookRequest({
workbook : fs.createReadStream(localPath + filename),
format : "pdf",
});
return cellsApi.cellsWorkbookPutConvertWorkbook(req)
.then((result) => {
expect(result.body.toString().length).to.greaterThan(0);
});
});
});
});
Raw
Examples-Node.js-SDK-Workbook-CreateEmptyWorkbook-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsWorkbookPutWorkbookCreate', function() {
it('should call cellsWorkbookPutWorkbookCreate successfully', function() {
const dataFile = "ReportData.xml";
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
const dataFile = "Book1.xlsx";
var data =fs.createReadStream(localPath + dataFile);
var req = new model.UploadFileRequest();
req.path = "Temp/" + dataFile;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsWorkbook_PutWorkbookCreateRequest();
req.folder = "Temp";
var date = new Date();
var year = date.getUTCFullYear();
var month = date.getUTCMonth();
var day = date.getUTCDate();
var hours = date.getUTCHours();
var min = date.getUTCMinutes();
var sec = date.getUTCSeconds();
req.name ="NewBook" + year + "" + month + "" + day + "" + ".pdf";
req.templateFile = "Temp/Book1.xlsx";
req.dataFile = "ReportData.xml";
req.isWriteOver = true;
return cellsApi.cellsWorkbookPutWorkbookCreate(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
});
Raw
Examples-Node.js-SDK-Workbook-CreateWorkbookFromSmartMakerTemplate-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsWorkbookPutWorkbookCreate', function() {
it('should call cellsWorkbookPutWorkbookCreate successfully', function() {
const dataFile = "ReportData.xml";
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
const dataFile = "Book1.xlsx";
var data =fs.createReadStream(localPath + dataFile);
var req = new model.UploadFileRequest();
req.path = "Temp/" + dataFile;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsWorkbook_PutWorkbookCreateRequest();
req.folder = "Temp";
var date = new Date();
var year = date.getUTCFullYear();
var month = date.getUTCMonth();
var day = date.getUTCDate();
var hours = date.getUTCHours();
var min = date.getUTCMinutes();
var sec = date.getUTCSeconds();
req.name ="NewBook" + year + "" + month + "" + day + "" + ".xlsx";
req.templateFile = "Temp/Book1.xlsx";
req.dataFile = "ReportData.xml";
req.isWriteOver = true;
return cellsApi.cellsWorkbookPutWorkbookCreate(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
});
Raw
Examples-Node.js-SDK-Workbook-CreateWorkbookFromTemplate-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsWorkbookPutWorkbookCreate', function() {
it('should call cellsWorkbookPutWorkbookCreate successfully', function() {
const dataFile = "ReportData.xml";
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
const dataFile = "Book1.xlsx";
var data =fs.createReadStream(localPath + dataFile);
var req = new model.UploadFileRequest();
req.path = "Temp/" + dataFile;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsWorkbook_PutWorkbookCreateRequest();
req.folder = "Temp";
var date = new Date();
var year = date.getUTCFullYear();
var month = date.getUTCMonth();
var day = date.getUTCDate();
var hours = date.getUTCHours();
var min = date.getUTCMinutes();
var sec = date.getUTCSeconds();
req.name ="NewBook" + year + "" + month + "" + day + "" + ".xlsx";
req.templateFile = "Temp/Book1.xlsx";
req.dataFile = "ReportData.xml";
req.isWriteOver = true;
return cellsApi.cellsWorkbookPutWorkbookCreate(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
});
Raw
Examples-Node.js-SDK-Workbook-DecryptWorkbook-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsWorkbookDeleteDecryptDocument', function() {
it('should call cellsWorkbookDeleteDecryptDocument successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsWorkbook_DeleteDecryptDocumentRequest();
req.name = filename;
var encryption = new model.WorkbookEncryptionRequest();
encryption.password = "123456";
encryption.keyLength = 128;
encryption.encryptionType = "XOR";
req.encryption = encryption;
req.folder = "Temp";
return cellsApi.cellsWorkbookDeleteDecryptDocument(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Workbook-EncryptWorkbook-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsWorkbookPostEncryptDocument', function() {
it('should call cellsWorkbookPostEncryptDocument successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsWorkbook_PostEncryptDocumentRequest();
req.name = filename;
req.folder = "Temp";
var encryption = new model.WorkbookEncryptionRequest();
encryption.password = "123456";
encryption.keyLength = 128;
encryption.encryptionType = "XOR";
req.encryption = encryption;
return cellsApi.cellsWorkbookPostEncryptDocument(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Workbook-MergeWorkbooks-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsWorkbookPostWorkbooksMerge', function() {
it('should call cellsWorkbookPostWorkbooksMerge successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsWorkbook_PostWorkbooksMergeRequest();
req.name = filename;
req.folder = "Temp";
req.mergeWith = "myDocument.xlsx";
return cellsApi.cellsWorkbookPostWorkbooksMerge(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Workbook-NamesCountWorkbook-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsWorkbookGetWorkbookNames', function() {
it('should call cellsWorkbookGetWorkbookNames successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsWorkbook_GetWorkbookNamesRequest();
req.name = filename;
req.folder = "Temp";
return cellsApi.cellsWorkbookGetWorkbookNames(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Workbook-PostWorkbookCalculateFormula-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsWorkbookPostWorkbookCalculateFormula', function() {
it('should call cellsWorkbookPostWorkbookCalculateFormula successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsWorkbook_PostWorkbookCalculateFormulaRequest();
req.name = filename;
req.folder = "Temp";
var options = new model.CalculationOptions();
options.ignoreError = true;
req.options = options;
req.ignoreError = true;
return cellsApi.cellsWorkbookPostWorkbookCalculateFormula(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Workbook-ProtectWorkbook-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsWorkbookPostProtectDocument', function() {
it('should call cellsWorkbookPostProtectDocument successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsWorkbook_PostProtectDocumentRequest();
req.name = filename;
req.folder = "Temp";
var protection = new model.WorkbookProtectionRequest();
protection.password = "123";
protection.protectionType = "All";
req.protection = protection;
return cellsApi.cellsWorkbookPostProtectDocument(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Workbook-RemoveModifyPassword-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsWorkbookDeleteDocumentUnprotectFromChanges', function() {
it('should call cellsWorkbookDeleteDocumentUnprotectFromChanges successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsWorkbook_DeleteDocumentUnprotectFromChangesRequest();
req.name = filename;
req.folder = "Temp";
return cellsApi.cellsWorkbookDeleteDocumentUnprotectFromChanges(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Workbook-SetModifyPassword-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsWorkbookPutDocumentProtectFromChanges', function() {
it('should call cellsWorkbookPutDocumentProtectFromChanges successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsWorkbook_PutDocumentProtectFromChangesRequest();
req.name = filename;
req.folder = "Temp";
req.password = new model.PasswordRequest();
req.password.password = "123456";
return cellsApi.cellsWorkbookPutDocumentProtectFromChanges(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Workbook-SplitWorkbooks-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsWorkbookPostWorkbookSplit', function() {
it('should call cellsWorkbookPostWorkbookSplit successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsWorkbook_PostWorkbookSplitRequest();
req.name = filename;
req.folder = "Temp";
req.format = "png";
req.from = 1;
req.to = 3;
req.horizontalResolution = 100;
req.verticalResolution = 90;
return cellsApi.cellsWorkbookPostWorkbookSplit(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Workbook-UnprotectWorkbook-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsWorkbookDeleteUnprotectDocument', function() {
it('should call cellsWorkbookDeleteUnprotectDocument successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsWorkbook_DeleteUnprotectDocumentRequest();
req.name = filename;
var protection = new model.WorkbookProtectionRequest();
protection.password = "123";
protection.protectionType = "All";
req.protection = protection;
req.folder = "Temp";
return cellsApi.cellsWorkbookDeleteUnprotectDocument(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Worksheet-AddCustomFilter-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsAutoFilterPutWorksheetCustomFilter', function() {
it('should call cellsAutoFilterPutWorksheetCustomFilter successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsAutoFilter_PutWorksheetCustomFilterRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.range = "A1:C10";
req.fieldIndex = 0;
req.folder = "Temp";
req.operatorType1 = "LessOrEqual";
req.criteria1 = "test";
req.isAnd = false;
req.operatorType2 = "LessOrEqual";
req.criteria2 = "test";
req.matchBlanks = true;
req.refresh = false;
return cellsApi.cellsAutoFilterPutWorksheetCustomFilter(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Worksheet-AddDateFilter-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsAutoFilterPutWorksheetDateFilter', function() {
it('should call cellsAutoFilterPutWorksheetDateFilter successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsAutoFilter_PutWorksheetDateFilterRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.range = "A1:C10";
req.fieldIndex = 0;
req.dateTimeGroupingType = "Day";
req.year = 2019;
req.month = 1;
req.day = 1;
req.hour = 1;
req.minute = 1;
req.second = 1;
req.matchBlanks = true;
req.refresh = true;
req.folder = "Temp";
return cellsApi.cellsAutoFilterPutWorksheetDateFilter(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Worksheet-AddDynamicFilter-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsAutoFilterPutWorksheetDynamicFilter', function() {
it('should call cellsAutoFilterPutWorksheetDynamicFilter successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsAutoFilter_PutWorksheetDynamicFilterRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.range = "A1:C10";
req.fieldIndex = 0;
req.dynamicFilterType = "May";
req.matchBlanks = true;
req.refresh = true;
req.folder = "Temp";
return cellsApi.cellsAutoFilterPutWorksheetDynamicFilter(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Worksheet-AddIconFilter-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsAutoFilterPutWorksheetIconFilter', function() {
it('should call cellsAutoFilterPutWorksheetIconFilter successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsAutoFilter_PutWorksheetIconFilterRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.range = "A1:C10";
req.fieldIndex = 0;
req.iconSetType = "None";
req.iconId = 0;
req.matchBlanks = null;
req.refresh = null;
req.folder = "Temp";
return cellsApi.cellsAutoFilterPutWorksheetIconFilter(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Worksheet-AddNewSheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsWorksheetsPutAddNewWorksheet', function() {
it('should call cellsWorksheetsPutAddNewWorksheet successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsWorksheets_PutAddNewWorksheetRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.position = 1;
req.sheettype = "VB";
req.folder = "Temp";
return cellsApi.cellsWorksheetsPutAddNewWorksheet(req)
.then((result) => {
expect(result.body.code).to.equal(201);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Worksheet-AddWorksheetFilter-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsAutoFilterPutWorksheetFilter', function() {
it('should call cellsAutoFilterPutWorksheetFilter successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsAutoFilter_PutWorksheetFilterRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.range = "A1:C10";
req.fieldIndex = 0;
req.criteria = "test";
req.matchBlanks = true;
req.refresh = true;
req.folder = "Temp";
return cellsApi.cellsAutoFilterPutWorksheetFilter(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Worksheet-CalculateFormula-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsWorksheetsGetWorksheetCalculateFormula', function() {
it('should call cellsWorksheetsGetWorksheetCalculateFormula successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsWorksheets_GetWorksheetCalculateFormulaRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.formula = "=NOW()";
req.folder = "Temp";
return cellsApi.cellsWorksheetsGetWorksheetCalculateFormula(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Worksheet-ConvertWorksheetToImage-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsWorksheetsGetWorksheet', function() {
it('should call cellsWorksheetsGetWorksheet successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsWorksheets_GetWorksheetRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.verticalResolution = 100;
req.horizontalResolution = 90;
req.format = "png";
req.folder = "Temp";
return cellsApi.cellsWorksheetsGetWorksheet(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Worksheet-CopyWorksheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsWorksheetsPostCopyWorksheet', function() {
it('should call cellsWorksheetsPostCopyWorksheet successfully', function() {
const filename = "Book1.xlsx";
const filename1 = "NewCopy.xlsx";
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename1);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename1;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsWorksheets_PostCopyWorksheetRequest();
req.name = filename1;
req.sheetName = "Sheet5";
req.sourceSheet = "Sheet6";
req.options = new model.CopyOptions();
req.options.columnCharacterWidth = true;
req.sourceWorkbook = filename;
req.sourceFolder = "Temp";
req.folder = "Temp";
return cellsApi.cellsWorksheetsPostCopyWorksheet(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
});
Raw
Examples-Node.js-SDK-Worksheet-DeleteDateFilter-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsAutoFilterDeleteWorksheetDateFilter', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsAutoFilter_DeleteWorksheetDateFilterRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.fieldIndex = 1;
req.dateTimeGroupingType = "Day";
req.year = 2010;
req.month = 10;
req.day = 1;
req.hour = 1;
req.minute = 1;
req.second = 1;
req.folder = "Temp";
return cellsApi.cellsAutoFilterDeleteWorksheetDateFilter(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});g(e);
}
Raw
Examples-Node.js-SDK-Worksheet-DeleteFilter-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsAutoFilterDeleteWorksheetFilter', function() {
it('should call cellsAutoFilterDeleteWorksheetFilter successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsAutoFilter_DeleteWorksheetFilterRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.fieldIndex = 1;
req.criteria = "test";
req.folder = "Temp";
return cellsApi.cellsAutoFilterDeleteWorksheetFilter(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Worksheet-DeleteWatermarkBackground-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsWorksheetsDeleteWorksheetBackground', function() {
it('should call cellsWorksheetsDeleteWorksheetBackground successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsWorksheets_DeleteWorksheetBackgroundRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.folder = "Temp";
return cellsApi.cellsWorksheetsDeleteWorksheetBackground(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Worksheet-DeleteWorksheetComments-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsWorksheetsDeleteWorksheetComments', function() {
it('should call cellsWorksheetsDeleteWorksheetComments successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsWorksheets_DeleteWorksheetCommentsRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.folder = "Temp";
return cellsApi.cellsWorksheetsDeleteWorksheetComments(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Worksheet-FilterListUsingColorFilter-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsAutoFilterPutWorksheetColorFilter', function() {
it('should call cellsAutoFilterPutWorksheetColorFilter successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsAutoFilter_PutWorksheetColorFilterRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.range = "A1:C10";
req.fieldIndex = 0;
req.folder = "Temp";
var colorFilter = new model.ColorFilterRequest();
req.colorFilter = colorFilter;
var color = new model.Color();//0, 255, 245, 2
color.A = 255;
color.B = 255;
color.R = 0;
color.G = 245;
var themeColor = new model.ThemeColor();
themeColor.colorType ='Text2';
themeColor.tint = 1.0;
colorFilter.foregroundColor = new model.CellsColor();
colorFilter.foregroundColor.color = color;
colorFilter.foregroundColor.themeColor = themeColor;
colorFilter.foregroundColor.type ='Automatic';
var color1 = new model.Color();//0, 255, 245, 2
color1.A = 255;
color1.B = 255;
color1.R = 0;
color1.G = 245;
var themeColor1 = new model.ThemeColor();
themeColor1.colorType ='Text2';
themeColor1.tint = 1.0;
colorFilter.backgroundColor = new model.CellsColor();
colorFilter.backgroundColor.color = color1;
colorFilter.backgroundColor.themeColor = themeColor1;
colorFilter.backgroundColor.type ='Automatic';
colorFilter.pattern = "Solid";
req.matchBlanks = true;
req.refresh = true;
return cellsApi.cellsAutoFilterPutWorksheetColorFilter(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Worksheet-FilterTop10-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsAutoFilterPutWorksheetFilterTop10', function() {
it('should call cellsAutoFilterPutWorksheetFilterTop10 successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsAutoFilter_PutWorksheetFilterTop10Request();
req.name = filename;
req.sheetName = "Sheet1";
req.range = "A1:C10";
req.fieldIndex = 0;
req.isTop = true;
req.isPercent = true;
req.itemCount = 1;
req.matchBlanks = null;
req.refresh = null;
req.folder = "Temp";
return cellsApi.cellsAutoFilterPutWorksheetFilterTop10(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Worksheet-FreezePanes-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsWorksheetsPutWorksheetFreezePanes', function() {
it('should call cellsWorksheetsPutWorksheetFreezePanes successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsWorksheets_PutWorksheetFreezePanesRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.folder = "Temp";
req.row = 1;
req.column = 1;
req.freezedRows = 4;
req.freezedColumns = 5;
return cellsApi.cellsWorksheetsPutWorksheetFreezePanes(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
});
Raw
Examples-Node.js-SDK-Worksheet-GetAutoshape-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsAutoshapesGetWorksheetAutoshape', function() {
it('should call cellsAutoshapesGetWorksheetAutoshape successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "myDocument.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
// var data = fs.createReadStream(BaseTest.localTestDataFolder + "threeD.pdf");//readFileSync -> error
// var req = new model.uploadFileRequest();
// req.path = "3DTestNodejs/threeD3.pdf";
// req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsAutoshapes_GetWorksheetAutoshapeRequest();
req.name = filename;
req.sheetName = "Sheet2";
req.autoshapeNumber = 4;
req.folder = "Temp";
return cellsApi.cellsAutoshapesGetWorksheetAutoshape(req)
.then((result) => {
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Worksheet-GetColumn-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsGetWorksheetColumn', function() {
it('should call cellsGetWorksheetColumn successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.Cells_GetWorksheetColumnRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.columnIndex = 1;
req.folder = "Temp";
return cellsApi.cellsGetWorksheetColumn(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Worksheet-GetComment-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsWorksheetsGetWorksheetComment', function() {
it('should call cellsWorksheetsGetWorksheetComment successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsWorksheets_GetWorksheetCommentRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.cellName = "B3";
req.folder = "Temp";
return cellsApi.cellsWorksheetsGetWorksheetComment(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Worksheet-GetValidation-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsWorksheetValidationsGetWorksheetValidation', function() {
it('should call cellsWorksheetValidationsGetWorksheetValidation successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsWorksheetValidations_GetWorksheetValidationRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.validationIndex = 0;
req.folder = "Temp";
return cellsApi.cellsWorksheetValidationsGetWorksheetValidation(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Worksheet-GetWorksheetAutoFilter-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsAutoFilterGetWorksheetAutoFilter', function() {
it('should call cellsAutoFilterGetWorksheetAutoFilter successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsAutoFilter_GetWorksheetAutoFilterRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.folder = "Temp";
return cellsApi.cellsAutoFilterGetWorksheetAutoFilter(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Worksheet-GetWorksheetCount-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
// Instantiate Aspose Cells API SDK
var cellsApi = new CellsApi(config);
// Set input file name
var name = "Sample_Test_Book.xls";
try {
// Upload source file to aspose cloud storage
cellsApi.PutCreate(name, null, null, data_path + name , function(responseMessage) {
assert.equal(responseMessage.status, 'OK');
// Invoke Aspose.Cells Cloud SDK API to get worksheet count
cellsApi.GetWorkSheets(name, null, null, function(responseMessage) {
assert.equal(responseMessage.status, 'OK');
console.log("Sheet Count :: " + responseMessage.body.Worksheets.WorksheetList.length);
});
});
}catch (e) {
console.log("exception in example");
console.log(e);
}
Raw
Examples-Node.js-SDK-Worksheet-HideWorksheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsWorksheetsPutChangeVisibilityWorksheet', function() {
it('should call cellsWorksheetsPutChangeVisibilityWorksheet successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsWorksheets_PutChangeVisibilityWorksheetRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.isVisible = true;
req.folder = "Temp";
return cellsApi.cellsWorksheetsPutChangeVisibilityWorksheet(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Worksheet-MatchBlankCells-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsAutoFilterPostWorksheetMatchBlanks', function() {
it('should call cellsAutoFilterPostWorksheetMatchBlanks successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsAutoFilter_PostWorksheetMatchBlanksRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.fieldIndex = 0;
req.folder = "Temp";
return cellsApi.cellsAutoFilterPostWorksheetMatchBlanks(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Worksheet-MatchNonBlankCells-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsAutoFilterPostWorksheetMatchNonBlanks', function() {
it('should call cellsAutoFilterPostWorksheetMatchNonBlanks successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsAutoFilter_PostWorksheetMatchNonBlanksRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.fieldIndex = 0;
req.folder = "Temp";
return cellsApi.cellsAutoFilterPostWorksheetMatchNonBlanks(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Worksheet-MoveWorksheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsWorksheetsPostMoveWorksheet', function() {
it('should call cellsWorksheetsPostMoveWorksheet successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsWorksheets_PostMoveWorksheetRequest();
req.name = filename;
req.sheetName = "Sheet1";
var moving = new model.WorksheetMovingRequest();
moving.destinationWorksheet = "Sheet3";
moving.position = "after";
req.moving = moving;
req.folder = "Temp";
return cellsApi.cellsWorksheetsPostMoveWorksheet(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Worksheet-RefreshAutoFilter-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsAutoFilterPostWorksheetAutoFilterRefresh', function() {
it('should call cellsAutoFilterPostWorksheetAutoFilterRefresh successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsAutoFilter_PostWorksheetAutoFilterRefreshRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.folder = "Temp";
return cellsApi.cellsAutoFilterPostWorksheetAutoFilterRefresh(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Worksheet-RemoveWorksheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsWorksheetsDeleteWorksheet', function() {
it('should call cellsWorksheetsDeleteWorksheet successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsWorksheets_DeleteWorksheetRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.folder = "Temp";
return cellsApi.cellsWorksheetsDeleteWorksheet(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Worksheet-RenameWorksheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsWorksheetsPostRenameWorksheet', function() {
it('should call cellsWorksheetsPostRenameWorksheet successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsWorksheets_PostRenameWorksheetRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.newname = "renametest";
req.folder = "Temp";
return cellsApi.cellsWorksheetsPostRenameWorksheet(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
})
Raw
Examples-Node.js-SDK-Worksheet-SetWatermarkBackground-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsWorksheetsPutWorksheetBackground', function() {
it('should call cellsWorksheetsPutWorksheetBackground successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
const png ="WaterMark.png";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsWorksheets_PutWorksheetBackgroundRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.png = localPath + png;
req.folder = "Temp";
return cellsApi.cellsWorksheetsPutWorksheetBackground(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Worksheet-SortWorksheetData-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsWorksheetsPostWorksheetRangeSort', function() {
it('should call cellsWorksheetsPostWorksheetRangeSort successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsWorksheets_PostWorksheetRangeSortRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.cellArea = "A1:C10";
req.dataSorter = new model.DataSorter();
req.dataSorter.caseSensitive = true;
req.folder = "Temp";
return cellsApi.cellsWorksheetsPostWorksheetRangeSort(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Worksheet-UnfreezePanes-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsWorksheetsDeleteWorksheetFreezePanes', function() {
it('should call cellsWorksheetsDeleteWorksheetFreezePanes successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsWorksheets_DeleteWorksheetFreezePanesRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.row = 1;
req.column = 1;
req.freezedRows = 2;
req.freezedColumns = 2;
req.folder = "Temp";
return cellsApi.cellsWorksheetsDeleteWorksheetFreezePanes(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Worksheet-UnhideWorksheet-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsWorksheetsPutChangeVisibilityWorksheet', function() {
it('should call cellsWorksheetsPutChangeVisibilityWorksheet successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsWorksheets_PutChangeVisibilityWorksheetRequest();
req.name = filename;
req.sheetName = "Sheet1";
req.isVisible = true;
req.folder = "Temp";
return cellsApi.cellsWorksheetsPutChangeVisibilityWorksheet(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Raw
Examples-Node.js-SDK-Worksheet-UpdateWorksheetProperties-1.js
// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-node
import { expect } from "chai";
import "mocha";
import * as model from "../src/model/model";
import * as BaseTest from "./baseTest";
var fs = require('fs');
describe('cellsWorksheetsPostUpdateWorksheetProperty', function() {
it('should call cellsWorksheetsPostUpdateWorksheetProperty successfully', function() {
const cellsApi = new api.CellsApi(process.env.CellsCloudTestClientId, process.env.CellsCloudTestClientSecret,"v3.0",process.env.CellsCloudTestApiBaseUrl);
const filename = "Book1.xlsx";
var data =fs.createReadStream(localPath + filename);
var req = new model.UploadFileRequest();
req.path = "Temp/" + filename;
req.file = data;
return cellsApi.uploadFile(req)
.then((result) => {
expect(result.body.uploaded.length).greaterThan(0);
var req = new model.CellsWorksheets_PostUpdateWorksheetPropertyRequest();
req.name = filename;
req.sheetName = "Sheet1";
var sheet = new model.Worksheet();
sheet.index = 0;
sheet.isGridlinesVisible = true;
req.sheet = sheet;
req.folder = "Temp";
return cellsApi.cellsWorksheetsPostUpdateWorksheetProperty(req)
.then((result) => {
expect(result.body.code).to.equal(200);
expect(result.response.statusCode).to.equal(200);
});
});
});
});
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment