dream-num / luckyexcel Goto Github PK

View Code? Open in Web Editor NEW

406.0 406.0 148.0 32.81 MB

Luckysheet import export library

License: MIT License

JavaScript 38.83% HTML 41.89% TypeScript 16.99% Batchfile 0.02% CSS 2.27%

luckyexcel's People

Contributors

Stargazers

Watchers

Forkers

shaunstoltz zltwork lapd-frontend gc888 tjwbps hczyh888 b-xiang ilinei52 panxiangwei liufanghua2012 nianhongdong 1012511661 hsw1111 jasonchen0410 topideal shrekjxf lean-net sofia2013 cchjgood huyang19881115 zhangzyi oy-paddy peiguojie123 wct123456 nimo-git hongyu789 huazi103 endlessfire ncutlh zclhlmgqzc cc-edit zeevx magicds zhangsimu1992 akeyz yanjingang jiy1012 hiyizi linjiajie2020 suyongsun romousin whitae wmz46 m8e oduse p1an8 zllugithub ohxxx obedomm yogasw yangxin1994 dahuachan chiikin chenbaowen2004 crazylavendar xiyanz naren-mantra koolou rosen369 gaoxingzaq allwaysoft jmptrader zdl-king almighty-king liujiusheng staxd yyn0210 mawendaxiong nahidhasan830 tianyagulvke idahopotato1 witmiao tornado12345 dkdavion snrt10081 liangyali meinicheng cckz changchengqin zhangbubu 99565475 cloudsay cxwl3sxl xy109 stevelsa mctomac wurentidai markrady lardern scottwansz zhoumh1988 evanzheng11 staroflife sacalata gintoki133 iammikko ptcgh scjasons glustful tienteddy

luckyexcel's Issues

数据验证有下拉表时最新版出现错误。

LuckySheet.ts 607行新增DATA_VERIFICATION_TYPE2_MAP[matchType]判断
_type2 = operator
? DATA_VERIFICATION_TYPE2_MAP[matchType] && DATA_VERIFICATION_TYPE2_MAP[matchType][operator]
: "bw";
修改后正常打开，但当下拉表引用的是区域名称时，还是有错误。希望增加区域名称识别。

导入生成数据后，移动图片会让图片定位失效

导入生成数据后，移动图片会让图片定位失效
导入不能导入格式为xdr:oneCellAnchor 比如：文本框

导入写法有问题

你好，请问有计划开发将文件内的图片也一起导入的功能吗？

丢失公式链

附件excel文件导入
修改C5单元格，C4不变化，但是C4应该要变化才对

查看公式链，发现第四行即C4:O4单元格丢失公式链
100 社康收支表(1).xlsx

[feature]导入Excel没有行列的数量信息

目前通过LuckyExcel导入后，转换出来的json数据中缺少row和column的数量信息。

加载数据的时候整个页面都会被阻塞，有没有办法只更新局部

我的代码如下：

<template>
  <div>
    <el-form ref="form" :model="form" label-width="80px">
      <el-form-item label="活动名称">
        <el-input v-model="form.name"></el-input>
      </el-form-item>
      <el-form-item label="活动区域">
        <el-select v-model="form.region" placeholder="请选择活动区域">
          <el-option label="区域一" value="shanghai"></el-option>
          <el-option label="区域二" value="beijing"></el-option>
        </el-select>
      </el-form-item>
      <el-form-item label="活动时间">
        <el-col :span="11">
          <el-date-picker type="date" placeholder="选择日期" v-model="form.date1" style="width: 100%;"></el-date-picker>
        </el-col>
        <el-col class="line" :span="2">-</el-col>
        <el-col :span="11">
          <el-time-picker placeholder="选择时间" v-model="form.date2" style="width: 100%;"></el-time-picker>
        </el-col>
      </el-form-item>
      <el-form-item>
        <el-button type="primary" >立即创建</el-button>
        <el-button>取消</el-button>
      </el-form-item>
    </el-form>
    <div>
    <div id="lsheet" style="margin:0px;padding:0px;width:100%;height:250px;"></div>
    </div>
  </div>
</template>

<script>
export default {
  data() {
    return {
      form: {
        name: "",
        region: "",
        date1: "",
        date2: "",
      },
    };
  },
  mounted() {
      luckysheet.create({
          container: "lsheet", // 设定DOM容器的id
          title: "Luckysheet Demo", // 设定表格名称
          lang: "zh", // 设定表格语言
          showinfobar: false,
          showtoolbar: false,
          sheetFormulaBar: false,
        });
  }
};
</script>

<style>
</style>

当 lucksheet.create 的时候，其它按钮等组件就按不动了，只有 lucksheet 加载完成后才正常。

【feature】通过配置可调整顶部工具栏中各项工具的显示顺序

需求如标题，当前配置只可以实现顶部工具是否显示，无法通过配置调整工具的显示顺序。烦请优化此项功能，万分感谢。

导入导出好像都无法用，看能否集成起来

导入导出好像都无法用，看能否集成起来，打包出来后导入文件还是提示LuckyExcel is not defined

导入带图片的excel时，不支持导入绑定到单元格上的图片

场景描述：
使用luckysheet导入带图片的excel，没有任何问题。然后使用exceljs导出excel，使用的是将图片绑定到单元格的方式，具体如下图所示：

然后将导出的excel再次导入，发现图片丢失了。
经过分析luckyexcel的源码，原因应该是luckyexcel不支持单元格上的图片导入，源码位置如下：

以上代码只处理了插入到某个区间的图片(tagName为xdr:twoCellAnchor)，而没有处理绑定到单元格的图片(tagName为xdr:oneCellAnchor),
请问这种情况应该如何解决比较好呢？

导入excel换行吧会丢失

[BUG]wps打开过的xlsx文件，无法获取公式链

隐藏行导入错误

如果表格存在隐藏行（测试文件是第一行和中间有隐藏行），导入时报错。

文字对齐方式为Bottom的，导入后样式丢失

单元格文字样式如果为bottom，导入后都会变成middle，样式丢失。

<xdr:oneCellAnchor> images are ignored

When parsing the excel file's drawing.xml you store all xdr:twoCellAnchor elements in a variable, then you iterate said variable and add every image you find in the twoCellAnchor elements to the output object's images property, this happens in the following line:
_this.readXml.getElementsByTagName("xdr:twoCellAnchor", drawingFile);

however in certain excel sheets there are perfeclty valid images stored in xdr:oneCellAnchor elements aswell, said images are currently being ignored

The imported excel file cells cannot be calculated automatically导入的excel文件单元格不能自动计算

Luckyexcel导入xlsx会报错

ReadXml.ts:28 Uncaught (in promise) TypeError: t.match is not a function
at u.s.getElementsByOneTag (ReadXml.ts:28)
at u.getElementsByTagName (ReadXml.ts:63)
at o.getSheetNameList (LuckyFile.ts:58)
at new o (LuckyFile.ts:25)
at main.ts:39
at HandleZip.ts:27

自定义公式通过luckyexcel导入后不生效

自定义公式EVALUATE添加入Luckysheet\src\function\functionImplementation.js与Luckysheet\src\locale\zh.js（en.js、es.js）
npm run build打包后，把dist目录下的打包文件覆盖Luckyexcel\assets\luckysheet下的所有文件，重新打包Luckexcel后导入包含自定义公式EVALUATE的xlsx文件，函数并不生效。

经@Cow&sheep测试后确认是在导入过程中出现的问题。

Luckyexcel\src\ToLuckySheet\LuckySheet.ts 151行this.calcChain.push(chain);为空.

打包完没有出现文档中的boundle.js

如何处理

paste data to luckyexcel from wps excel applacation , but the cell data converted img ,

如何在vue项目使用？

隐藏列不生效

后台生成的excel文件流，隐藏列没有隐藏

for in遍历数组原型链所有可枚举的属性的问题

源码中使用了for in，在拓展了Array.prototype的时候会报错

Uncaught ex when trying to load xlsx

For some reason this simple sheet fails to parse, the sheet is completely valid and opens normally

following log when trying to parse:

LuckyExcelTest:1 Uncaught (in promise) 1 e
Promise.then (async)
(anonymous) @ luckyexcel.umd.js:17309
forEach @ luckyexcel.umd.js:4302
(anonymous) @ luckyexcel.umd.js:17289
Promise.then (async)
HandleZip.unzipFile @ luckyexcel.umd.js:17285
LuckyExcel.transformExcelToLucky @ luckyexcel.umd.js:22860
(anonymous)

this can be replicated on the luckyexcel demo page as well, i have attached the sheet
ExampleSheet.xlsx

导入excel 绘制的图形丢失

你好mengshukeji，导入excel 绘制的图形会丢失

行首多个空格会变为一个

xlsx中编辑的文字，如果单元格内的文字前面有空格（多是段落起始空两格类似的情况），多个空格导入后在显示上只有一个，但进入编辑状态，实际有多个空格。
另外一个问题，将提在luckyexcel，这里简要描述下，就是单无格内的文字编辑，如果不是在文字尾部，在头部或中间任意位置编辑，输入一个字符后，光标就会跳到文字尾部，无法连续在头部或中间输入文字。

什么时候支持条件格式

如题,不知道近期有开发计划没

不要用for..in来循环数组

在我们的项目中总会有各种各样的封装，包括给数组增加适合我们业务的扩展方法，但是代码中的for...in给我的项目带来的大麻烦，致使无法正常使用luckyexcel，我们也不希望放弃项目中的扩展方法因此

希望不要在项目中使用for...in来循环数组

Missing NPM package

Look forward

无法导入带有批注的表格

How to resolve undefined error?

When i use HelloWorld.vue in my own Program, i get the error in the browser like this: '$ is undefined', 'lucksheet is undefined'.
How to resolve the problem?

luckyexcel4j : luckyexcel java implementation

luckyexcel java implementation
https://github.com/muzhix/luckyexcel4j

Excel日文导入问题

作者你好！我在使用luckyExcel的过程中出现了导入一个包含日文的Excel时，会出现多余的片假名情况。
Excel原文件内容：

导入后内容：

Excel解析数据

有问题的Excel文件
023_検収書_タテ型.xlsx

麻烦帮忙分析一下问题的原因。

期待包含图表类数据的Excel文件的导入

.emf类型图片解析失败 & 图片翻转问题

excel.xlsx

以上表格使用luckyExcel导入遇到两个问题：

表格中的.emf文件解析失败，在src/common/emf.ts 'if(w!=wS || h!=hS) throw "e";'

抛出异常导致文件整体无法解析，注释掉后文件可继续导入，但渲染出的表格中缺少.emf文件
其中一个图片解析出来使用luckysheet渲染结果是翻转的：

没有导出功能

应该还没有实现导出功能吧，请问有计划开发吗

Precision Issue with Luckysheet ( JS )

hey, @wbfsa .. I have gone through this project.. It's really awesome.. but I have a doubt... whether calculation done by lucksheet is precise or not.. I mean as compare to python.. does this project is capable of calculating big calculations with same precision as python provide for data science kind of stuff..

<link rel='stylesheet' href='https://cdn.jsdelivr.net/npm/luckysheet/dist/plugins/css/pluginsCss.css' />

$(function () {

    var sheetDataVerification = {
        "name": "Data Verification",
        "index": "Sheet_pdolzzie5xwi_1600927444446",
        "celldata": [{ "r": 0, "c": 0, "v": { "ct": { "fa": "General", "t": "g" }, "m": "Drop Down List", "v": "Drop Down List", "bl": 1 } }, { "r": 0, "c": 1, "v": { "m": "Checkbox", "ct": { "fa": "General", "t": "g" }, "v": "Checkbox", "bl": 1 } }, { "r": 0, "c": 2, "v": { "ct": { "fa": "General", "t": "g" }, "v": "Number between 1-10", "bl": 1, "m": "Number between 1-10" } }, { "r": 0, "c": 3, "v": { "m": "Text content include Luckysheet", "ct": { "fa": "General", "t": "g" }, "v": "Text content include Luckysheet", "bl": 1 } }, { "r": 0, "c": 4, "v": { "ct": { "fa": "General", "t": "g" }, "v": "Text length between 1-5", "m": "Text length between 1-5", "bl": 1 } }, { "r": 0, "c": 5, "v": { "m": "Date", "ct": { "fa": "General", "t": "g" }, "v": "Date", "bl": 1 } }, { "r": 0, "c": 6, "v": { "m": "Identification Number", "ct": { "fa": "General", "t": "g" }, "v": "Identification Number", "bl": 1 } }, { "r": 0, "c": 7, "v": { "m": "Phone Number", "ct": { "fa": "General", "t": "g" }, "v": "Phone Number", "bl": 1 } }, { "r": 1, "c": 0, "v": { "ct": { "fa": "General", "t": "g" }, "v": "Fix", "m": "Fix" } }, { "r": 1, "c": 1, "v": { "m": "Fail", "ct": { "fa": "General", "t": "g" }, "v": "Fail" } }, { "r": 1, "c": 2, "v": { "v": 1, "ct": { "fa": "General", "t": "n" }, "m": "1" } }, { "r": 1, "c": 3, "v": { "m": "Luckysheet is good", "ct": { "fa": "General", "t": "g" }, "v": "Luckysheet is good" } }, { "r": 1, "c": 4, "v": { "m": "Welcome", "ct": { "fa": "General", "t": "g" }, "v": "Welcome" } }, { "r": 1, "c": 5, "v": { "m": "2020-09-24", "ct": { "fa": "yyyy-MM-dd", "t": "d" }, "v": 44098 } }, { "r": 1, "c": 6, "v": { "v": "311414199009138910", "ct": { "fa": "@", "t": "s" }, "m": "311414199009138910" } }, { "r": 1, "c": 7, "v": { "v": 13678765439, "ct": { "fa": "General", "t": "n" }, "m": "13678765439" } }, { "r": 2, "c": 0, "v": { "ct": { "fa": "General", "t": "g" }, "v": "Done", "m": "Done" } }, { "r": 2, "c": 1, "v": { "m": "Pass", "ct": { "fa": "General", "t": "g" }, "v": "Pass" } }, { "r": 2, "c": 2, "v": { "v": 2, "ct": { "fa": "General", "t": "n" }, "m": "2" } }, { "r": 2, "c": 3, "v": { "m": "I am Luckysheet", "ct": { "fa": "General", "t": "g" }, "v": "I am Luckysheet" } }, { "r": 2, "c": 4, "v": { "m": "Good", "ct": { "fa": "General", "t": "g" }, "v": "Good" } }, { "r": 2, "c": 5, "v": { "ct": { "fa": "General", "t": "g" }, "v": "Time", "m": "Time" } }, { "r": 2, "c": 6, "v": { "v": "31141419900913891", "ct": { "fa": "@", "t": "s" }, "m": "31141419900913891" } }, { "r": 2, "c": 7, "v": { "v": 1367876544, "ct": { "fa": "General", "t": "n" }, "m": "1367876544" } }, { "r": 3, "c": 0, "v": { "ct": { "fa": "General", "t": "g" }, "v": "Develop", "m": "Develop" } }, { "r": 3, "c": 1, "v": { "m": "Fail", "ct": { "fa": "General", "t": "g" }, "v": "Fail" } }, { "r": 3, "c": 2, "v": { "v": 5, "ct": { "fa": "General", "t": "n" }, "m": "5" } }, { "r": 3, "c": 3, "v": { "ct": { "fa": "General", "t": "g" }, "v": "I am luckyDemo", "m": "I am luckyDemo" } }, { "r": 3, "c": 4, "v": { "m": "Nice", "ct": { "fa": "General", "t": "g" }, "v": "Nice" } }, { "r": 3, "c": 5, "v": { "m": "2020-09-26", "ct": { "fa": "yyyy-MM-dd", "t": "d" }, "v": 44100 } }, { "r": 3, "c": 6, "v": { "v": "3114141990091389102", "ct": { "fa": "@", "t": "s" }, "m": "3114141990091389102" } }, { "r": 3, "c": 7, "v": { "v": 136787654412, "ct": { "fa": "##0", "t": "n" }, "m": "136787654412" } }, { "r": 4, "c": 0, "v": { "ct": { "fa": "General", "t": "g" }, "v": "Doing", "m": "Doing" } }, { "r": 4, "c": 1, "v": { "m": "Fail", "ct": { "fa": "General", "t": "g" }, "v": "Fail" } }, { "r": 4, "c": 2, "v": { "v": 11, "ct": { "fa": "General", "t": "n" }, "m": "11" } }, { "r": 4, "c": 3, "v": { "ct": { "fa": "General", "t": "g" }, "v": "Luckysheet Documentation", "m": "Luckysheet Documentation" } }, { "r": 4, "c": 4, "v": { "ct": { "fa": "General", "t": "g" }, "v": "Morning", "m": "Morning" } }, { "r": 4, "c": 5, "v": { "m": "2020-09-27", "ct": { "fa": "yyyy-MM-dd", "t": "d" }, "v": 44101 } }, { "r": 4, "c": 6, "v": { "v": "31141419900913891X", "ct": { "fa": "@", "t": "s" }, "m": "31141419900913891X" } }, { "r": 4, "c": 7, "v": { "v": 49865342456, "ct": { "fa": "General", "t": "n" }, "m": "49865342456" } }, { "r": 5, "c": 0, "v": { "ct": { "fa": "General", "t": "g" }, "v": "Develop", "m": "Develop" } }, { "r": 5, "c": 1, "v": { "m": "Fail", "ct": { "fa": "General", "t": "g" }, "v": "Fail" } }, { "r": 5, "c": 2, "v": { "v": 3, "ct": { "fa": "General", "t": "n" }, "m": "3" } }, { "r": 5, "c": 3, "v": { "m": "Luckyexcel", "ct": { "fa": "General", "t": "g" }, "v": "Luckyexcel" } }, { "r": 5, "c": 4, "v": { "ct": { "fa": "General", "t": "g" }, "v": "Tomorrow", "m": "Tomorrow" } }, { "r": 5, "c": 5, "v": { "ct": { "fa": "yyyy-MM-dd", "t": "d" }, "v": 44071, "m": "2020-08-28" } }, { "r": 5, "c": 6, "v": { "v": "Number", "ct": { "fa": "@", "t": "s" }, "m": "Number" } }, { "r": 5, "c": 7, "v": { "v": "Number", "ct": { "fa": "General", "t": "g" }, "m": "Number" } }, { "r": 6, "c": 0, "v": { "ct": { "fa": "General", "t": "g" }, "v": "Done", "m": "Done" } }, { "r": 6, "c": 1, "v": { "m": "Pass", "ct": { "fa": "General", "t": "g" }, "v": "Pass" } }, { "r": 6, "c": 2, "v": { "v": 0, "ct": { "fa": "General", "t": "n" }, "m": "0" } }, { "r": 6, "c": 3, "v": { "m": "Luckysheet Online", "ct": { "fa": "General", "t": "g" }, "v": "Luckysheet Online" } }, { "r": 6, "c": 4, "v": { "m": "Three", "ct": { "fa": "General", "t": "g" }, "v": "Three" } }, { "r": 6, "c": 5, "v": { "m": "2020-09-29", "ct": { "fa": "yyyy-MM-dd", "t": "d" }, "v": 44103 } }, { "r": 6, "c": 6, "v": { "v": "311414199301118910", "ct": { "fa": "@", "t": "s" }, "m": "311414199301118910" } }, { "r": 6, "c": 7, "v": { "v": 23309873564, "ct": { "fa": "General", "t": "n" }, "m": "23309873564" } }, { "r": 7, "c": 8, "v": { "v": null, "ct": { "fa": "General", "t": "g" }, "bl": 1 } }],
        "row": 84,
        "column": 60,
        "config": {
            "merge": {},
            "rowlen": {},
            "columnlen": {
                "0": 109,
                "2": 143,
                "3": 200,
                "4": 180,
                "6": 178,
                "7": 125
            },
            "customWidth": {
                "2": 1,
                "3": 1,
                "4": 1,
                "6": 1,
                "7": 1
            }
        },
        "luckysheet_select_save": [
            {
                "left": 963,
                "width": 125,
                "top": 240,
                "height": 19,
                "left_move": 963,
                "width_move": 125,
                "top_move": 240,
                "height_move": 19,
                "row": [
                    12,
                    12
                ],
                "column": [
                    7,
                    7
                ],
                "row_focus": 12,
                "column_focus": 7
            }
        ],
        "dataVerification": {
            "1_0": {
                "type": "dropdown",
                "type2": null,
                "value1": "Develop,Fix,Done",
                "value2": "",
                "checked": false,
                "remote": false,
                "prohibitInput": false,
                "hintShow": false,
                "hintText": ""
            },
            "2_0": {
                "type": "dropdown",
                "type2": null,
                "value1": "Develop,Fix,Done",
                "value2": "",
                "checked": false,
                "remote": false,
                "prohibitInput": false,
                "hintShow": false,
                "hintText": ""
            },
            "3_0": {
                "type": "dropdown",
                "type2": null,
                "value1": "Develop,Fix,Done",
                "value2": "",
                "checked": false,
                "remote": false,
                "prohibitInput": false,
                "hintShow": false,
                "hintText": ""
            },
            "4_0": {
                "type": "dropdown",
                "type2": null,
                "value1": "Develop,Fix,Done",
                "value2": "",
                "checked": false,
                "remote": false,
                "prohibitInput": false,
                "hintShow": false,
                "hintText": ""
            },
            "5_0": {
                "type": "dropdown",
                "type2": null,
                "value1": "Develop,Fix,Done",
                "value2": "",
                "checked": false,
                "remote": false,
                "prohibitInput": false,
                "hintShow": false,
                "hintText": ""
            },
            "6_0": {
                "type": "dropdown",
                "type2": null,
                "value1": "Develop,Fix,Done",
                "value2": "",
                "checked": false,
                "remote": false,
                "prohibitInput": false,
                "hintShow": false,
                "hintText": ""
            },
            "1_1": {
                "type": "checkbox",
                "type2": null,
                "value1": "Pass",
                "value2": "Fail",
                "checked": false,
                "remote": true,
                "prohibitInput": false,
                "hintShow": false,
                "hintText": ""
            },
            "2_1": {
                "type": "checkbox",
                "type2": null,
                "value1": "Pass",
                "value2": "Fail",
                "checked": true,
                "remote": true,
                "prohibitInput": false,
                "hintShow": false,
                "hintText": ""
            },
            "3_1": {
                "type": "checkbox",
                "type2": null,
                "value1": "Pass",
                "value2": "Fail",
                "checked": false,
                "remote": true,
                "prohibitInput": false,
                "hintShow": false,
                "hintText": ""
            },
            "4_1": {
                "type": "checkbox",
                "type2": null,
                "value1": "Pass",
                "value2": "Fail",
                "checked": false,
                "remote": true,
                "prohibitInput": false,
                "hintShow": false,
                "hintText": ""
            },
            "5_1": {
                "type": "checkbox",
                "type2": null,
                "value1": "Pass",
                "value2": "Fail",
                "checked": false,
                "remote": true,
                "prohibitInput": false,
                "hintShow": false,
                "hintText": ""
            },
            "6_1": {
                "type": "checkbox",
                "type2": null,
                "value1": "Pass",
                "value2": "Fail",
                "checked": true,
                "remote": true,
                "prohibitInput": false,
                "hintShow": false,
                "hintText": ""
            },
            "1_2": {
                "type": "number",
                "type2": "bw",
                "value1": "1",
                "value2": "10",
                "checked": false,
                "remote": false,
                "prohibitInput": true,
                "hintShow": false,
                "hintText": ""
            },
            "2_2": {
                "type": "number",
                "type2": "bw",
                "value1": "1",
                "value2": "10",
                "checked": false,
                "remote": false,
                "prohibitInput": true,
                "hintShow": false,
                "hintText": ""
            },
            "3_2": {
                "type": "number",
                "type2": "bw",
                "value1": "1",
                "value2": "10",
                "checked": false,
                "remote": false,
                "prohibitInput": true,
                "hintShow": false,
                "hintText": ""
            },
            "4_2": {
                "type": "number",
                "type2": "bw",
                "value1": "1",
                "value2": "10",
                "checked": false,
                "remote": false,
                "prohibitInput": true,
                "hintShow": false,
                "hintText": ""
            },
            "5_2": {
                "type": "number",
                "type2": "bw",
                "value1": "1",
                "value2": "10",
                "checked": false,
                "remote": false,
                "prohibitInput": true,
                "hintShow": false,
                "hintText": ""
            },
            "6_2": {
                "type": "number",
                "type2": "bw",
                "value1": "1",
                "value2": "10",
                "checked": false,
                "remote": false,
                "prohibitInput": true,
                "hintShow": false,
                "hintText": ""
            },
            "1_3": {
                "type": "text_content",
                "type2": "include",
                "value1": "Luckysheet",
                "value2": "",
                "checked": false,
                "remote": false,
                "prohibitInput": false,
                "hintShow": true,
                "hintText": "include Luckysheet"
            },
            "2_3": {
                "type": "text_content",
                "type2": "include",
                "value1": "Luckysheet",
                "value2": "",
                "checked": false,
                "remote": false,
                "prohibitInput": false,
                "hintShow": true,
                "hintText": "include Luckysheet"
            },
            "3_3": {
                "type": "text_content",
                "type2": "include",
                "value1": "Luckysheet",
                "value2": "",
                "checked": false,
                "remote": false,
                "prohibitInput": false,
                "hintShow": true,
                "hintText": "include Luckysheet"
            },
            "4_3": {
                "type": "text_content",
                "type2": "include",
                "value1": "Luckysheet",
                "value2": "",
                "checked": false,
                "remote": false,
                "prohibitInput": false,
                "hintShow": true,
                "hintText": "include Luckysheet"
            },
            "5_3": {
                "type": "text_content",
                "type2": "include",
                "value1": "Luckysheet",
                "value2": "",
                "checked": false,
                "remote": false,
                "prohibitInput": false,
                "hintShow": true,
                "hintText": "include Luckysheet"
            },
            "6_3": {
                "type": "text_content",
                "type2": "include",
                "value1": "Luckysheet",
                "value2": "",
                "checked": false,
                "remote": false,
                "prohibitInput": false,
                "hintShow": true,
                "hintText": "include Luckysheet"
            },
            "1_4": {
                "type": "text_length",
                "type2": "bw",
                "value1": "1",
                "value2": "5",
                "checked": false,
                "remote": false,
                "prohibitInput": true,
                "hintShow": false,
                "hintText": ""
            },
            "2_4": {
                "type": "text_length",
                "type2": "bw",
                "value1": "1",
                "value2": "5",
                "checked": false,
                "remote": false,
                "prohibitInput": true,
                "hintShow": false,
                "hintText": ""
            },
            "3_4": {
                "type": "text_length",
                "type2": "bw",
                "value1": "1",
                "value2": "5",
                "checked": false,
                "remote": false,
                "prohibitInput": true,
                "hintShow": false,
                "hintText": ""
            },
            "4_4": {
                "type": "text_length",
                "type2": "bw",
                "value1": "1",
                "value2": "5",
                "checked": false,
                "remote": false,
                "prohibitInput": true,
                "hintShow": false,
                "hintText": ""
            },
            "5_4": {
                "type": "text_length",
                "type2": "bw",
                "value1": "1",
                "value2": "5",
                "checked": false,
                "remote": false,
                "prohibitInput": true,
                "hintShow": false,
                "hintText": ""
            },
            "6_4": {
                "type": "text_length",
                "type2": "bw",
                "value1": "1",
                "value2": "5",
                "checked": false,
                "remote": false,
                "prohibitInput": true,
                "hintShow": false,
                "hintText": ""
            },
            "1_5": {
                "type": "date",
                "type2": "bw",
                "value1": "2020-09-23",
                "value2": "2020-10-10",
                "checked": false,
                "remote": false,
                "prohibitInput": false,
                "hintShow": false,
                "hintText": ""
            },
            "2_5": {
                "type": "date",
                "type2": "bw",
                "value1": "2020-09-23",
                "value2": "2020-10-10",
                "checked": false,
                "remote": false,
                "prohibitInput": false,
                "hintShow": false,
                "hintText": ""
            },
            "3_5": {
                "type": "date",
                "type2": "bw",
                "value1": "2020-09-23",
                "value2": "2020-10-10",
                "checked": false,
                "remote": false,
                "prohibitInput": false,
                "hintShow": false,
                "hintText": ""
            },
            "4_5": {
                "type": "date",
                "type2": "bw",
                "value1": "2020-09-23",
                "value2": "2020-10-10",
                "checked": false,
                "remote": false,
                "prohibitInput": false,
                "hintShow": false,
                "hintText": ""
            },
            "5_5": {
                "type": "date",
                "type2": "bw",
                "value1": "2020-09-23",
                "value2": "2020-10-10",
                "checked": false,
                "remote": false,
                "prohibitInput": false,
                "hintShow": false,
                "hintText": ""
            },
            "6_5": {
                "type": "date",
                "type2": "bw",
                "value1": "2020-09-23",
                "value2": "2020-10-10",
                "checked": false,
                "remote": false,
                "prohibitInput": false,
                "hintShow": false,
                "hintText": ""
            },
            "1_6": {
                "type": "validity",
                "type2": "card",
                "value1": "",
                "value2": "",
                "checked": false,
                "remote": false,
                "prohibitInput": false,
                "hintShow": false,
                "hintText": ""
            },
            "2_6": {
                "type": "validity",
                "type2": "card",
                "value1": "",
                "value2": "",
                "checked": false,
                "remote": false,
                "prohibitInput": false,
                "hintShow": false,
                "hintText": ""
            },
            "3_6": {
                "type": "validity",
                "type2": "card",
                "value1": "",
                "value2": "",
                "checked": false,
                "remote": false,
                "prohibitInput": false,
                "hintShow": false,
                "hintText": ""
            },
            "4_6": {
                "type": "validity",
                "type2": "card",
                "value1": "",
                "value2": "",
                "checked": false,
                "remote": false,
                "prohibitInput": false,
                "hintShow": false,
                "hintText": ""
            },
            "5_6": {
                "type": "validity",
                "type2": "card",
                "value1": "",
                "value2": "",
                "checked": false,
                "remote": false,
                "prohibitInput": false,
                "hintShow": false,
                "hintText": ""
            },
            "6_6": {
                "type": "validity",
                "type2": "card",
                "value1": "",
                "value2": "",
                "checked": false,
                "remote": false,
                "prohibitInput": false,
                "hintShow": false,
                "hintText": ""
            },
            "1_7": {
                "type": "validity",
                "type2": "phone",
                "value1": "",
                "value2": "",
                "checked": false,
                "remote": false,
                "prohibitInput": false,
                "hintShow": false,
                "hintText": ""
            },
            "2_7": {
                "type": "validity",
                "type2": "phone",
                "value1": "",
                "value2": "",
                "checked": false,
                "remote": false,
                "prohibitInput": false,
                "hintShow": false,
                "hintText": ""
            },
            "3_7": {
                "type": "validity",
                "type2": "phone",
                "value1": "",
                "value2": "",
                "checked": false,
                "remote": false,
                "prohibitInput": false,
                "hintShow": false,
                "hintText": ""
            },
            "4_7": {
                "type": "validity",
                "type2": "phone",
                "value1": "",
                "value2": "",
                "checked": false,
                "remote": false,
                "prohibitInput": false,
                "hintShow": false,
                "hintText": ""
            },
            "5_7": {
                "type": "validity",
                "type2": "phone",
                "value1": "",
                "value2": "",
                "checked": false,
                "remote": false,
                "prohibitInput": false,
                "hintShow": false,
                "hintText": ""
            },
            "6_7": {
                "type": "validity",
                "type2": "phone",
                "value1": "",
                "value2": "",
                "checked": false,
                "remote": false,
                "prohibitInput": false,
                "hintShow": false,
                "hintText": ""
            }
        }
    }
    var options = {
        container: 'luckysheet',
        data: [sheetDataVerification]
    }
    luckysheet.create(options)
    
   // export default sheetDataVerification;

});

导入poi生成的excel时，隐藏网格线不生效。

由于poi生成的excel的showGridLines的值为"true"/"false"，不是"0"/"1"。
建议在以下代码后面增加兼容处理。

https://github.com/mengshukeji/Luckyexcel/blob/dcb681a75ccdff459b2f2f745325e12e1a378522/src/ToLuckySheet/LuckySheet.ts#L50
如：

if(showGridLines == "true") {
    showGridLines = "1";
}else if(showGridLines == "false"){
    showGridLines = "0";
}

Luckyexcel测试$符号.xlsx

后台返回excel流文件使用LuckyExcel.transformExcelToLucky怎么返显到列表上

使用 LuckyExcel.transformExcelToLucky(file.raw) 可以返显本地文件，

用new = File([blob]) 得 file 注入到 LuckyExcel.transformExcelToLucky里面去就会一直报错 ‘getInnerElements’找不到

如何只导入一个sheet页

如果一个excel内容太大，怎么能只导入某一个sheet页，而不是整个excel

Recommend Projects

React

A declarative, efficient, and flexible JavaScript library for building user interfaces.
Vue.js

🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
Typescript

TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
TensorFlow

An Open Source Machine Learning Framework for Everyone
Django

The Web framework for perfectionists with deadlines.
Laravel

A PHP framework for web artisans
D3

Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

javascript

JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
web

Some thing interesting about web. New door for the world.
server

A server is a program made to process requests and deliver data to clients.
Machine learning

Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Visualization

Some thing interesting about visualization, use data art
Game

Some thing interesting about game, make everyone happy.

Recommend Org

Facebook

We are working to build community through open source technology. NB: members must have two-factor auth.
Microsoft

Open source projects and samples from Microsoft.
Google

Google ❤️ Open Source for everyone.
Alibaba

Alibaba Open Source for everyone
D3

Data-Driven Documents codes.
Tencent

China tencent open source team.