lundi 16 décembre 2019

Unable to write the Column Header Names of database query results to excel using apache poi

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.

enter image description here

Aucun commentaire:

Enregistrer un commentaire