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

sh

npm i web-excel-complete

$3

sh

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()

Package install

sh
npm i web-excel-complete

$3

sh
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()