简介

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

预览

安装

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"}]}] |

功能

• [x] 单选
• [x] 多选
• [x] 复制
• [x] 粘贴
• [x] 右下角格式刷
• [x] 合并
• [x] 拆分
• [x] 拖拽
• [x] 添加行数
• [x] 添加列数
• [x] 字体
• [x] 文字颜色
• [x] 背景色
• [x] 文字水平对齐
• [x] 文字垂直对齐
• [x] 删除线
• [x] 下划线
• [x] 导出
• [x] 导入
• [x] 前进
• [x] 后退