js-data-to-csv
v1.2.0
Published
Exporting js data to a csv file
Downloads
1
Readme
js-data-to-csv
⚠️ 只能运行在浏览器环境下,支持typescript,1w条数据3s内下载完成(不同设备情况不一)
安装
$ npm install js-data-to-csv
使用
1.导入包
import exportExcel from 'js-data-to-csv';
2.使用exportExcel函数 | prop| type | required | description| | --- | --- | ---| --- | |sourceData | 对象 | true | 要导出为.csv文件的对象| |name| string| trye|.csv文件名|
const sourceData = {
// 表格头
head: [
{ title: "时间", fieldName: "time" },
{ title: "成交价格", fieldName: "tradePrice" },
{ title: "手续费", fieldName: "fee" },
{ title: "成交金额", fieldName: "tradeAmount" }
],
// 数据内容
body: [
{
time: "2019-10-17 14:54:52",
tradePrice: "30.0022.001.32 TWD",
fee: "0 TWD",
tradeAmount: "660.00"
}
// ... more
]
};
example
// 1.导入
import exportExcel from 'js-data-to-csv';
// 2.整理数据格式
const sourceData = {
head: [
{ title: "时间", fieldName: "time" },
{ title: "成交价格", fieldName: "tradePrice" },
{ title: "手续费", fieldName: "fee" },
{ title: "成交金额", fieldName: "tradeAmount" }
],
body: [
{
time: "2019-10-17 14:54:52",
tradePrice: "30.0022.001.32 TWD",
fee: "0 TWD",
tradeAmount: "660.00"
},
{
time: "2019-10-17 14:54:36",
tradePrice: "30.0089.005.34 TWD",
fee: "",
tradeAmount: "2,670.00"
},
{
time: "2019-10-17 14:54:07",
tradePrice: "21.00500.0021 TWD",
fee: "0 TWD",
tradeAmount: "10,500.00"
}
]
};
// 3.调用函数
exportExcel(sourceData,'cardTable')