//create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); //set row height for row 1:2. worksheet.getRange("1:2").setRowHeight(50); //set column width for column C:D. worksheet.getRange("C:D").setColumnWidth(20); //save to an excel file workbook.save("SetRowHeightColumnWidth.xlsx");
//create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) //set row height for row 1:2. worksheet.getRange("1:2").rowHeight = 50.0 //set column width for column C:D. worksheet.getRange("C:D").columnWidth = 20.0 //save to an excel file workbook.save("SetRowHeightColumnWidth.xlsx")