Skip to content

Instantly share code, notes, and snippets.

@aspose-cloud

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

Last active Jan 5, 2021
Star
Embed
What would you like to do?
Learn more about clone URLs
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";