【SpreadJS】designer 无法导出json

Ellia.Duan

本帖最后由 Lynn.Dou 于 2023-1-20 09:07 编辑

http://127.0.0.1:9000/testputao/ ... obanshouye/add.html (代码地址)
报错是（add.html:76 Uncaught SyntaxError: Invalid regular expression flags (at add.html:76:38)）

1;designer 实例无法导出json (想通过designer 实例在线编辑模板保存到数据库里，相反也可以从数据库调出json再一次更改)

2；designer 导入之后无法获取数据，比如加载后完成后给一个setValue(0,0,1000) 1000这个值无法显示到 designer 里

Ellia.Duan · Ellia.Duan

量传发表于 2023-1-17 10:23

这边不太清楚php如何启动，在浏览器打开add.html后报引用错误，所以将相关引用代码重写了下，如下图所示：
image.png678509826.png

然后打开页面，点击”保存“是可以正常打印json的，没有报错
image.png585395202.png

下面的代码时相关引用，您看下是否有遗漏

<link href="http://cdn.grapecity.com/spreadjs/hosted/css/gc.spread.sheets.excel2013white.15.2.2.css"
rel="stylesheet" type="text/css"/>
<link href="http://cdn.grapecity.com/spreadjs/hosted/css/gc.spread.sheets.designer.15.2.2.min.css" rel="stylesheet"
type="text/css"/>
<script src="http://cdn.grapecity.com/spreadjs/hosted/scripts/gc.spread.sheets.all.15.2.2.min.js"></script>
<script
src="http://cdn.grapecity.com/spreadjs/hosted/scripts/plugins/gc.spread.sheets.charts.15.2.2.min.js"></script>
<script
src="http://cdn.grapecity.com/spreadjs/hosted/scripts/plugins/gc.spread.sheets.shapes.15.2.2.min.js"></script>
<script
src="http://cdn.grapecity.com/spreadjs/hosted/scripts/plugins/gc.spread.sheets.print.15.2.2.min.js"></script>
<script
src="http://cdn.grapecity.com/spreadjs/hosted/scripts/plugins/gc.spread.sheets.barcode.15.2.2.min.js"></script>
<script src="http://cdn.grapecity.com/spreadjs/hosted/scripts/plugins/gc.spread.sheets.pdf.15.2.2.min.js"></script>
<script
src="http://cdn.grapecity.com/spreadjs/hosted/scripts/plugins/gc.spread.pivot.pivottables.15.2.2.min.js"></script>
<script src="http://cdn.grapecity.com/spreadjs/hosted/scripts/interop/gc.spread.excelio.15.2.2.min.js"></script>
<script
src="http://cdn.grapecity.com/spreadjs/hosted/scripts/resources/zh/gc.spread.sheets.resources.zh.15.2.2.min.js"></script>
<script src="http://cdn.grapecity.com/spreadjs/hosted/scripts/gc.spread.sheets.designer.resource.cn.15.2.2.min.js"></script>
<script src="http://cdn.grapecity.com/spreadjs/hosted/scripts/gc.spread.sheets.designer.all.15.2.2.min.js"></script>

复制代码

Ellia.Duan · Ellia.Duan

首先您在execute方法中可以通过下图方式获取Spread
image.png496963500.png

其次这边下载您的代码后，发现您这边是php项目，想确认下是不是通过下面图片中的文件来复现您的问题
image.png39064330.png

量传 · 量传

依然报错 Uncaught SyntaxError: Invalid regular expression flags (at add.html:72:38)
var designer = new GC.Spread.Sheets.Designer.Designer(document.getElementById("ss"));
var workbook = designer.getWorkbook();
var sheet = workbook.getActiveSheet();
var config = GC.Spread.Sheets.Designer.DefaultConfig;
config.commandMap = {
save: {
title: "保存",
text: '保存',
iconClass: "img",
bigButton: "true",
commandName: "函数",
execute: function (context){
let spread=context.Spread;
var jsonString = JSON.stringify(spread.toJSON({includeBindingSource: true}));
console.log(jsonString)
}
},
}