Install

npm install online-excel1 yarn add online-excel1

使用

import handlerExcel { dataOptionsVo } from 'online-excel1';

private openExcel() { const dataOptions: dataOptionsVo = { data:[ {
sheetName: '欢迎词', content: [ ['nihao','welcome','hello','world'], ['nihao','welcome','hello','world'], ['nihao','welcome','hello','world'], ['nihao','welcome','hello','world'], ], merge: [ { row: 0, // 要合并第几行 col: 1, // 要合并第几列 rowCount: 2, // 合并多少行 colCount: 3 // 合并多少列 } ], columnCount: 5, columnWidth: 100 // 每一列的宽度 }, {
sheetName: '欢迎词', content: [ ['nihao','welcome','hello','world'], ['nihao','welcome','hello','world'], ['nihao','welcome','hello','world'], ['nihao','welcome','hello','world'], ], merge: [ { row: 0, // 要合并第几行 col: 1, // 要合并第几列 rowCount: 1, // 合并多少行 colCount: 3 // 合并多少列 } ], columnCount: 5, columnWidth: 100 // 每一列的宽度 } ], isSelected: 1 }; handlerExcel(dataOptions); }

主要项目负责人

• 马乾博