找回密码
 立即注册

QQ登录

只需一步，快速开始

首页 › SpreadJS & GcExcel专区 › 求助中心 › 查看内容
发新帖

yhjsbok

注册会员

8

主题

27

帖子

184

积分

注册会员

积分
184
最新发帖

[已处理] 求助！！！！！

yhjsbok
注册会员   /  发表于：2018-11-11 20:44  /   查看：5883  /  回复：11


问题1：我想要这个效果：格子值为0就显示-，空就空显示，有值得就显示值，但是格子值为0就显示 - 要怎么处理呢？
blob454817199.png

问题2：我spreadjs版本是11.2.2，我是用下面的数据绑定方式,导出excel列头及内容都是空的，是什么原因呢？
blob530227355.png
blob645638732.png
blob703586120.png
blob619444579.png

11 个回复

倒序浏览
KevinChen讲师达人认证 悬赏达人认证 SpreadJS 开发认证
论坛元老   /  发表于：2018-11-12 10:56:58
沙发
问题1、参考学习指南的单元格格式：

https://demo.grapecity.com.cn/Sp ... emos/basicFormatter

单元格格式设置为[=0]"-"即可。

问题2：导出Spread JS时，需要为toJSON方法传参{includeBindingSource: true}

具体用法参考API：

http://help.grapecity.com/spread ... orkbook~toJSON.html
回复 使用道具 举报
yhjsbok
注册会员   /  发表于：2018-11-12 11:27:55
板凳
我写法没问题呀
blob401129760.png
blob700292968.png
回复 使用道具 举报
KevinChen讲师达人认证 悬赏达人认证 SpreadJS 开发认证
论坛元老   /  发表于：2018-11-12 11:32:04
地板
spread.toJSON不需要序列化成字符串，我的代码如下：

  1. // 导出到excel中，包括绑定的数据，并将表头导出
  2.             var json = spread.toJSON({
  3.                 includeBindingSource: true,
  4.                 columnHeadersAsFrozenRows:true
  5.             });

  7.             // here is excel IO API
  8.             excelIo.save(json, function (blob) {
  9.                 saveAs(blob, fileName);
  10.             }, function (e) {
  11.                 // process error
  12.                 console.log(e);
  13.             }, {password: password});
复制代码
回复 使用道具 举报
yhjsbok
注册会员   /  发表于：2018-11-12 13:16:53
5#
KevinChen 发表于 2018-11-12 11:32
spread.toJSON不需要序列化成字符串，我的代码如下：

json字串内容如下:
"{"version":"11.2.2","tabStripVisible":false,"newTabVisible":false,"grayAreaBackColor":"white","sheets":{"Sheet1":{"name":"Sheet1","rowCount":28,"columnCount":41,"data":{"dataTable":{"0":{"1":{"value":"Id"},"2":{"value":"Submit"},"3":{"value":"Deadline"},"4":{"value":"Year"},"5":{"value":"Sheet"},"6":{"value":"Entity"},"7":{"value":"R/L/I"},"8":{"value":"CostCenter"},"9":{"value":"CCdescription"},"10":{"value":"CCowner"},"11":{"value":"Dept1"},"12":{"value":"Dept2"},"13":{"value":"Dept3"},"14":{"value":"CostCategory"},"15":{"value":"Employee grade"},"16":{"value":"D/ID"},"17":{"value":"D/I/E"},"18":{"value":"Salary grade"},"19":{"value":"Month1"},"20":{"value":"Month2"},"21":{"value":"Month3"},"22":{"value":"Month4"},"23":{"value":"Month5"},"24":{"value":"Month6"},"25":{"value":"Month7"},"26":{"value":"Month8"},"27":{"value":"Month9"},"28":{"value":"Month10"},"29":{"value":"Month11"},"30":{"value":"Month12"},"31":{"value":"Year Avg"},"32":{"value":"D/I"},"33":{"value":"Comment"},"34":{"value":"Szh State"},"35":{"value":"Szh Avg"},"36":{"value":"Wujin State"},"37":{"value":"Wujin Avg"},"38":{"value":"State Year T"},"39":{"value":"Avg Year T"},"40":{"value":"CreateUser"}},"1":{"1":{"value":23369},"2":{"value":"N"},"3":{"value":"2018-10-31 00:00:00"},"4":{"value":"2019"},"5":{"value":"HC_CF02"},"6":{"value":"RBAC"},"7":{"value":"Regular"},"8":{"value":"369800"},"9":{"value":"AE General  Administration"},"10":{"value":"Jiawei Zhu"},"11":{"value":"MG"},"12":{"value":"MG"},"13":{"value":"MG"},"14":{"value":"WVK"},"15":{"value":"Direct worker 1"},"16":{"value":"Direct"},"17":{"value":"Direct"},"18":{"value":"1"},"19":{"value":0},"20":{"value":0},"21":{"value":0},"22":{"value":0},"23":{"value":0},"24":{"value":0},"25":{"value":0},"26":{"value":0},"27":{"value":0},"28":{"value":0},"29":{"value":0},"30":{"value":0},"31":{"value":0},"32":{"value":"D"},"33":{"value":""},"34":{"value":0},"35":{"value":0},"36":{"value":0},"37":{"value":0},"38":{"value":0},"39":{"value":0},"40":{"value":"ZIJ7SZH"}},"2":{"1":{"value":23370},"2":{"value":"N"},"3":{"value":"2018-10-31 00:00:00"},"4":{"value":"2019"},"5":{"value":"HC_CF02"},"6":{"value":"RBAC"},"7":{"value":"Regular"},"8":{"value":"369800"},"9":{"value":"AE General  Administration"},"10":{"value":"Jiawei Zhu"},"11":{"value":"MG"},"12":{"value":"MG"},"13":{"value":"MG"},"14":{"value":"WVK"},"15":{"value":"Direct worker 1"},"16":{"value":"Direct"},"17":{"value":"Direct"},"18":{"value":"2"},"19":{"value":0},"20":{"value":0},"21":{"value":0},"22":{"value":0},"23":{"value":0},"24":{"value":0},"25":{"value":0},"26":{"value":0},"27":{"value":0},"28":{"value":0},"29":{"value":0},"30":{"value":0},"31":{"value":0},"32":{"value":"D"},"33":{"value":""},"34":{"value":0},"35":{"value":0},"36":{"value":0},"37":{"value":0},"38":{"value":0},"39":{"value":0},"40":{"value":"ZIJ7SZH"}},"3":{"1":{"value":23371},"2":{"value":"N"},"3":{"value":"2018-10-31 00:00:00"},"4":{"value":"2019"},"5":{"value":"HC_CF02"},"6":{"value":"RBAC"},"7":{"value":"Regular"},"8":{"value":"369800"},"9":{"value":"AE General  Administration"},"10":{"value":"Jiawei Zhu"},"11":{"value":"MG"},"12":{"value":"MG"},"13":{"value":"MG"},"14":{"value":"WVK"},"15":{"value":"Direct worker 1"},"16":{"value":"Direct"},"17":{"value":"Direct"},"18":{"value":"3"},"19":{"value":0},"20":{"value":0},"21":{"value":0},"22":{"value":0},"23":{"value":0},"24":{"value":0},"25":{"value":0},"26":{"value":0},"27":{"value":0},"28":{"value":0},"29":{"value":0},"30":{"value":0},"31":{"value":0},"32":{"value":"D"},"33":{"value":""},"34":{"value":0},"35":{"value":0},"36":{"value":0},"37":{"value":0},"38":{"value":0},"39":{"value":0},"40":{"value":"ZIJ7SZH"}},"4":{"1":{"value":23372},"2":{"value":"N"},"3":{"value":"2018-10-31 00:00:00"},"4":{"value":"2019"},"5":{"value":"HC_CF02"},"6":{"value":"RBAC"},"7":{"value":"Regular"},"8":{"value":"369800"},"9":{"value":"AE General  Administration"},"10":{"value":"Jiawei Zhu"},"11":{"value":"MG"},"12":{"value":"MG"},"13":{"value":"MG"},"14":{"value":"WVK"},"15":{"value":"Direct worker 2"},"16":{"value":"Direct"},"17":{"value":"Direct"},"18":{"value":"4"},"19":{"value":0},"20":{"value":0},"21":{"value":0},"22":{"value":0},"23":{"value":0},"24":{"value":0},"25":{"value":0},"26":{"value":0},"27":{"value":0},"28":{"value":0},"29":{"value":0},"30":{"value":0},"31":{"value":0},"32":{"value":"D"},"33":{"value":""},"34":{"value":0},"35":{"value":0},"36":{"value":0},"37":{"value":0},"38":{"value":0},"39":{"value":0},"40":{"value":"ZIJ7SZH"}},"5":{"1":{"value":23373},"2":{"value":"N"},"3":{"value":"2018-10-31 00:00:00"},"4":{"value":"2019"},"5":{"value":"HC_CF02"},"6":{"value":"RBAC"},"7":{"value":"Regular"},"8":{"value":"369800"},"9":{"value":"AE General  Administration"},"10":{"value":"Jiawei Zhu"},"11":{"value":"MG"},"12":{"value":"MG"},"13":{"value":"MG"},"14":{"value":"WVK"},"15":{"value":"Direct worker 2"},"16":{"value":"Direct"},"17":{"value":"Direct"},"18":{"value":"5"},"19":{"value":0},"20":{"value":0},"21":{"value":0},"22":{"value":0},"23":{"value":0},"24":{"value":0},"25":{"value":0},"26":{"value":0},"27":{"value":0},"28":{"value":0},"29":{"value":0},"30":{"value":0},"31":{"value":0},"32":{"value":"D"},"33":{"value":""},"34":{"value":0},"35":{"value":0},"36":{"value":0},"37":{"value":0},"38":{"value":0},"39":{"value":0},"40":{"value":"ZIJ7SZH"}},"6":{"1":{"value":23374},"2":{"value":"N"},"3":{"value":"2018-10-31 00:00:00"},"4":{"value":"2019"},"5":{"value":"HC_CF02"},"6":{"value":"RBAC"},"7":{"value":"Regular"},"8":{"value":"369800"},"9":{"value":"AE General  Administration"},"10":{"value":"Jiawei Zhu"},"11":{"value":"MG"},"12":{"value":"MG"},"13":{"value":"MG"},"14":{"value":"WVK"},"15":{"value":"Direct Staff"},"16":{"value":"Direct"},"17":{"value":"Direct"},"18":{"value":"6"},"19":{"value":0},"20":{"value":0},"21":{"value":0},"22":{"value":0},"23":{"value":0},"24":{"value":0},"25":{"value":0},"26":{"value":0},"27":{"value":0},"28":{"value":0},"29":{"value":0},"30":{"value":0},"31":{"value":0},"32":{"value":"D"},"33":{"value":""},"34":{"value":0},"35":{"value":0},"36":{"value":0},"37":{"value":0},"38":{"value":0},"39":{"value":0},"40":{"value":"ZIJ7SZH"}},"7":{"1":{"value":23375},"2":{"value":"N"},"3":{"value":"2018-10-31 00:00:00"},"4":{"value":"2019"},"5":{"value":"HC_CF02"},"6":{"value":"RBAC"},"7":{"value":"Regular"},"8":{"value":"369800"},"9":{"value":"AE General  Administration"},"10":{"value":"Jiawei Zhu"},"11":{"value":"MG"},"12":{"value":"MG"},"13":{"value":"MG"},"14":{"value":"WVK"},"15":{"value":"Direct Professionals"},"16":{"value":"Direct"},"17":{"value":"Direct"},"18":{"value":"7"},"19":{"value":0},"20":{"value":0},"21":{"value":0},"22":{"value":0},"23":{"value":0},"24":{"value":0},"25":{"value":0},"26":{"value":0},"27":{"value":0},"28":{"value":0},"29":{"value":0},"30":{"value":0},"31":{"value":0},"32":{"value":"D"},"33":{"value":""},"34":{"value":0},"35":{"value":0},"36":{"value":0},"37":{"value":0},"38":{"value":0},"39":{"value":0},"40":{"value":"ZIJ7SZH"}},"8":{"1":{"value":23376},"2":{"value":"N"},"3":{"value":"2018-10-31 00:00:00"},"4":{"value":"2019"},"5":{"value":"HC_CF02"},"6":{"value":"RBAC"},"7":{"value":"Regular"},"8":{"value":"369800"},"9":{"value":"AE General  Administration"},"10":{"value":"Jiawei Zhu"},"11":{"value":"MG"},"12":{"value":"MG"},"13":{"value":"MG"},"14":{"value":"WVK"},"15":{"value":"Direct Senior Staff"},"16":{"value":"Direct"},"17":{"value":"Direct"},"18":{"value":"8"},"19":{"value":0},"20":{"value":0},"21":{"value":0},"22":{"value":0},"23":{"value":0},"24":{"value":0},"25":{"value":0},"26":{"value":0},"27":{"value":0},"28":{"value":0},"29":{"value":0},"30":{"value":0},"31":{"value":0},"32":{"value":"D"},"33":{"value":""},"34":{"value":0},"35":{"value":0},"36":{"value":0},"37":{"value":0},"38":{"value":0},"39":{"value":0},"40":{"value":"ZIJ7SZH"}},"9":{"1":{"value":23377},"2":{"value":"N"},"3":{"value":"2018-10-31 00:00:00"},"4":{"value":"2019"},"5":{"value":"HC_CF02"},"6":{"value":"RBAC"},"7":{"value":"Regular"},"8":{"value":"369800"},"9":{"value":"AE General  Administration"},"10":{"value":"Jiawei Zhu"},"11":{"value":"MG"},"12":{"value":"MG"},"13":{"value":"MG"},"14":{"value":"WVK"},"15":{"value":"Direct Senior Staff"},"16":{"value":"Direct"},"17":{"value":"Direct"},"18":{"value":"9"},"19":{"value":0},"20":{"value":0},"21":{"value":0},"22":{"value":0},"23":{"value":0},"24":{"value":0},"25":{"value":0},"26":{"value":0},"27":{"value":0},"28":{"value":0},"29":{"value":0},"30":{"value":0},"31":{"value":0},"32":{"value":"D"},"33":{"value":""},"34":{"value":0},"35":{"value":0},"36":{"value":0},"37":{"value":0},"38":{"value":0},"39":{"value":0},"40":{"value":"ZIJ7SZH"}},"10":{"1":{"value":23378},"2":{"value":"N"},"3":{"value":"2018-10-31 00:00:00"},"4":{"value":"2019"},"5":{"value":"HC_CF02"},"6":{"value":"RBAC"},"7":{"value":"Regular"},"8":{"value":"369800"},"9":{"value":"AE General  Administration"},"10":{"value":"Jiawei Zhu"},"11":{"value":"MG"},"12":{"value":"MG"},"13":{"value":"MG"},"14":{"value":"WVK"},"15":{"value":"Indirect worker"},"16":{"value":"Indirect"},"17":{"value":"Indirect"},"18":{"value":"1"},"19":{"value":0},"20":{"value":0},"21":{"value":0},"22":{"value":0},"23":{"value":0},"24":{"value":0},"25":{"value":0},"26":{"value":0},"27":{"value":0},"28":{"value":0},"29":{"value":0},"30":{"value":0},"31":{"value":0},"32":{"value":"I"},"33":{"value":""},"34":{"value":0},"35":{"value":0},"36":{"value":0},"37":{"value":0},"38":{"value":0},"39":{"value":0},"40":{"value":"ZIJ7SZH"}},"11":{"1":{"value":23379},"2":{"value":"N"},"3":{"value":"2018-10-31 00:00:00"},"4":{"value":"2019"},"5":{"value":"HC_CF02"},"6":{"value":"RBAC"},"7":{"value":"Regular"},"8":{"value":"369800"},"9":{"value":"AE General  Administration"},"10":{"value":"Jiawei Zhu"},"11":{"value":"MG"},"12":{"value":"MG"},"13":{"value":"MG"},"14":{"value":"WVK"},"15":{"value":"Indirect worker"},"16":{"value":"Indirect"},"17":{"value":"Indirect"},"18":{"value":"2"},"19":{"value":0},"20":{"value":0},"21":{"value":0},"22":{"value":0},"23":{"value":0},"24":{"value":0},"25":{"value":0},"26":{"value":0},"27":{"value":0},"28":{"value":0},"29":{"value":0},"30":{"value":0},"31":{"value":0},"32":{"value":"I"},"33":{"value":""},"34":{"value":0},"35":{"value":0},"36":{"value":0},"37":{"value":0},"38":{"value":0},"39":{"value":0},"40":{"value":"ZIJ7SZH"}},"12":{"1":{"value":23380},"2":{"value":"N"},"3":{"value":"2018-10-31 00:00:00"},"4":{"value":"2019"},"5":{"value":"HC_CF02"},"6":{"value":"RBAC"},"7":{"value":"Regular"},"8":{"value":"369800"},"9":{"value":"AE General  Administration"},"10":{"value":"Jiawei Zhu"},"11":{"value":"MG"},"12":{"value":"MG"},"13":{"value":"MG"},"14":{"value":"WVK"},"15":{"value":"Indirect worker"},"16":{"value":"Indirect"},"17":{"value":"Indirect"},"18":{"value":"3"},"19":{"value":0},"20":{"value":0},"21":{"value":0},"22":{"value":0},"23":{"value":0},"24":{"value":0},"25":{"value":0},"26":{"value":0},"27":{"value":0},"28":{"value":0},"29":{"value":0},"30":{"value":0},"31":{"value":0},"32":{"value":"I"},"33":{"value":""},"34":{"value":0},"35":{"value":0},"36":{"value":0},"37":{"value":0},"38":{"value":0},"39":{"value":0},"40":{"value":"ZIJ7SZH"}},"13":{"1":{"value":23381},"2":{"value":"N"},"3":{"value":"2018-10-31 00:00:00"},"4":{"value":"2019"},"5":{"value":"HC_CF02"},"6":{"value":"RBAC"},"7":{"value":"Regular"},"8":{"value":"369800"},"9":{"value":"AE General  Administration"},"10":{"value":"Jiawei Zhu"},"11":{"value":"MG"},"12":{"value":"MG"},"13":{"value":"MG"},"14":{"value":"WVK"},"15":{"value":"Indirect worker"},"16":{"value":"Indirect"},"17":{"value":"Indirect"},"18":{"value":"4"},"19":{"value":0},"20":{"value":0},"21":{"value":0},"22":{"value":0},"23":{"value":0},"24":{"value":0},"25":{"value":0},"26":{"value":0},"27":{"value":0},"28":{"value":0},"29":{"value":0},"30":{"value":0},"31":{"value":0},"32":{"value":"I"},"33":{"value":""},"34":{"value":0},"35":{"value":0},"36":{"value":0},"37":{"value":0},"38":{"value":0},"39":{"value":0},"40":{"value":"ZIJ7SZH"}},"14":{"1":{"value":23382},"2":{"value":"N"},"3":{"value":"2018-10-31 00:00:00"},"4":{"value":"2019"},"5":{"value":"HC_CF02"},"6":{"value":"RBAC"},"7":{"value":"Regular"},"8":{"value":"369800"},"9":{"value":"AE General  Administration"},"10":{"value":"Jiawei Zhu"},"11":{"value":"MG"},"12":{"value":"MG"},"13":{"value":"MG"},"14":{"value":"WVK"},"15":{"value":"Indirect worker"},"16":{"value":"Indirect"},"17":{"value":"Indirect"},"18":{"value":"5"},"19":{"value":0},"20":{"value":0},"21":{"value":0},"22":{"value":0},"23":{"value":0},"24":{"value":0},"25":{"value":0},"26":{"value":0},"27":{"value":0},"28":{"value":0},"29":{"value":0},"30":{"value":0},"31":{"value":0},"32":{"value":"I"},"33":{"value":""},"34":{"value":0},"35":{"value":0},"36":{"value":0},"37":{"value":0},"38":{"value":0},"39":{"value":0},"40":{"value":"ZIJ7SZH"}},"15":{"1":{"value":23383},"2":{"value":"N"},"3":{"value":"2018-10-31 00:00:00"},"4":{"value":"2019"},"5":{"value":"HC_CF02"},"6":{"value":"RBAC"},"7":{"value":"Regular"},"8":{"value":"369800"},"9":{"value":"AE General  Administration"},"10":{"value":"Jiawei Zhu"},"11":{"value":"MG"},"12":{"value":"MG"},"13":{"value":"MG"},"14":{"value":"WVK"},"15":{"value":"General staff"},"16":{"value":"Indirect"},"17":{"value":"Indirect"},"18":{"value":"6"},"19":{"value":0},"20":{"value":0},"21":{"value":0},"22":{"value":0},"23":{"value":0},"24":{"value":0},"25":{"value":0},"26":{"value":0},"27":{"value":0},"28":{"value":0},"29":{"value":0},"30":{"value":0},"31":{"value":0},"32":{"value":"I"},"33":{"value":""},"34":{"value":0},"35":{"value":0},"36":{"value":0},"37":{"value":0},"38":{"value":0},"39":{"value":0},"40":{"value":"ZIJ7SZH"}},"16":{"1":{"value":23384},"2":{"value":"N"},"3":{"value":"2018-10-31 00:00:00"},"4":{"value":"2019"},"5":{"value":"HC_CF02"},"6":{"value":"RBAC"},"7":{"value":"Regular"},"8":{"value":"369800"},"9":{"value":"AE General  Administration"},"10":{"value":"Jiawei Zhu"},"11":{"value":"MG"},"12":{"value":"MG"},"13":{"value":"MG"},"14":{"value":"WVK"},"15":{"value":"Professionals"},"16":{"value":"Indirect"},"17":{"value":"Indirect"},"18":{"value":"7"},"19":{"value":0},"20":{"value":0},"21":{"value":0},"22":{"value":0},"23":{"value":0},"24":{"value":0},"25":{"value":0},"26":{"value":0},"27":{"value":0},"28":{"value":0},"29":{"value":0},"30":{"value":0},"31":{"value":0},"32":{"value":"I"},"33":{"value":""},"34":{"value":0},"35":{"value":0},"36":{"value":0},"37":{"value":0},"38":{"value":0},"39":{"value":0},"40":{"value":"ZIJ7SZH"}},"17":{"1":{"value":23385},"2":{"value":"N"},"3":{"value":"2018-10-31 00:00:00"},"4":{"value":"2019"},"5":{"value":"HC_CF02"},"6":{"value":"RBAC"},"7":{"value":"Regular"},"8":{"value":"369800"},"9":{"value":"AE General  Administration"},"10":{"value":"Jiawei Zhu"},"11":{"value":"MG"},"12":{"value":"MG"},"13":{"value":"MG"},"14":{"value":"WVK"},"15":{"value":"Senior Staff"},"16":{"value":"Indirect"},"17":{"value":"Indirect"},"18":{"value":"8"},"19":{"value":0},"20":{"value":0},"21":{"value":0},"22":{"value":0},"23":{"value":0},"24":{"value":0},"25":{"value":0},"26":{"value":0},"27":{"value":0},"28":{"value":0},"29":{"value":0},"30":{"value":0},"31":{"value":0},"32":{"value":"I"},"33":{"value":""},"34":{"value":0},"35":{"value":0},"36":{"value":0},"37":{"value":0},"38":{"value":0},"39":{"value":0},"40":{"value":"ZIJ7SZH"}},"18":{"1":{"value":23386},"2":{"value":"N"},"3":{"value":"2018-10-31 00:00:00"},"4":{"value":"2019"},"5":{"value":"HC_CF02"},"6":{"value":"RBAC"},"7":{"value":"Regular"},"8":{"value":"369800"},"9":{"value":"AE General  Administration"},"10":{"value":"Jiawei Zhu"},"11":{"value":"MG"},"12":{"value":"MG"},"13":{"value":"MG"},"14":{"value":"WVK"},"15":{"value":"Section Manager"},"16":{"value":"Indirect"},"17":{"value":"Indirect"},"18":{"value":"9"},"19":{"value":0},"20":{"value":0},"21":{"value":0},"22":{"value":0},"23":{"value":0},"24":{"value":0},"25":{"value":0},"26":{"value":0},"27":{"value":0},"28":{"value":0},"29":{"value":0},"30":{"value":0},"31":{"value":0},"32":{"value":"I"},"33":{"value":""},"34":{"value":0},"35":{"value":0},"36":{"value":0},"37":{"value":0},"38":{"value":0},"39":{"value":0},"40":{"value":"ZIJ7SZH"}},"19":{"1":{"value":23387},"2":{"value":"N"},"3":{"value":"2018-10-31 00:00:00"},"4":{"value":"2019"},"5":{"value":"HC_CF02"},"6":{"value":"RBAC"},"7":{"value":"Regular"},"8":{"value":"369800"},"9":{"value":"AE General  Administration"},"10":{"value":"Jiawei Zhu"},"11":{"value":"MG"},"12":{"value":"MG"},"13":{"value":"MG"},"14":{"value":"WVK"},"15":{"value":"Department Manager"},"16":{"value":"Indirect"},"17":{"value":"Indirect"},"18":{"value":"10"},"19":{"value":0},"20":{"value":0},"21":{"value":0},"22":{"value":0},"23":{"value":0},"24":{"value":0},"25":{"value":0},"26":{"value":0},"27":{"value":0},"28":{"value":0},"29":{"value":0},"30":{"value":0},"31":{"value":0},"32":{"value":"I"},"33":{"value":""},"34":{"value":0},"35":{"value":0},"36":{"value":0},"37":{"value":0},"38":{"value":0},"39":{"value":0},"40":{"value":"ZIJ7SZH"}},"20":{"1":{"value":23388},"2":{"value":"N"},"3":{"value":"2018-10-31 00:00:00"},"4":{"value":"2019"},"5":{"value":"HC_CF02"},"6":{"value":"RBAC"},"7":{"value":"Regular"},"8":{"value":"369800"},"9":{"value":"AE General  Administration"},"10":{"value":"Jiawei Zhu"},"11":{"value":"MG"},"12":{"value":"MG"},"13":{"value":"MG"},"14":{"value":"WVK"},"15":{"value":"Department Director"},"16":{"value":"Indirect"},"17":{"value":"Indirect"},"18":{"value":"11"},"19":{"value":0},"20":{"value":0},"21":{"value":0},"22":{"value":0},"23":{"value":0},"24":{"value":0},"25":{"value":0},"26":{"value":0},"27":{"value":0},"28":{"value":0},"29":{"value":0},"30":{"value":0},"31":{"value":0},"32":{"value":"I"},"33":{"value":""},"34":{"value":0},"35":{"value":0},"36":{"value":0},"37":{"value":0},"38":{"value":0},"39":{"value":0},"40":{"value":"ZIJ7SZH"}},"21":{"1":{"value":23389},"2":{"value":"N"},"3":{"value":"2018-10-31 00:00:00"},"4":{"value":"2019"},"5":{"value":"HC_CF02"},"6":{"value":"RBAC"},"7":{"value":"Regular"},"8":{"value":"369800"},"9":{"value":"AE General  Administration"},"10":{"value":"Jiawei Zhu"},"11":{"value":"MG"},"12":{"value":"MG"},"13":{"value":"MG"},"14":{"value":"WVK"},"15":{"value":"Department Director"},"16":{"value":"Indirect"},"17":{"value":"Indirect"},"18":{"value":"12"},"19":{"value":0},"20":{"value":0},"21":{"value":0},"22":{"value":0},"23":{"value":0},"24":{"value":0},"25":{"value":0},"26":{"value":0},"27":{"value":0},"28":{"value":0},"29":{"value":0},"30":{"value":0},"31":{"value":0},"32":{"value":"I"},"33":{"value":""},"34":{"value":0},"35":{"value":0},"36":{"value":0},"37":{"value":0},"38":{"value":0},"39":{"value":0},"40":{"value":"ZIJ7SZH"}},"22":{"1":{"value":23390},"2":{"value":"N"},"3":{"value":"2018-10-31 00:00:00"},"4":{"value":"2019"},"5":{"value":"HC_CF02"},"6":{"value":"RBAC"},"7":{"value":"Regular"},"8":{"value":"369800"},"9":{"value":"AE General  Administration"},"10":{"value":"Jiawei Zhu"},"11":{"value":"MG"},"12":{"value":"MG"},"13":{"value":"MG"},"14":{"value":"WVK"},"15":{"value":"Expats"},"16":{"value":"Indirect"},"17":{"value":"Expats"},"18":{"value":"VN"},"19":{"value":0},"20":{"value":0},"21":{"value":0},"22":{"value":0},"23":{"value":0},"24":{"value":0},"25":{"value":0},"26":{"value":0},"27":{"value":0},"28":{"value":0},"29":{"value":0},"30":{"value":0},"31":{"value":0},"32":{"value":"I"},"33":{"value":""},"34":{"value":0},"35":{"value":0},"36":{"value":0},"37":{"value":0},"38":{"value":0},"39":{"value":0},"40":{"value":"ZIJ7SZH"}},"23":{"1":{"value":23391},"2":{"value":"N"},"3":{"value":"2018-10-31 00:00:00"},"4":{"value":"2019"},"5":{"value":"HC_CF02"},"6":{"value":"RBAC"},"7":{"value":"Regular"},"8":{"value":"369800"},"9":{"value":"AE General  Administration"},"10":{"value":"Jiawei Zhu"},"11":{"value":"MG"},"12":{"value":"MG"},"13":{"value":"MG"},"14":{"value":"WVK"},"15":{"value":"Expats"},"16":{"value":"Indirect"},"17":{"value":"Expats"},"18":{"value":"VA"},"19":{"value":0},"20":{"value":0},"21":{"value":0},"22":{"value":0},"23":{"value":0},"24":{"value":0},"25":{"value":0},"26":{"value":0},"27":{"value":0},"28":{"value":0},"29":{"value":0},"30":{"value":0},"31":{"value":0},"32":{"value":"I"},"33":{"value":""},"34":{"value":0},"35":{"value":0},"36":{"value":0},"37":{"value":0},"38":{"value":0},"39":{"value":0},"40":{"value":"ZIJ7SZH"}},"24":{"1":{"value":23392},"2":{"value":"N"},"3":{"value":"2018-10-31 00:00:00"},"4":{"value":"2019"},"5":{"value":"HC_CF02"},"6":{"value":"RBAC"},"7":{"value":"Leasing"},"8":{"value":"369800"},"9":{"value":"AE General  Administration"},"10":{"value":"Jiawei Zhu"},"11":{"value":"MG"},"12":{"value":"MG"},"13":{"value":"MG"},"14":{"value":"WVK"},"15":{"value":"NA"},"16":{"value":"L Direct"},"17":{"value":"L Direct"},"18":{"value":"NA"},"19":{"value":0},"20":{"value":0},"21":{"value":0},"22":{"value":0},"23":{"value":0},"24":{"value":0},"25":{"value":0},"26":{"value":0},"27":{"value":0},"28":{"value":0},"29":{"value":0},"30":{"value":0},"31":{"value":0},"32":{"value":"D"},"33":{"value":""},"34":{"value":0},"35":{"value":0},"36":{"value":0},"37":{"value":0},"38":{"value":0},"39":{"value":0},"40":{"value":"ZIJ7SZH"}},"25":{"1":{"value":23393},"2":{"value":"N"},"3":{"value":"2018-10-31 00:00:00"},"4":{"value":"2019"},"5":{"value":"HC_CF02"},"6":{"value":"RBAC"},"7":{"value":"Leasing"},"8":{"value":"369800"},"9":{"value":"AE General  Administration"},"10":{"value":"Jiawei Zhu"},"11":{"value":"MG"},"12":{"value":"MG"},"13":{"value":"MG"},"14":{"value":"WVK"},"15":{"value":"NA"},"16":{"value":"L Indirect"},"17":{"value":"L Indirect"},"18":{"value":"NA"},"19":{"value":0},"20":{"value":0},"21":{"value":0},"22":{"value":0},"23":{"value":0},"24":{"value":0},"25":{"value":0},"26":{"value":0},"27":{"value":0},"28":{"value":0},"29":{"value":0},"30":{"value":0},"31":{"value":0},"32":{"value":"I"},"33":{"value":""},"34":{"value":0},"35":{"value":0},"36":{"value":0},"37":{"value":0},"38":{"value":0},"39":{"value":0},"40":{"value":"ZIJ7SZH"}},"26":{"1":{"value":23394},"2":{"value":"N"},"3":{"value":"2018-10-31 00:00:00"},"4":{"value":"2019"},"5":{"value":"HC_CF02"},"6":{"value":"RBAC"},"7":{"value":"Intern"},"8":{"value":"369800"},"9":{"value":"AE General  Administration"},"10":{"value":"Jiawei Zhu"},"11":{"value":"MG"},"12":{"value":"MG"},"13":{"value":"MG"},"14":{"value":"WVK"},"15":{"value":"NA"},"16":{"value":"I Direct"},"17":{"value":"I Direct"},"18":{"value":"NA"},"19":{"value":0},"20":{"value":0},"21":{"value":0},"22":{"value":0},"23":{"value":0},"24":{"value":0},"25":{"value":0},"26":{"value":0},"27":{"value":0},"28":{"value":0},"29":{"value":0},"30":{"value":0},"31":{"value":0},"32":{"value":"D"},"33":{"value":""},"34":{"value":0},"35":{"value":0},"36":{"value":0},"37":{"value":0},"38":{"value":0},"39":{"value":0},"40":{"value":"ZIJ7SZH"}},"27":{"1":{"value":23395},"2":{"value":"N"},"3":{"value":"2018-10-31 00:00:00"},"4":{"value":"2019"},"5":{"value":"HC_CF02"},"6":{"value":"RBAC"},"7":{"value":"Intern"},"8":{"value":"369800"},"9":{"value":"AE General  Administration"},"10":{"value":"Jiawei Zhu"},"11":{"value":"MG"},"12":{"value":"MG"},"13":{"value":"MG"},"14":{"value":"WVK"},"15":{"value":"NA"},"16":{"value":"I Indirect"},"17":{"value":"I Indirect"},"18":{"value":"NA"},"19":{"value":0},"20":{"value":0},"21":{"value":0},"22":{"value":0},"23":{"value":0},"24":{"value":0},"25":{"value":0},"26":{"value":0},"27":{"value":0},"28":{"value":0},"29":{"value":0},"30":{"value":0},"31":{"value":0},"32":{"value":"I"},"33":{"value":""},"34":{"value":0},"35":{"value":0},"36":{"value":0},"37":{"value":0},"38":{"value":0},"39":{"value":0},"40":{"value":"ZIJ7SZH"}}}},"rowHeaderData":{},"colHeaderData":{},"rows":[{"size":50}],"columns":[null,{"name":"Id","size":100,"visible":false},{"name":"Status","size":50,"visible":true},{"name":"Deadline","size":300,"visible":true},{"name":"Tyear","size":40,"visible":false},{"name":"Sheet","size":100,"visible":false},{"name":"Entity","size":50},{"name":"R_l_i","size":50},{"name":"Costcenter","size":70},{"name":"Description","size":100},{"name":"Createname","size":70},{"name":"Dept1","size":70},{"name":"Dept2","size":70},{"name":"Dept3","size":70},{"name":"Costcategory","size":80},{"name":"Employeegrade","size":100},{"name":"D_id","size":50},{"name":"D_i_e","size":50},{"name":"Salarygrade","size":30},{"name":"Month1","size":45},{"name":"Month2","size":45},{"name":"Month3","size":45},{"name":"Month4","size":45},{"name":"Month5","size":45},{"name":"Month6","size":45},{"name":"Month7","size":45},{"name":"Month8","size":45},{"name":"Month9","size":45},{"name":"Month10","size":45},{"name":"Month11","size":45},{"name":"Month12","size":45},{"name":"Yavg","size":50},{"name":"D_i","size":30},{"name":"Comment","size":120},{"name":"Szhstate","size":50},{"name":"Szhavg","size":50},{"name":"Wujinstate","size":50},{"name":"Wujinavg","size":50},{"name":"Tstate","size":50},{"name":"Tavg","size":50},{"name":"Createuser","size":50,"visible":false}],"colHeaderRowInfos":[{"size":50}],"selections":{"0":{"row":0,"rowCount":1,"col":0,"colCount":1},"length":1},"defaults":{"colHeaderRowHeight":20,"colWidth":62,"rowHeaderColWidth":40,"rowHeight":25},"autoGenerateColumns":false,"showRowOutline":false,"isProtected":true,"protectionOptions":{"allowFilter":true,"allowSort":true,"allowResizeRows":true,"allowResizeColumns":true,"allowEditObjects":false,"allowDragInsertRows":false,"allowDragInsertColumns":false,"allowInsertRows":false,"allowInsertColumns":false,"allowDeleteRows":false,"allowDeleteColumns":false},"sheetAreaOffset":{"left":0,"top":0,"_left":0,"_top":0},"index":0}}}"
回复 使用道具 举报
yhjsbok
注册会员   /  发表于：2018-11-12 13:18:42
6#
KevinChen 发表于 2018-11-12 11:32
spread.toJSON不需要序列化成字符串，我的代码如下：

        function ExportFile() {
   
            var fileName = "Headcount.xlsx";
            var serializationOption = {
                ignoreFormula: true, // indicate to ignore the style when convert workbook to json, default value is false
                ignoreStyle: true, // indicate to ignore the formula when convert workbook to json, default value is false
                rowHeadersAsFrozenColumns: true, // indicate to treat the row headers as frozen columns when convert workbook to json, default value is false
                columnHeadersAsFrozenRows: true, // indicate to treat the column headers as frozen rows when convert workbook to json, default value is false
                includeBindingSource: true
            }

            var json =spread.toJSON(serializationOption);
            var excelIO = new GC.Spread.Excel.IO();
            excelIO.save(json, function (blob) {
                saveAs(blob, fileName);
            }, function (e) {
                console.log(e);
            });


            //var json = spread.toJSON({ includeBindingSource: true, columnHeadersAsFrozenRows: true });
            //alert(JSON.stringify(json));
            //var excelIO = new GC.Spread.Excel.IO();
            //excelIO.save(json, function (blob) {
            //    saveAs(blob, fileName);
            //}, function (e) {
            //    console.log(e);
            //});
        }
回复 使用道具 举报
KevinChen讲师达人认证 悬赏达人认证 SpreadJS 开发认证
论坛元老   /  发表于：2018-11-12 13:20:03
7#
你好，抱歉问题1没有给您提供完整的格式。

问题1，单元格格式设置为：[=0]"-";General
回复 使用道具 举报
KevinChen讲师达人认证 悬赏达人认证 SpreadJS 开发认证
论坛元老   /  发表于：2018-11-12 13:45:51
8#
问题2，你贴出来的json串，前后各多了一个双引号。

1、如果后台拿到的json是个字符串，而不是一个对象，那就调用JSON.parse(json字符串)，这样来将字符串格式的json转为json对象；

2、你贴出来的字符串，前后都是双引号，内部也是双引号，这样格式就是错误的。前后换成是单引号之后，再调用JSON.parse()；

如果还有问题，可以继续留言，在线给你处理。
回复 使用道具 举报
Clark.Pan讲师达人认证 悬赏达人认证 SpreadJS 开发认证
超级版主   /  发表于：2018-11-12 14:10:35
9#
我看了一下，问题跟我同事说的一样，字符串的引用不能存在双引号嵌套双引号的用法，如果要改，可以将外面的双引号改为单引号，并且我看了一下json数据其中已经序列化出了表格中的值，所以我猜测您的问题应该是上述地方导致的，您按照我们说的解决办法试一下，如果还有问题咱们继续进行沟通。
点击查看 -->【预览版体验】SpreadJS v16.0 预览版 - 新文件结构
回复 使用道具 举报
KevinChen讲师达人认证 悬赏达人认证 SpreadJS 开发认证
论坛元老   /  发表于：2018-11-12 15:02:09
10#
您好，我这边给您做了一个Demo，演示了如何设置表单保护，同时控制导出Excel文件中一部分区域为保护状态，一部分区域可编辑。

请下载附件的html文件，修改文件中引用的依赖为您本地包的路径即可运行。

Protection.html

8.63 KB, 下载次数: 180
回复 使用道具 举报
下一页 »
12下一页
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 立即注册
产品与服务
活字格低代码平台
Wyn 商业智能软件
SpreadJS纯前端表格控件
技术服务体系
技术博客
低代码技术
客户与案例
典型客户
成功案例
用户访谈
合作与生态
合作伙伴网络
葡萄城市场
葡萄城与国产化
活字格用友客开工具
品牌活动
葡萄城公开课
品牌战略发布会
赋能开发者高峰论坛
企业级低代码发展研讨会
企业级低代码应用大赛
表格技术研讨会
了解葡萄城
葡萄城简介
愿景使命
研发与创新
荣誉奖项
加入我们
联系方式
联系我们
400-657-6008

葡萄城社区二维码

关注“葡萄城社区”

赋能开发者

西安葡萄城软件有限公司
专业的软件开发技术和低代码平台提供商

陕ICP备2020018819号  |   陕公网安备：61019002000258  |   隐私政策  |   网站地图  

邮箱： info.xa@grapecity.com  |  © 2024 葡萄城软件，保留所有权利

Archiver| 手机版| 小黑屋|

返回顶部