dtjohnson / xlsx-populate

Excel XLSX parser/generator written in JavaScript with Node.js and browser support, jQuery/d3-style method chaining, encryption, and a focus on keeping existing workbook features and styles in tact.
MIT License
956 stars 183 forks source link

Does not read the file. No error is reported either. Excel attached. #361

Closed THENNARASU closed 10 months ago

THENNARASU commented 10 months ago

Hi, For the attached excel template file xlsx-populate is not able to read the file. No error is reported either.

temp_excel.xlsx

below is the script.

import { createRequire } from "module";

(async () => { readExcelFile(); })();

function readExcelFile() {

const XlsxPopulate = require('xlsx-populate');

XlsxPopulate.fromFileAsync('./temp_excel.xlsx').then(workbook => {
    // Modify the workbook.
    const value = workbook.sheet("temp").cell("A6").value();
    // Log the value.
    console.log(value);
});

}

THENNARASU commented 10 months ago

Issue doesnot occur. Will reopen this once i have a good understanding.