// Create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); //Set worksheet tab color. worksheet.setTabColor(Color.GetGreen()); //Set worksheet default row height. worksheet.setStandardHeight(20); //Set worksheet default column width. worksheet.setStandardWidth(50); //Split worksheet to panes. worksheet.splitPanes(worksheet.getRange("B3").getRow(), worksheet.getRange("B3").getColumn()); IWorksheet worksheet1 = workbook.getWorksheets().add(); //Hide worksheet. worksheet1.setVisible(Visibility.Hidden); // Save to an excel file workbook.save("ConfigWorksheet.xlsx");
// Create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) //Set worksheet tab color. worksheet.tabColor = Color.GetGreen() //Set worksheet default row height. worksheet.standardHeight = 20.0 //Set worksheet default column width. worksheet.standardWidth = 50.0 //Split worksheet to panes. worksheet.splitPanes(worksheet.getRange("B3").row, worksheet.getRange("B3").column) val worksheet1 = workbook.worksheets.add() //Hide worksheet. worksheet1.visible = Visibility.Hidden // Save to an excel file workbook.save("ConfigWorksheet.xlsx")