...
后续有调整电子表格样式,需要根据实际情况去调整代码。
代码块 |
---|
function main(spreadsheetReport) { //ccce var options = Packages.com.aspose.cells.AutoFitterOptions(); var posList1 = spreadsheetReport.sheets[0].getExpandedPositions("A5"); var posList2 = spreadsheetReport.sheets[0].getExpandedPositions("A9"); var posList3 = spreadsheetReport.sheets[0].getExpandedPositions("A24"); var posList4 = spreadsheetReport.sheets[0].getExpandedPositions("A28"); for(var i=0;i<posList1.length;i++){ var pos = posList1[i]; spreadsheetReport.workbook.worksheets.get(0).autoFitRow(pos.row); } for(var i=0;i<posList2.length;i++){ var pos = posList2[i]; spreadsheetReport.workbook.worksheets.get(0).autoFitRow(pos.row); } for(var i=0;i<posList3.length;i++){ var pos = posList3[i]; spreadsheetReport.workbook.worksheets.get(0).autoFitRow(pos.row); } for(var i=0;i<posList4.length;i++){ var pos = posList4[i]; spreadsheetReport.workbook.worksheets.get(0).autoFitRow(pos.row); } } |
...