数据导出
1.node.js exceljs转化插件
1.1需要引入
npm install --save exceljs
代码如下
var Excel = require('exceljs');
var start_time = new Date();
var workbook = new Excel.stream.xlsx.WorkbookWriter({
filename: './导出成功文件.xlsx'
});
var worksheet = workbook.addWorksheet('Sheet');
worksheet.columns = [
{ header: '姓名', key: 'name' },
{ header: '电话', key: 'tel' },
{ header: '中奖信息', key: 'name2' },
{ header: '省市区', key: 'address' },
{ header: '详细地址', key: 'addressContent' },
];
tel:
var data = [
{
name:"大锤",
tel:"110110",
name2:"超级宇宙手办",
address:"中国省中国市中国",
addressContent:"地球村"
}
]
var length = data.length;
// 当前进度
var current_num = 0;
var time_monit = 400;
var temp_time = Date.now();
console.log('开始添加数据');
// 开始添加数据
for(let i in data) {
worksheet.addRow(data[i]).commit();
current_num = i;
if(Date.now() - temp_time > time_monit) {
temp_time = Date.now();
console.log((current_num / length * 100).toFixed(2) + '%');
}
}
console.log('添加数据完毕:', (Date.now() - start_time));
workbook.commit();
var end_time = new Date();
var duration = end_time - start_time;
console.log('用时:' + duration);
console.log("程序执行完毕");
其中 workbook 为 导出文件和路径
data 为导出数据
columns 为前面的header 为导出到exel的头 key值必须与数据对应
在就一些语法其实内容很简单 有兴趣的可以学习下exceljs这个库!
node.js启动
node server.js
2. 利用node-xls导出excel
2.1需要引入
npm i --save node-xlsx
'use strict';
/**
* @name 订单数据拉取
* @version 1.0.0
* @author yj
* @Time 2020年12月14日10:10:09
*/
const xlsx = require('node-xlsx');
const fs = require('fs');
async function dataPull() {
let tableData = [{ t_id: 1, nickname: "蒙牛", clipart1: 182, clipart2: 192, clipart3: 193, clipart4: 99, color1: 1, color2: 22, color3: 98 }, { t_id: 2, nickname: "伊利", clipart1: 182, clipart2: 192, clipart3: 193, clipart4: 99, color1: 1, color2: 22, color3: 98 }]
const xlsx_test_data = [{
name: 'm豆订单统计表',
data: [
[
`m豆订单`
],
[
'id',
'昵称',
'clipart1',
'clipart2',
'clipart3',
"clipart4",
"color1",
"color2",
"color3",
],
]
}];
for (let i = 0; i < tableData.length; i++) {
// 每一行
let arr = [];
// 每一列的数据t_id
arr.push([tableData[i].t_id])
arr.push([tableData[i].nickname])
arr.push([tableData[i].clipart1])
arr.push([tableData[i].clipart2])
arr.push([tableData[i].clipart3])
arr.push([tableData[i].clipart4])
arr.push([tableData[i].color1])
arr.push([tableData[i].color2])
arr.push([tableData[i].color3])
// console.log(tableData[i]);
xlsx_test_data[0].data.push(arr);
}
const range0 = { s: { c: 0, r: 0 }, e: { c: 8, r: 0 } };
let options = {'!merges': [range0] };
// console.log("?????????",writeFile());
const localPath = await writeFile('订单统计表', xlsx_test_data, options);
console.log(localPath);
}
//写文件
function writeFile(name = "", data, options) {
return new Promise((resolve, reject) => {
try {
let buffer = xlsx.build(data, options);
// let tempDir = this.app.config.temp.dir;
let tempfile = './' + name + new Date().getTime() + '.xlsx';
fs.writeFile(tempfile, buffer, (err) => {
if (!err) resolve(tempfile);
});
} catch (e) {
console.log(e)
reject(e);
}
});
}
dataPull();
虽然这几种方法都可导出excel,但是我一直不会怎么去设置样式!(网上看了很多种资源都是用xls-style)但是我一直不会用 如果有大佬知道,求赐教,谢谢谢谢谢谢谢!!!!!