代码上增加了两列隐藏列,然后做表格
excelIO.open(this.excelFile, function (json) {
self.spread.fromJSON(json)
const data = [{ ID: 'FP752', Name: '零件名称FP752', N0: '92', N1: '82'},
{ ID: 'FP752', Name: '零件名称FP752', N0: '0.3', N1: '0.4' },
{ ID: 'FP753', Name: '零件名称FP753', N0: '55', N1: '66' },
{ ID: 'FP753', Name: '零件名称FP753', N0: '0.5', N1: '1.4' }]
var sheet = spread.getSheetFromName('DataSource')
if (sheet) {
sheet.setDataSource(data)
}
// 增加两列隐藏列,用于做切片器的表格
const columnCount = sheet.getColumnCount();
sheet.addColumns(columnCount + 1, 2);
sheet.setColumnVisible(columnCount,false,GC.Spread.Sheets.SheetArea.viewport);
sheet.setColumnVisible(columnCount + 1,false,GC.Spread.Sheets.SheetArea.viewport);
// create table
var table = sheet.tables.add('tableItems', 4, 21, 1, 2);
table.allowAutoExpand(true);
var tableColumn1 = new GC.Spread.Sheets.Tables.TableColumn(1, "buffModel", "缓冲管理模式");
var tableColumn2 = new GC.Spread.Sheets.Tables.TableColumn(2, "bufferConfig", "缓冲配置");
table.autoGenerateColumns(false);
var data = {};
data.items = {items:[{buffModel:'1',bufferConfig:"2"},{buffModel:'3',bufferConfig:"4"}]};
table.bind([tableColumn1, tableColumn2], 'items', data);
}) |