您好，可以先设置行高
- for (let i = 0; i < rowCount; i++) {
- sheet.setRowHeight(i, 40)
- }
- for (let r = 0; r < rowCount; r++) {
- var instance = new GC.Spread.Sheets.CellTypes.Text();
- var returnValue = instance.getAutoFitHeight(
- sheet.getValue(r, 3),
- sheet.getText(r, 3),
- sheet.getActualStyle(r, 3),
- sheet.zoom(),
- {"sheet": sheet, "row": r, "col": 3, "sheetArea": GC.Spread.Sheets.SheetArea.viewport});
- if (returnValue > 40) {
- sheet.autoFitRow(r);
- }
- }
|
