通过以下代码将数据绑定到文件中,但是有些数据需要折行、居中怎么设置
- var tablescus = spreadsheet.tables.all();
- if(tablescus){
- for(var i=0;i<tablescus.length;i++){
- tablescus[i].expandBoundRows(true);
- }
- }
- spreadsheet.setDataSource(new GC.Spread.Sheets.Bindings.CellBindingSource(reportData.tableList));
- spreadsheet.autoGenerateColumns = true;
- if(tablescus){
- for(var i=0;i<tablescus.length;i++){
- copyTableStyle(spreadsheet,tablescus[i]);
- var meageCol = reportData.tableList[tablescus[i].UZ+"_MERAGECOL"];
- if(meageCol){
- var colArr = meageCol.split(",");
- for(var j=0;j<colArr.length;j++){
- var range = new GC.Spread.Sheets.Range(tablescus[i].xr.range.row, parseInt(colArr[j]), tablescus[i].xr.range.rowCount, 1);
- spanbycolumn(range,spreadSheet);
- }
- }
- }
- }
复制代码
目前效果如下图所示:
求大佬帮忙
|