// Create a new workbook Workbook workbook = new Workbook(); ITableDataSource datasource = new MyTableDataSource(this.getResourceStream("score.csv")); IWorksheet worksheet = workbook.getWorksheets().get(0); // Set AutoGenerateColumns as false worksheet.setAutoGenerateColumns(false); // Bind columns manually. worksheet.getRange("A:A").getEntireColumn().setBindingPath("ID"); worksheet.getRange("B:B").getEntireColumn().setBindingPath("Name"); worksheet.getRange("C:C").getEntireColumn().setBindingPath("Score"); worksheet.getRange("D:D").getEntireColumn().setBindingPath("Team"); // Set data source worksheet.setDataSource(datasource); // Save to an excel file workbook.save("BindResultSet.xlsx");