activeSheet.tables找不到属性

1. var activeSheet = spread.getActiveSheet();

复制代码

error Error: The tables cannot be intersected.

在react中 workbookInitialized 后， 获取到当前sheet，然后没有tables对象吗?

想给表格模板加数据源 一直不行！

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

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

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

帮看看哈 谢谢 谢谢

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

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

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

1. const workbookInitialized = (spread : any) =>{
   
2.      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}}};
   
3. 
   
4.       
   
5.      spread.fromJSON(tableData)
   
6. 
   
7.       var activeSheet = spread.getActiveSheet();
   
8. 
   
9.       var table = activeSheet.tables.add('myTable',4,6,3,3);
   
10. 
    
11.       table.bindingPath('user');
    
12. 
    
13.      /*测试数据源 */
    
14.       var people = {
    
15.         user: [
    
16.         {name: "yaojia", age: 40, },
    
17.         {name: "lili", age: 22 , },
    
18.         {name: "coco", age: 222 , }
    
19. 
    
20.     ]}
    
21. 
    
22.     var source = new GC.Spread.Sheets.Bindings.CellBindingSource(people)
    
23. 
    
24.     activeSheet.setDataSource(source)

复制代码

非常感谢 原理知道呢。

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

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

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

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

1. var spread = new GC.Spread.Sheets.Workbook(document.getElementById("ss"));
   
2. 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}}};
   
3. spread.fromJSON(tableData)
   
4. var activeSheet = spread.getActiveSheet();
   
5. /*测试数据源 */
   
6. var people = {
   
7.     table: [
   
8.     {name: "yaojia", age: 40, },
   
9.     {name: "lili", age: 22 , },
   
10.     {name: "coco", age: 222 , }
    
11. 
    
12. ]}
    
13. 
    
14. var source = new GC.Spread.Sheets.Bindings.CellBindingSource(people)
    
15. 
    
16. activeSheet.setDataSource(source)

复制代码