我没太看明白你这个意思。我是后台返回的数据，直接就给赋值的。
let items = JSON.parse(JSON.stringify(data[item]))
let table1 = sheet.tables.findByName(tables[0].name)
table1.autoGenerateColumns(false);
if (items && items.length == 0) {
let sorce = new GC.Spread.Sheets.Bindings.CellBindingSource(items)
sheet.setDataSource(sorce)
return
}
const columns = tables[0].columns;
let newColums = [];
columns.forEach(k => {
let dataField = k.dataField.match(reg);
newColums.push({
field: dataField[dataField.length - 1],//处理之后的字段
dataField: k.dataField//execl中绑定的字段
})
})
let echoData = {}
for (let j in items) {
echoData[j] = []
items[j].forEach(ss => {
let obj = {}
for (let v in ss) {
let field = newColums.filter(kk => {
return kk.field == v
})
if (field && field.length > 0) {
obj[field[0].dataField] = ss[v]
}
}
echoData[j].push(obj)
})
}
let sorce = new GC.Spread.Sheets.Bindings.CellBindingSource(echoData)
table1.expandBoundRows(true)
sheet.setDataSource(sorce)
this.copyTableStyle(sheet,table1)
代码是这样的，您帮我看一下我要怎么改呢 |
