online-excel1
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);
}
主要项目负责人
- 马乾博