登录/注册

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

8 主题	27 帖子	184 积分

积分: 184

2203
金币
8
主题
27
帖子

最新发帖

[已处理] V12版本导出EXCEL报错@潘工，10，11的版本正常

yhjsbok
注册会员 / 发表于：2018-12-14 09:43 / 查看：3491 / 回复：6

      function ExportFile() {
         //$("form")[0].submit();
         var fileName = "CostCenterData.xlsx";
         var json = spread.toJSON({ includeBindingSource: true, columnHeadersAsFrozenRows: true });
         var excelIO = new GC.Spread.Excel.IO();
         excelIO.save(json, function (blob) {
            saveAs(blob, fileName);
         }, function (e) {
            console.log(e);
         });
      }

{"version":"12.0.3","newTabVisible":false,"grayAreaBackColor":"white","sheets":{"Sheet1":{"name":"Sheet1","rowCount":2,"columnCount":17,"activeCol":4,"frozenRowCount":1,"theme":"Office2007","data":{"dataTable":{"0":{"0":{"value":"Id"},"1":{"value":"Dept1"},"2":{"value":"Dept2"},"3":{"value":"Dept3"},"4":{"value":"CostCenter"},"5":{"value":"Description"},"6":{"value":"DeptName"},"7":{"value":"Resp.person"},"8":{"value":"HoD"},"9":{"value":"Resp.CTG"},"10":{"value":"Resp.CTGname"},"11":{"value":"ProfitCenter"},"12":{"value":"CostCategory1"},"13":{"value":"CostCategory2"},"14":{"value":"CostCenterWujin"},"15":{"value":"Percentage1"},"16":{"value":"Percentage2"}},"1":{"0":{"value":1,"style":{"borderLeft":{"color":"red","style":4},"borderTop":{"color":"red","style":4},"borderRight":{"color":"red","style":4},"borderBottom":{"color":"red","style":4},"locked":false}},"1":{"value":"MG","style":{"borderLeft":{"color":"red","style":4},"borderTop":{"color":"red","style":4},"borderRight":{"color":"red","style":4},"borderBottom":{"color":"red","style":4},"locked":false}},"2":{"value":"MG","style":{"borderLeft":{"color":"red","style":4},"borderTop":{"color":"red","style":4},"borderRight":{"color":"red","style":4},"borderBottom":{"color":"red","style":4},"locked":false}},"3":{"value":"MG","style":{"borderLeft":{"color":"red","style":4},"borderTop":{"color":"red","style":4},"borderRight":{"color":"red","style":4},"borderBottom":{"color":"red","style":4},"locked":false}},"4":{"value":"369800","style":{"borderLeft":{"color":"red","style":4},"borderTop":{"color":"red","style":4},"borderRight":{"color":"red","style":4},"borderBottom":{"color":"red","style":4},"locked":false}},"5":{"value":"AE General  Administration","style":{"borderLeft":{"color":"red","style":4},"borderTop":{"color":"red","style":4},"borderRight":{"color":"red","style":4},"borderBottom":{"color":"red","style":4},"locked":false}},"6":{"value":"AE/MG-CN","style":{"borderLeft":{"color":"red","style":4},"borderTop":{"color":"red","style":4},"borderRight":{"color":"red","style":4},"borderBottom":{"color":"red","style":4},"locked":false}},"7":{"value":"ZIJ7SZH","style":{"borderLeft":{"color":"red","style":4},"borderTop":{"color":"red","style":4},"borderRight":{"color":"red","style":4},"borderBottom":{"color":"red","style":4},"locked":false}},"8":{"value":"ADMIN","style":{"borderLeft":{"color":"red","style":4},"borderTop":{"color":"red","style":4},"borderRight":{"color":"red","style":4},"borderBottom":{"color":"red","style":4},"locked":false}},"9":{"value":"CTG3","style":{"borderLeft":{"color":"red","style":4},"borderTop":{"color":"red","style":4},"borderRight":{"color":"red","style":4},"borderBottom":{"color":"red","style":4},"locked":false}},"10":{"value":"ADMIN","style":{"borderLeft":{"color":"red","style":4},"borderTop":{"color":"red","style":4},"borderRight":{"color":"red","style":4},"borderBottom":{"color":"red","style":4},"locked":false}},"11":{"value":"Y06901","style":{"borderLeft":{"color":"red","style":4},"borderTop":{"color":"red","style":4},"borderRight":{"color":"red","style":4},"borderBottom":{"color":"red","style":4},"locked":false}},"12":{"value":"WVK","style":{"borderLeft":{"color":"red","style":4},"borderTop":{"color":"red","style":4},"borderRight":{"color":"red","style":4},"borderBottom":{"color":"red","style":4},"locked":false}},"13":{"value":" ","style":{"borderLeft":{"color":"red","style":4},"borderTop":{"color":"red","style":4},"borderRight":{"color":"red","style":4},"borderBottom":{"color":"red","style":4},"locked":false}},"14":{"value":"","style":{"borderLeft":{"color":"red","style":4},"borderTop":{"color":"red","style":4},"borderRight":{"color":"red","style":4},"borderBottom":{"color":"red","style":4},"locked":false}},"15":{"value":1,"style":{"formatter":"0.00","borderLeft":{"color":"red","style":4},"borderTop":{"color":"red","style":4},"borderRight":{"color":"red","style":4},"borderBottom":{"color":"red","style":4},"locked":false}},"16":{"value":0,"style":{"formatter":"0.00"},"formula":"1-P2"}}},"rowDataArray":[{"style":{"backColor":"#87CEFA","hAlign":1,"vAlign":1,"borderLeft":{"color":"grey","style":7},"borderTop":{"color":"grey","style":7},"borderRight":{"color":"grey","style":7},"borderBottom":{"color":"grey","style":7},"wordWrap":true}}],"columnDataArray":[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"style":{"backColor":"#F5F5F5"}}],"defaultDataNode":{"style":{"themeFont":"Body"}}},"rowHeaderData":{"defaultDataNode":{"style":{"themeFont":"Body"}}},"colHeaderData":{},"rows":[{"size":50}],"columns":[{"name":"Id","size":100,"visible":false},{"name":"Dept1","size":100},{"name":"Dept2","size":100},{"name":"Dept3","size":100},{"name":"Costcenter","size":100},{"name":"Description","size":100},{"name":"Deptname","size":100},{"name":"Empnobp18","size":80},{"name":"Hod","size":80},{"name":"Ctg","size":50},{"name":"Ctgowner","size":80},{"name":"Profitcenter","size":70},{"name":"Costcategory1","size":65},{"name":"Costcategory2","size":65},{"name":"Costcenterwujin","size":80},{"name":"Percentage1","size":50},{"name":"Percentage2","size":50}],"colHeaderRowInfos":[{"size":50}],"selections":{"0":{"row":0,"rowCount":1,"col":4,"colCount":1},"length":1},"defaults":{"colHeaderRowHeight":20,"colWidth":62,"rowHeaderColWidth":40,"rowHeight":25},"autoGenerateColumns":false,"showRowOutline":false,"rowFilter":{"range":{"row":-1,"rowCount":-1,"col":0,"colCount":17},"typeName":"HideRowFilter","dialogVisibleInfo":{},"filterButtonVisibleInfo":{"0":true,"1":true,"2":true,"3":true,"4":true,"5":true,"6":true,"7":true,"8":true,"9":true,"10":true,"11":true,"12":true,"13":true,"14":true,"15":true,"16":true},"showFilterButton":true},"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},"index":0}}}

收藏

回复

6 个回复

倒序浏览

Clark.Pan
超级版主 / 发表于：2018-12-14 10:34:20 沙发

您好，我这边用微软最新的Excel测试导出没有发现问题
附件是导出之后的Excel，请确认一下您的Excel版本是否为最新

7.82 KB, 下载次数: 114

点击查看 -->【预览版体验】SpreadJS v16.0 预览版 - 新文件结构

回复 使用道具举报

yhjsbok
注册会员 / 发表于：2018-12-14 15:44:39 板凳

ClarkPan 发表于 2018-12-14 10:34
您好，我这边用微软最新的Excel测试导出没有发现问题
附件是导出之后的Excel，请确认一下您的Excel版本是 ...

我excel 是2010的,不会是excel版本的问题吧，那是客户端都要换成最新版的excel，那不实际

回复 使用道具举报

Clark.Pan
超级版主 / 发表于：2018-12-14 16:47:11 地板

我们导出的策略肯定是要兼容最新的Excel，您这种问题很可能是Excel自身的BUG，Excel新版本修复了这样的问题。建议您可以用新版本，以获得更好的体验

点击查看 -->【预览版体验】SpreadJS v16.0 预览版 - 新文件结构

回复 使用道具举报

yhjsbok
注册会员 / 发表于：2018-12-15 10:25:07 5^#

ClarkPan 发表于 2018-12-14 16:47
我们导出的策略肯定是要兼容最新的Excel，您这种问题很可能是Excel自身的BUG，Excel新版本修复了这样的问题 ...

我找到原因了：是我的列增加了筛选。我筛选去掉就不报这个错，有办法在导出excel的时候把这个筛选的格式去掉吗？spread.toJSON({ includeBindingSource: true, columnHeadersAsFrozenRows: true });  可以增加筛选属性吗？

      function ExportFile() {
         //$("form")[0].submit();
         var fileName = "CostElementData.xlsx";
         var json = spread.toJSON({ includeBindingSource: true, columnHeadersAsFrozenRows: true });
         var excelIO = new GC.Spread.Excel.IO();
         excelIO.save(json, function (blob) {
            saveAs(blob, fileName);
         }, function (e) {
            console.log(e);
         });
      }

sheet.rowFilter(new GC.Spread.Sheets.Filter.HideRowFilter(new GC.Spread.Sheets.Range(-1, 0, -1, colcount)));

回复 使用道具举报

yhjsbok
注册会员 / 发表于：2018-12-17 11:12:17 7^#

KevinChen 发表于 2018-12-17 10:41
很高兴问题解决了，本帖我结贴了。

还不能结案呢？
我筛选去掉就不报这个错，有办法在导出excel的时候把这个筛选的格式去掉吗？spread.toJSON({ includeBindingSource: true, columnHeadersAsFrozenRows: true }); 可以增加筛选属性吗？

回复 使用道具举报

Clark.Pan
超级版主 / 发表于：2018-12-17 11:52:35 8^#

1.导出之前获取rowfilter对象，然后调用rowfilter.reset(); 清空筛选，然后再导出，导出之后再按照之前的方法添加回筛选，让页面与之前保持一致
2.重新初始化一个spread，但不绑定div，这样这个spread是一个隐藏的spread对象，页面不会显示出来，通过spread.toJSON 和spread.fromJSON将之前spread的内容拷贝到隐藏的这个spread对象上，然后通过rowfilter.reset(); 清空这个隐藏的spread对象中的rowfilter，最后导出这个隐藏的spread对象，页面显示的是另外一个spread对象，两者不产生任何影响

点击查看 -->【预览版体验】SpreadJS v16.0 预览版 - 新文件结构

回复 使用道具举报