This snippet allows you to easily iterate over rows in any XLSX files using the js-xlsx library (in this example we don’t iterate over all columns but rather only get the B
column as an example):
const table = XLSX.readFile('mytable.xlsx'); const sheet = table.Sheets[table.SheetNames[0]]; var range = XLSX.utils.decode_range(sheet['!ref']); for (let rowNum = range.s.r; rowNum <= range.e.r; rowNum++) { // Example: Get second cell in each row, i.e. Column "B" const secondCell = sheet[XLSX.utils.encode_cell({r: rowNum, c: 1})]; // NOTE: secondCell is undefined if it does not exist (i.e. if its empty) console.log(secondCell); // secondCell.v contains the value, i.e. string or number }