使用的库
npm install xlsx
基本操作
import XLSX from 'xlsx'
let tiltle_arr=[['零件数据表']]
let part_data=[{part_name:'螺丝',part_number:'10'},{part_name:'螺母',part_number:'20'}]
let header=['part_name','part_numner']
let work_sheet=XLSX.utils.aoa_to_sheet(title_arr)
let merge=[{s:{r:0,c:0},e:{r:0,c:1}}]
work_sheet['!merges']=merge
XLSX.utils.sheet_add_json(work_sheet,part_data,{header:header,origin:'A2'})
let work_book=XLSX.utils.book_new()
XLSX.utils.book_append_sheet(work_book,work_sheet,'mySheet')
XLSX.write(work_book,'part_list.xlsx')
样例图标