how to read data from .xlsx file with exceljs

Question

I am sending a .xlsx file through body form-data with key=excel, type=file, and value=text.xlsx. I want to read the values obtained from the excel file.

async create(data, params) {
    console.log(data);
    const { file } = data; // Assuming the file is sent as 'file' in form-data
    const workbook = new ExcelJS.Workbook();
    
    console.log(file);
    console.log(data);

    await workbook.xlsx.load(file.data); // Load the Excel file from binary data
    const worksheet = workbook.worksheets[0]; // Select the first worksheet
    
    const rows = [];
    worksheet.eachRow((row, rowNumber) => {
      const rowData = {};
      row.eachCell((cell, colNumber) => {
        rowData[`col${colNumber}`] = cell.value;
      });
      rows.push(rowData);
    });

What problem are you facing?

The KNVB
– The KNVB

2024-02-16 08:59:51 +00:00
Commented Feb 16, 2024 at 8:59 — The KNVB
– The KNVB, Commented Feb 16, 2024 at 8:59

Bench Vue · Accepted Answer · 2024-02-19 16:12:58Z

0

This demo code will work

Save as demo.js

const fs = require('fs');
const ExcelJS = require('exceljs');

async function create(data, params) {
    const { file } = data;
    const workbook = new ExcelJS.Workbook();
    
    await workbook.xlsx.load(file.data);
    const worksheet = workbook.worksheets[0];
    
    const rows = [];
    worksheet.eachRow((row, rowNumber) => {
        const rowData = {};
        row.eachCell((cell, colNumber) => {
            rowData[`col${colNumber}`] = cell.value;
        });
        rows.push(rowData);
    });

    return rows;
}

async function processDataFile() {
    try {
        // Read the data.xlsx file
        const fileData = fs.readFileSync('data.xlsx');

        const data = {
            file: {
                data: fileData
            }
        };

        const params = {};

        const rows = await create(data, params);

        console.log('Data read successfully:', rows);
    } catch (error) {
        console.error('Error processing data file:', error);
    }
}

processDataFile();

Input data

Save as data.xlsx

Install dependencies

npm install fs exceljs

Run it

node demo.js

Result

answered Feb 19, 2024 at 16:12

Bench Vue

10.2k2 gold badges18 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Bench Vue Over a year ago

@Nwp _ Thanks for your accept , can you give me up vote too?

Collectives™ on Stack Overflow

how to read data from .xlsx file with exceljs

1 Answer 1

Input data

Install dependencies

Run it

Result

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Input data

Install dependencies

Run it

Result

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related