// Create a new workbook Workbook workbook = new Workbook(); //add table. IWorksheet worksheet = workbook.getWorksheets().get(0); ITable table = worksheet.getTables().add(worksheet.getRange("A1:F7"), true); worksheet.getRange("A:F").setColumnWidth(15); //Add one custom table style. ITableStyle style = workbook.getTableStyles().add("test"); //set custom table style for table. table.setTableStyle(style); //Use table style name get one build in table style. ITableStyle tableStyle = workbook.getTableStyles().get("TableStyleMedium3"); //set built-in table style for table. table.setTableStyle(tableStyle); // Save to an excel file workbook.save("ApplyTableStyle.xlsx");
// Create a new workbook var workbook = Workbook() //add table. val worksheet = workbook.worksheets.get(0) val table = worksheet.tables.add(worksheet.getRange("A1:F7"), true) worksheet.getRange("A:F").columnWidth = 15.0 //Add one custom table style. val style = workbook.tableStyles.add("test") //set custom table style for table. table.tableStyle = style //Use table style name get one build in table style. val tableStyle = workbook.tableStyles.get("TableStyleMedium3") //set built-in table style for table. table.tableStyle = tableStyle // Save to an excel file workbook.save("ApplyTableStyle.xlsx")