activeSheet.tables找不到属性

Clark.Pan

var activeSheet = spread.getActiveSheet();

复制代码

error Error: The tables cannot be intersected.
在react中 workbookInitialized 后，获取到当前sheet，然后没有tables对象吗?
想给表格模板加数据源一直不行！

Clark.Pan · Clark.Pan

看了一下，有两个问题
1.是模板的问题，看下图：
这里模板上设置的bindingpath是table
那么people中的user也要改为table，table和user必须保持一致的，要么在模板定义时就把table改为user，要么就该数据源把user改为table
2.后续加载模板后不用再重新代码创建table了，因为模板已经设置过了，直接执行setDataSource即可。
我把代码改了一下，已经没问题了，您参考看一下

var spread = new GC.Spread.Sheets.Workbook(document.getElementById("ss"));
var tableData = {"version":"14.2.5","font":"12pt Arial","customList":[],"sheetCount":1,"sheets":{"Sheet1":{"name":"Sheet1","isSelected":true,"activeRow":11,"activeCol":3,"frozenTrailingRowStickToEdge":true,"frozenTrailingColumnStickToEdge":true,"theme":"Office2007","data":{"defaultDataNode":{"style":{"themeFont":"Body"}},"dataTable":{}},"rowHeaderData":{"defaultDataNode":{"style":{"themeFont":"Body"}}},"colHeaderData":{"defaultDataNode":{"style":{"themeFont":"Body"}}},"leftCellIndex":0,"topCellIndex":0,"selections":{"0":{"row":11,"rowCount":1,"col":3,"colCount":1},"length":1},"rowOutlines":{"items":[]},"columnOutlines":{"items":[]},"cellStates":{},"states":{},"outlineColumnOptions":{},"autoMergeRangeInfos":[],"printInfo":{"paperSize":{"width":850,"height":1100,"kind":1}},"tables":[{"name":"gcTable0","row":5,"col":3,"rowCount":2,"colCount":2,"style":{"buildInName":"Medium2"},"autoGenerateColumns":false,"bindingPath":"table","rowFilter":{"range":{"row":6,"rowCount":1,"col":3,"colCount":2},"typeName":"HideRowFilter","dialogVisibleInfo":{},"filterButtonVisibleInfo":{"0":true,"1":true},"showFilterButton":true},"columns":[{"id":0,"name":"name","dataField":"name"},{"id":1,"name":"age","dataField":"age"}]}],"shapeCollectionOption":{"snapMode":0},"index":0}}};
spread.fromJSON(tableData)
var activeSheet = spread.getActiveSheet();
/*测试数据源 */
var people = {
table: [
{name: "yaojia", age: 40, },
{name: "lili", age: 22 , },
{name: "coco", age: 222 , }
]}
var source = new GC.Spread.Sheets.Bindings.CellBindingSource(people)
activeSheet.setDataSource(source)

复制代码

Clark.Pan · Clark.Pan

The tables cannot be intersected.
上面是说工作表中的表格可能存在相交
也就是对应类似下面这种情况
image.png110426024.png

如上图所示如果我要在选中范围内插入一个table，Excel中插入table的按钮会灰掉
image.png826882934.png

因为table之间允许相交，您那个提示也是一样的问题，因为SpreadJS是代码控制没有界面，所以会有报错提示

红叶舞秋山 · 红叶舞秋山

非常感谢原理知道呢。

红叶舞秋山 · 红叶舞秋山

使用designer设计器提前设备了一个模板绑定好了表格数据源。

然后显示的时候想在模板数据源位置显示表格数据。但是失败了。

以下是代码：
tabledata是designer设计器导出的包含表格数据源绑定的模板数据。
people 是需要加载的数据源。

const workbookInitialized = (spread : any) =>{
var tableData = {"version":"14.2.5","font":"12pt Arial","customList":[],"sheetCount":1,"sheets":{"Sheet1":{"name":"Sheet1","isSelected":true,"activeRow":11,"activeCol":3,"frozenTrailingRowStickToEdge":true,"frozenTrailingColumnStickToEdge":true,"theme":"Office2007","data":{"defaultDataNode":{"style":{"themeFont":"Body"}},"dataTable":{}},"rowHeaderData":{"defaultDataNode":{"style":{"themeFont":"Body"}}},"colHeaderData":{"defaultDataNode":{"style":{"themeFont":"Body"}}},"leftCellIndex":0,"topCellIndex":0,"selections":{"0":{"row":11,"rowCount":1,"col":3,"colCount":1},"length":1},"rowOutlines":{"items":[]},"columnOutlines":{"items":[]},"cellStates":{},"states":{},"outlineColumnOptions":{},"autoMergeRangeInfos":[],"printInfo":{"paperSize":{"width":850,"height":1100,"kind":1}},"tables":[{"name":"gcTable0","row":5,"col":3,"rowCount":2,"colCount":2,"style":{"buildInName":"Medium2"},"autoGenerateColumns":false,"bindingPath":"table","rowFilter":{"range":{"row":6,"rowCount":1,"col":3,"colCount":2},"typeName":"HideRowFilter","dialogVisibleInfo":{},"filterButtonVisibleInfo":{"0":true,"1":true},"showFilterButton":true},"columns":[{"id":0,"name":"name","dataField":"name"},{"id":1,"name":"age","dataField":"age"}]}],"shapeCollectionOption":{"snapMode":0},"index":0}}};
spread.fromJSON(tableData)
var activeSheet = spread.getActiveSheet();
var table = activeSheet.tables.add('myTable',4,6,3,3);
table.bindingPath('user');
/*测试数据源 */
var people = {
user: [
{name: "yaojia", age: 40, },
{name: "lili", age: 22 , },
{name: "coco", age: 222 , }
]}
var source = new GC.Spread.Sheets.Bindings.CellBindingSource(people)
activeSheet.setDataSource(source)

复制代码

红叶舞秋山 · 红叶舞秋山

Clark.Pan 发表于 2022-2-8 18:34
The tables cannot be intersected.
上面是说工作表中的表格可能存在相交
也就是对应类似下面这种情况

帮看看哈谢谢谢谢

红叶舞秋山 · 红叶舞秋山

神！！解决！看来只看文档是不够的

Lynn.Dou · Lynn.Dou

，那本帖就先结贴了，有问题欢迎另开新帖交流。

		自动登录	找回密码
密码			立即注册

[已处理] activeSheet.tables找不到属性

最佳答案

7 个回复

讲师达人

悬赏达人

微信认证勋章

SpreadJS 认证

SpreadJS 高级认证

元老葡萄