Install

npm install online-excel-interface1 yarn add online-excel-interface1

使用

    import handlerExcel { dataOptionsVo } from 'online-excel-interface1';

    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);
    }

主要项目负责人

• 马乾博