解析Excel工作簿并获得javascipt的或有角的复选框值复选框、有角、工作、Excel

2023-09-14 00:19:20 作者:爱她离我你心狠

我解析Excel文件来获得Excel工作簿中的所有数据,我使用的

目前我所有的价值越来越阅读JavaScript,但现在我要接受来自Excel工作簿中的复选框的值。是否被选中。 CHK下面的例子示例工作簿。

有没有什么办法让该复选框的值。

解决方案

我已经做了这个小把戏,在Excel文件放置映射到这个复选框一个细胞,当复选框的单元格的值检查更新,1,如果复选框的勾选,那么此单元格的值是零。

正如我可以阅读简单的Excel单元格的值,根据这个隐藏单元格的值,我们得到的复选框是否被选中。

希望在未来的这个帮助别人。

I am parsing the excel file to get all the data from Excel workbook, I am using js-xlsx Plugin from github

多工作簿合并,其实很简单

Currently my all value are getting read in JavaScript but now I want to accept the value of the checkbox from excel workbook. whether is checked or not. Chk following example from sample workbook.

is there any way to get the value of this check box.

解决方案

I have done this with small trick, In excel file placed one cell which maps to this check-box, when check-box is checked updated the value of cell as 1 and if check-box is unchecked then value of this cell is zero.

As I can read the simple excel cell value, according to this hidden cell value we get whether the check-box is checked or not.

Hope this help someone in future.