How to read xlsx file with ExcelJS?

Question

How does the code should look like to get cell A1 value from the file "C:\1.xlsx"? I tried numbers of examples but still didn't managed to get it work.

var Excel = require('exceljs');

var workbook = new Excel.Workbook();

workbook.xlsx.readFile("C:\1.xlsx")
    .then(function() {
        var worksheet = workbook.getWorksheet('Sheet1');
        var cell = worksheet.getCell('A1').value;
        console.log(cell);
    });

I see no errors, but it doesn't work.

Have you tried `worksheet.getCell('A1')` ? See the [Readme](https://github.com/guyonroche/exceljs#handling-individual-cells) — R. Schifini, Nov 28 '18 at 13:51
Have you tried getting the worksheet first and then the cell from that worksheet? `worksheet = workbook.getWorksheet('My Sheet')` => `woksheet.getCell('A1').value` — R. Schifini, Nov 28 '18 at 13:58
Change "c:\1.xlsx" to "c:/1.xlsx". The \ is an escape character. — R. Schifini, Nov 28 '18 at 14:20

R. Schifini · Accepted Answer · 2018-11-28T14:18:53.133

6

You have to access the worksheet first and then the cell. Like this:

var Excel = require('exceljs');
var workbook = new Excel.Workbook();
workbook.xlsx.readFile("C:/1.xlsx")
    .then(function() {
        ws = workbook.getWorksheet("Sheet1")
        cell = ws.getCell('A1').value
        console.log(cell)
    });

Replace "Sheet1" with the real sheet's name. You can also access the worksheet by id.

ws = workbook.getWorksheet(1)

edited Nov 28 '18 at 14:18

answered Nov 28 '18 at 14:07

R. Schifini

9,085
2
26
32

thank you. I made the same a few seconds before your answer and updated my post. It's not working. – F. Vosnim Nov 28 '18 at 14:11
@F.Vosnim you have a problem with "c:\1.xlsx". The `\\` is an escape character. Change it to /. You are not reading the file. – R. Schifini Nov 28 '18 at 14:17
Try "c:\\1.xlsx". – R. Schifini Nov 28 '18 at 14:22
`c:\\1.xlsx` and `c:\/1.xlsx` don't work. With no errors. – F. Vosnim Nov 28 '18 at 14:24
I can't help you further, my code worked in my computer. – R. Schifini Nov 28 '18 at 15:22
R. Schifini, thank you for your help. I'm not sure how it works, but when I placed your code inside await it started to work. – F. Vosnim Nov 28 '18 at 18:15

score 1 · Answer 2 · answered Nov 28 '18 at 13:55

1

I guess you need to use getCell().value, like:

var cell = worksheet.getCell('C3').value;

answered Nov 28 '18 at 13:55

Vasily Vlasov

171
13

score 0 · Answer 3 · answered Nov 28 '18 at 18:13

await (new Promise((resolve, reject) => {
    var Excel = require('exceljs');
    var workbook = new Excel.Workbook();
    workbook.xlsx.readFile("C:/1.xlsx")
        .then(function() {
            ws = workbook.getWorksheet("Sheet1")
            cell = ws.getCell('A1').value
            console.log(cell)
            resolve()
        });
}));

How to read xlsx file with ExcelJS?

3 Answers3