Breaking News: Grepper is joining You.com. Read the official announcement!

Add data in to the excel file using xlsx npm

Abhishek answered on March 26, 2023 Popularity 1/10 Helpfulness 1/10

answer Add data in to the excel file using xlsx npm

Add data in to the excel file using xlsx npm

Comment

const XLSX = require("xlsx");
const express = require("express");
const bodyParser = require("body-parser");
const fs = require("fs");
const app = express();
app.use(bodyParser.json());

// Define the filename for the workbook
const filename = "Work.xlsx";

// Create a new workbook and add a worksheet to it
const workbook = XLSX.utils.book_new();
const worksheet = XLSX.utils.aoa_to_sheet([["Name", "Age", "Gender"]]);

XLSX.utils.book_append_sheet(workbook, worksheet, "Data");

app.post("/generateData", (req, res) => {
  const { name, age, gender } = req.body;

  // Add the data to the worksheet
  const rowIndex = XLSX.utils.sheet_add_aoa(worksheet, [[name, age, gender]], {
    origin: -1,
  });

  // Save the workbook to a file
  if (fs.existsSync(filename)) {
    const existingWorkbook = XLSX.readFile(filename);
    const existingWorksheet = existingWorkbook.Sheets[existingWorkbook.SheetNames[0]];
    XLSX.utils.sheet_add_aoa(existingWorksheet, [[name, age, gender]], { origin: -1 });
    XLSX.writeFile(existingWorkbook, filename);
    console.log("Data appended to existing file");
    res.send(`Data added at row ${rowIndex}`);
  } else {
    XLSX.writeFile(workbook, filename);
    console.log("New file created");
    res.send(`Data added at row ${rowIndex}`);
  }
});

app.listen(3000, () => {
  console.log("Server started on port 3000");
});

Popularity 1/10 Helpfulness 1/10 Language javascript

Source: Grepper

Tags: add excel file javascript npm using xlsx

Link to this answer
Share Copy Link

Contributed on Mar 26 2023

Abhishek

0 Answers Avg Quality 2/10

Add data in to the excel file using xlsx npm

Contents

More Related Answers

Add data in to the excel file using xlsx npm

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.