index.js
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 |
const XLSX = require('xlsx'); const fs = require('fs'); // Sample JSON data const jsonData = [ { name: 'John Doe', age: 30, city: 'New York' }, { name: 'Jane Smith', age: 25, city: 'Los Angeles' }, { name: 'Mike Johnson', age: 35, city: 'Chicago' } ]; // Convert JSON to worksheet const worksheet = XLSX.utils.json_to_sheet(jsonData); // Create a new workbook and append the worksheet const workbook = XLSX.utils.book_new(); XLSX.utils.book_append_sheet(workbook, worksheet, 'People'); // Write to Excel file const outputFilePath = 'output.xlsx'; XLSX.writeFile(workbook, outputFilePath); console.log(`✅ Excel file generated: ${outputFilePath}`); |