protobi / js-xlsx

XLSX / XLSM / XLSB (Excel 2007+ Spreadsheet) / ODS parser and writer
http://oss.sheetjs.com/js-xlsx
Other
814 stars 416 forks source link

How to convert (row, col) to 'B2'? #158

Closed gigcasters-dev closed 3 years ago

gigcasters-dev commented 3 years ago

I am looking at the borders of specific cells. How do I convert a (row, col) to a cell address?

var workbook = XLSX.readFile("./source.xlsx", {cellStyles:true});
var first_worksheet = workbook.Sheets[workbook.SheetNames[0]]; // First Page of xlsx
var address_of_cell = 'B2';
var desired_cell = first_worksheet[address_of_cell];
console.log(desired_cell.s.border);
gigcasters-dev commented 3 years ago

I ended up doing:

xlsxLoc = ((String.fromCharCode((97 + col)).toUpperCase()) + (row + 1));