I am able to write the database query results successfully into the excel sheet using Apache poi, but the issue is it's not writing the column header names.
I am not sure what am i missing.
below is the code
Workbook book = new HSSFWorkbook();
Sheet bwfDemographicSheet = book.createSheet("ACA_Stage_Demographic_Table");
Row headerRow = bwfDemographicSheet.createRow(0);
Cell payrollfile_IdHeaderCell = headerRow.createCell(0);
Cell file_IdHeaderCell = headerRow.createCell(1);
Sheet bwfEmployeeMasterSheet = book.createSheet("ACA_EmployeeMaster_Table");
Row headerRow1 = bwfEmployeeMasterSheet.createRow(0);
Cell EmpCountHeaderCell = headerRow1.createCell(0);
rs = statement.executeQuery(ACA_Stage_Demographic);
int row = 1;
while (rs.next()) {
int PayrollFile_ID= rs.getInt("PayrollFile_ID");
int File_ID= rs.getInt("File_ID");
System.out.println("Before the Demographic Weekly Feed File Import And Process,Values Of PayrollFile_ID AND FILE_ID Of DEMOGARPHIC Table :" + PayrollFile_ID+"\t"+File_ID);
Row dataRow = bwfDemographicSheet.createRow(row);
Cell dataPayrollFILE_IDCell = dataRow.createCell(0);
dataPayrollFILE_IDCell.setCellValue(PayrollFile_ID);
Cell dataFILE_IDCell = dataRow.createCell(1);
dataFILE_IDCell.setCellValue(File_ID);
// row = row + 1;
}
Below is the screenshot of the Excel sheet.

Aucun commentaire:
Enregistrer un commentaire