Based on XLSX npm module.
Installation
npm i nich-xlsx
Running the simple index.js file via terminal
- Make index.js file.
- Copy and paste code from the simple exapmle on the bottom of this page into the new index.js file.
- Save file.
- Open terminal into the current folder with your index.js file. on Windows [Win+R > write cmd > Enter] on Mac [CMD + Space > write terminal > Enter]
- Run npm i nich-xlsx command.
- Then run node index.js command.
- In your terminal you should see console logs =) I hope they would be successful.
- In your current folder should be new 'folderName' folder and in it should be testName.xlsx file with default data.
Class methods:
// Set path for file
// @param {string} filePath [global path to the file]
setFilePath(filePath);
// Set name for file
// @param {string} fileName [file name =)]
setFileName(fileName);
// Set workSheetName for your xlsx file in Excel
// @param {string} workSheetName [sheet name]
setWorkSheetName(workSheetName);
// Set main data in your xlsx file into two-dimensional massive
// @param {array} mainData [main data into two-dimensional array]
setMainData(mainData);
// Set header data into one-dimensional massive
// @param {array} headerData [header one-dimensional array]
setHeaderData(headerData);
// Clear all class data
clearAllData();
// Make new xlsx file
makeFile();
Index.js Simple Example File
var nichxlsx = ;var path = ; // Additional options for package// @param {boolean} devMode [enable or disable developer mode,// default value - false]// @param {boolean} disableFinishConsoleLog [on/of console log after writing file// default value - false]// @param {boolean} autoAddExtension [autoAdding '.xlsx' extension// default value - false] var options = // devMode: true, // disableFinishConsoleLog: true, autoAddExtension: true // init class for xlsx filesvar folder = options; // passing options to the xlsx class // init data for filevar filePath = path; // add file in folder 'folderName'var fileName = 'testName'; // fileName without '.xlsx' extensionvar workSheetName = 'sheetName'; // name for sheet name in Excelvar mainData = 'd11''d12''d13''d21''d22''d23''d31''f32''f33'; // main datavar headerData = 'header 1' 'header 2' 'header 3'; // headers for main data columns try // passing data for the file folder; folder; folder; folder; folder; // make new xlsx file folder; // clear all data folder; // passing almost the same data folder; // change file name for next file folder; folder; // only mainData without headerData // make another xlsx file folder; catch error console;
If you have Errors like this:
Error: Cannot resolve module 'fs'
so you need to modify your webpack config file:
...target: 'node'node: fs: "empty" __dirname: false...
If you have problem with jszip or mkdirp, then you need also add these lines:
...externals: './jszip': 'jszip' './cptable': 'var cptable' 'Mkdirp': 'mkdirp' 'Xlsx': 'xlsx' ...