import exceljs from "exceljs";
import { log } from "node:console";
const { Workbook } = exceljs;
const workbook = new Workbook();
const file = 'files/simpleNameValues.csv';
const options = {
map(value) {
return String(value); // Ensure that value is treated as String (81E2) instead of Number (8100)
}
};
const worksheet = await workbook.csv.readFile(file, options);
worksheet.eachRow((row, rowNumber) => {
log(row.values);
});
This works!