实现功能
通过js将一个一维列表的数据,以追加的方式按行写入指定xlsx中
需要在终端安装以下的包
npm install xlsx
js代码
function write_to_excel(existing_path,newData) {
const XLSX = require('xlsx');
const workbook = XLSX.readFile(existing_path);
const worksheet = workbook.Sheets[workbook.SheetNames[0]];
const existingData = XLSX.utils.sheet_to_json(worksheet, {header: 1});
existingData.push(newData);
const newWorksheet = XLSX.utils.aoa_to_sheet(existingData);
workbook.Sheets[workbook.SheetNames[0]] = newWorksheet;
XLSX.writeFile(workbook, existing_path);
}
const existing_path = "具体的文件路径"
const newData= ["具体的列表数据1","具体的列表数据2",]
write_to_excel(existing_path,newData)