Spire.XLS for Java supports to create and format the table on Excel file. This article will show you how to create a simple table by the range of data from an existing worksheet.
Firstly, view the sample Excel worksheet:
mport com.spire.xls.*; public class CreateTable { public static void main(String[] args) throws Exception { String inputFile = "Sample1.xlsx"; String outputFile = "output/CreateTable.xlsx"; //Create a workbook and load a file Workbook workbook = new Workbook(); workbook.loadFromFile(inputFile); //Get the first worksheet. Worksheet sheet = workbook.getWorksheets().get(0); //Create table with the data in given range sheet.getListObjects().create("table", sheet.getCellRange(1, 1, 13, 4)); //Add Default Style to the table. sheet.getListObjects().get(0).setBuiltInTableStyle(TableBuiltInStyles.TableStyleLight9); //Save the Excel file workbook.saveToFile(outputFile, ExcelVersion.Version2010); } }
Effective screenshot after creating the Excel table: