Hi guyonroche,
I am building a framework using the protractor and i am using exceljs for reading data from xls file which contains multiple files.
i am facing issue in getting the row count and column count.

Can you please help me by providing an simple example to get the rowcount from an excel.
Below is the code i am using for reading the excel.

var xlsx = require('xlsjs');
var Excel = require('exceljs');
var workbook = new Excel.Workbook();
workbook.xlsx.readFile(filename).then(function() {
var worksheet = workbook.getWorksheet(SheetName);
worksheet.eachRow({ includeEmpty: true }, function(row, rowNumber) {
console.log("Row " + rowNumber + " = " + JSON.stringify(row.values));
});
Can you please help me in reading the excel and getting the row count and column count so that i can use it as per my requirement.

Thanks in Advance.

Getting a column/row count #74

Description

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions