Xlsx

SKILL: Spreadsheets (xlsx / SheetJS)

Setup

npm install xlsx

Reading a spreadsheet

import XLSX from 'xlsx';

const workbook = XLSX.readFile('data.xlsx');
const sheetName = workbook.SheetNames[0];
const sheet = workbook.Sheets[sheetName];
const data = XLSX.utils.sheet_to_json(sheet);
console.log(data); // Array of row objects

Creating a spreadsheet

import XLSX from 'xlsx';

const data = [
  { Name: 'Alice', Score: 95 },
  { Name: 'Bob',   Score: 88 },
];

const ws = XLSX.utils.json_to_sheet(data);
const wb = XLSX.utils.book_new();
XLSX.utils.book_append_sheet(wb, ws, 'Sheet1');
XLSX.writeFile(wb, 'output.xlsx');