web-excel-complete

This Package should help get you started developing with web-excel. It's baseed on x-spreadsheet and @wolf-table package. Thanks you for the Technical support from myliang

Recommended IDE Setup

VSCode

Customize configuration

See Vite Configuration Reference.

Package install

npm i web-excel-complete

Use Page

import { WebExcel } from 'web-excel-complate'

const excel = WebExcel.create('#app', 
    () => window.innerWidth, 
    () => window.innerHeight,
    {
        scrollable: true,
        resizable: true,
        selectable: true,
        editable: true,
        copyable: true,
        showToolbar: true,
        showBottom: true,
        showTableContextMenu: true
    }
)
.setData([
    {
        name: 'sheet1',
        data: {
            styles: [{
                bold: true,
                strike: true,
                color: '#21ba45',
                italic: true,
                align: 'center',
                fontSize: 12,
            }],
            cells: [
                [0, 0, 'abc'],
                [1, 0, 1],
                [2, 0, 2],
                [3, 0, 3],
                [4, 0, 4],
                [5, 0, 5],
                [6, 0, 6],
                [7, 0, 7],
                [8, 0, 8],
                [9, 0, 9],
                [1, 1, 100],
                [2, 6, { value: 'formua', style: 0 }],
                [9, 5, { value: '', formula: '=SUM(A1:A10)' }]
            ],
            borders: [['E8:L12', 'all', 'medium', '#21ba45']],
            merges: ['F10:G11', 'I10:K11'],
            freeze: 'D5',
            autoFilter: [[0, 0], [0, 1], [2, 6], [9, 5]]
        }
    }
])
.render()