E-sheet NPM | npm.io

简介

使用canvas绘制excel表格，支持部分基础的表格操作功能，可支持和阿里在excel文档和wps互相复制粘贴数据

example

预览

安装

npm i e-sheet

使用

// es

import eSheet from 'e-sheet'
import 'e-sheet/dist/css/index.css'

const excel = new eSheet('#elt',{
    width:1200,
    height:800
})


// umd

<link rel="stylesheet" href="dist/css/index.css">
<script lang="javascript" src="dist/e-sheet.umd.js"></script>

const excel = new eSheet('#elt',{
    width:1200,
    height:800
})

协同服务

cd ./server/multi-person-collaboration

cargo run

api

函数名	功能	参数	样例
exportXlsxData	导出	无	{label:"sheet1",sheet:{!ref:"D10",D10:{t:"s",v:"测试内容"}}}
stepCallbackHandle	操作回调	callback	excel.stepCallbackHandle((obj)=>{console.log(obj))
fresh	全部刷新	无	void
freshContent	刷新表格内容	无	void
connectWebSocket	链接websocket	链接地址addr	ws://192.168.31.208:8091
drawExcel	导入excel数据	books	[{"id":1703748720496,"label":"Sheet1","sheet":[{"row":1,"col":1,"text":"","textAsNumber":null,"width":120,"height":40,"x":0,"y":0,"ltX":40,"ltY":40,"mergeWidth":0,"mergeHeight":0,"mergeRow":1,"mergeCol":1,"mergeStartLabel":"","mergeEndLabel":"","mergeLabelGroup":[],"isMerge":false,"bgColor":"#ffffff","fontColor":"#000000","font":null,"fontSize":12,"fontWeight":"","fontItalic":"","fontFamily":"Calibre","textAlign":"center","textBaseline":"middle","strikethrough":"","underline":"","label":"A1"}]}]