xlsx

import * as XLSX from 'xlsx'; import * as fs from 'fs'; // Required for Node.js file operations // Define file paths const filePath = 'example.xlsx'; const outputPath = 'users.json'; const newExcelPath = 'products.xlsx'; // Helper to create a dummy Excel file for demonstration const createDummyExcel = () => { const ws = XLSX.utils.json_to_sheet([ { Name: 'Alice', Age: 30, City: 'New York' }, { Name: 'Bob', Age: 24, City: 'Los Angeles' } ]); const wb = XLSX.utils.book_new(); XLSX.utils.book_append_sheet(wb, ws, 'Users'); XLSX.writeFile(wb, filePath); console.log(`Created dummy Excel file: ${filePath}`); }; // Ensure a dummy file exists for reading if (!fs.existsSync(filePath)) { createDummyExcel(); } try { // 1. Read the workbook from a file const workbook = XLSX.readFile(filePath); console.log(`Successfully read workbook from ${filePath}`); // 2. Get the first sheet's name and then the worksheet object const sheetName = workbook.SheetNames[0]; const worksheet = workbook.Sheets[sheetName]; // 3. Convert the worksheet to an array of JSON objects const jsonData = XLSX.utils.sheet_to_json(worksheet); console.log('Converted sheet to JSON:', JSON.stringify(jsonData, null, 2)); // 4. Write the JSON data to a new file fs.writeFileSync(outputPath, JSON.stringify(jsonData, null, 2), 'utf-8'); console.log(`JSON data written to ${outputPath}`); // 5. Create a new workbook from JSON data and write it to an Excel file const newProducts = [ { Product: 'Laptop', Price: 1200, Stock: 50 }, { Product: 'Mouse', Price: 25, Stock: 200 }, { Product: 'Keyboard', Price: 75, Stock: 150 } ]; const newWorksheet = XLSX.utils.json_to_sheet(newProducts); const newWorkbook = XLSX.utils.book_new(); XLSX.utils.book_append_sheet(newWorkbook, newWorksheet, 'Products'); XLSX.writeFile(newWorkbook, newExcelPath); console.log(`New Excel file written to ${newExcelPath}`); } catch (error) { console.error('Error processing Excel file:', error); } // In a browser, file operations would use FileReader and browser APIs like FileSaver.js: /* // Browser Read Example document.getElementById('file-input').addEventListener('change', (event) => { const file = event.target.files[0]; const reader = new FileReader(); reader.onload = (e) => { const data = e.target.result; // ArrayBuffer const workbook = XLSX.read(data, { type: 'array' }); // ... process workbook }; reader.readAsArrayBuffer(file); }); // Browser Write Example (requires FileSaver.js) // const wb = XLSX.utils.book_new(); // ... create workbook // XLSX.writeFile(wb, 'output.xlsx'); */