Exporting Variable Number of columns from query into excel

Question

I am trying to write the output of a complex query into Excel. For this I am using JDBC and created a function of return type 'ResultSet' through which I'll be getting the output of the Query.

To write the ResultSet Rows into excel, I should do like below:

        HSSFRow row = firstSheet.createRow(index);
    row.createCell(0).setCellValue(rs.getInt(1));
    row.createCell(1).setCellValue(rs.getInt(2));
    row.createCell(2).setCellValue(rs.getString(2));
    row.createCell(3).setCellValue(rs.getString(3));

Now The issue is, the resultset of the complex query includes variable number of rows and columns depending upon the date we run the query which need to be exported to excel. Is there any feasible approach through programming I can handle this situation and export the query result into an excel.

Thanks in advance.

Alepac · Accepted Answer · 2013-04-12 14:02:19Z

2

You should use ResultSet.getMetaData() method and, for example, iterate for ResultSetMetaData.getColumnCount() times.

answered Apr 12, 2013 at 14:02

Alepac

1,84313 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Exporting Variable Number of columns from query into excel

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related