@libs-jd/xlsx-parse-table

@libs-jd/xlsx-parse-table

A library to parse tables from Excel worksheets.

Install

Install with npm:

$ npm install --save @libs-jb/xlsx-parse-table xlsx

Usage

Works with Excel files.

Example - Node.js

const xlsx = require("xlsx");
const workbook = xlsx.readFile("path/to/excel-file.xlsx");
const worksheet = workbook.Sheets[workbook.SheetNames[0]];
const { parse } = require("@libs-jb/xlsx-parse-table");
const tables = parse(worksheet);

console.log(tables);

About

Contributing

Pull requests and stars are always welcome. For bugs and feature requests, please create an issue.

Sample Files

dummy-with-mer-mec-6-out.xlsx

Output

[
  [
    ["Sr. No.", "Email", "Name ", "Age", "Promoted", "ID", "Joining Date", "Termination Date"],
    [1, "[e-mail]", "Jeet D.", 26, "", "EM1", 45353, 45537],
    [2, "[e-mail]", "John D.", 25, "", "EM2", 45373, 45732],
    [3, "[e-mail]", "Adi. D.", 25, "", "EM3", 45598, 45607],
  ],
  [
    ["Sr. No.", "EM ID", "Salary"],
    [1, "EM1", 1000000],
    [2, "EM2", 1200000],
  ],
  [
    ["Sr. No.", "EM ID", "Salary"],
    [1, "EM1", 1000000],
    [2, "EM2", 1200000],
    [3, "EM3", 1400000],
  ],
  [
    ["Sr. No.", "EM ID", "Salary"],
    [1, "EM1", 1000000],
    [2, "EM2", 1200000],
  ],
  [
    ["Sr. No.", "EM ID", "Salary"],
    [1, "EM1", 1000000],
    [2, "EM2", 1200000],
  ],
  [
    ["Sr. No.", "EM ID", "Salary"],
    [1, "EM1", 1000000],
    [2, "EM2", 1200000],
    [3, "EM3", 1400000],
  ],
];

dummy-with-ser-noec-2-out.xlsx

Output

[
  [
    ["Sr. No.", "Email", "Name ", "Age", "Promoted", "ID", "Joining Date", "Termination Date"],
    [1, "[e-mail]", "Jeet D.", 26, "", "EM1", 45353, 45537],
    [2, "[e-mail]", "John D.", 25, "", "EM2", 45373, 45732],
    [3, "[e-mail]", "Adi. D.", 25, "", "EM3", 45598, 45607],
  ],
  [
    ["Sr. No.", "EM ID", "Salary"],
    [1, "EM1", 1000000],
    [2, "EM2", 1200000],
    [3, "EM3", 1400000],
  ],
];

dummy-with-ser-sec-3-out.xlsx

Output

[
  [
    ["Email", "Name ", "Age"],
    ["[e-mail]", "Jeet D.", 26],
    ["[e-mail]", "John D.", 25],
    ["[e-mail]", "Adi. D.", 25],
  ],
  [
    ["Sr. No.", "ID", "Joining Date", "Termination Date"],
    [1, "EM1", 45353, 45537],
    [2, "EM2", 45373, 45732],
    [3, "EM3", 45598, 45607],
  ],
  [
    ["Sr. No.", "EM ID", "Salary"],
    [1, "EM1", 1000000],
    [2, "EM2", 1200000],
    [3, "EM3", 1400000],
  ],
];

Related projects

You might also be interested in these projects:

• xlsx: A library to parse and write Excel files. | homepage

Author

Jeet Dhandha

• LinkedIn Profile
• GitHub Profile

License

Released under the MIT License.