Page 2 - How to export data from servlet to excel file through poi lib

Dev Shed Forums Sponsor:

#16

November 13th, 2012, 09:18 AM

bullet

Java Junkie

Join Date: Jan 2004

Location: Mobile, Alabama

Posts: 3,828

Time spent in forums: 1 Month 1 Week 6 Days 11 h 21 m 4 sec
Reputation Power: 1248

Quote:

Originally Posted by nicholas.omosa

yes i do

In this part of your code

Code:

FileOutputStream fileOut = new FileOutputStream("c:\\excelFile.xls");
wb.write(fileOut);
fileOut.close();
out.println("Data is saved in excel file.");
con.close();
conn.close();
System.out.println("Disconnected from database");
} catch (Exception e) {
}
}

did you also put a print statement in the catch block?

#17

November 13th, 2012, 09:22 AM

nicholas.omosa

Contributing User

Join Date: Nov 2012

Posts: 34

Time spent in forums: 4 h 44 m 5 sec
Reputation Power: 1

Quote:

Originally Posted by bullet

In this part of your code

Code:

FileOutputStream fileOut = new FileOutputStream("c:\\excelFile.xls");
wb.write(fileOut);
fileOut.close();
out.println("Data is saved in excel file.");
con.close();
conn.close();
System.out.println("Disconnected from database");
} catch (Exception e) {
}
}

did you also put a print statement in the catch block?

i dont think i did how do you do that ?

#18

November 13th, 2012, 09:24 AM

stdunbar

Contributing User

Join Date: May 2004

Location: Superior, CO, USA

Posts: 2,399

Time spent in forums: 1 Month 2 Weeks 18 h 26 m 27 sec
Reputation Power: 1660

Send a message via Google Talk to stdunbar

I don't understand your issue. In the code you show you're doing nothing but getting a database connection. If you want some output then you have to actually output something. I would totally expect a blank page from the code you showed.

__________________
Need Java help? Want to help people who do? Sit down with a cup of Java at the hotjoe forums.

#19

November 13th, 2012, 09:35 AM

nicholas.omosa

Contributing User

Join Date: Nov 2012

Posts: 34

Time spent in forums: 4 h 44 m 5 sec
Reputation Power: 1

Quote:

Originally Posted by stdunbar

good, now i think we are on the same page..so how do i get the output?

#20

November 13th, 2012, 09:37 AM

bullet

Java Junkie

Join Date: Jan 2004

Location: Mobile, Alabama

Posts: 3,828

Time spent in forums: 1 Month 1 Week 6 Days 11 h 21 m 4 sec
Reputation Power: 1248

Quote:

Originally Posted by nicholas.omosa

good, now i think we are on the same page..so how do i get the output?

I'm confused. I was under the impression that you were demonstrating in the post with the smaller amount of code that you had modified the original servlet so you could display the exceptions. Did you only have the new code as the servlet? In that case, I agree with stdunbar that it won't do anything.

#21

November 13th, 2012, 09:40 AM

nicholas.omosa

Contributing User

Join Date: Nov 2012

Posts: 34

Time spent in forums: 4 h 44 m 5 sec
Reputation Power: 1

Quote:

Originally Posted by bullet

ok bullet and stdunbar..how do i print the output put of my query?

#22

November 13th, 2012, 09:43 AM

bullet

Java Junkie

Join Date: Jan 2004

Location: Mobile, Alabama

Posts: 3,828

Time spent in forums: 1 Month 1 Week 6 Days 11 h 21 m 4 sec
Reputation Power: 1248

Quote:

Originally Posted by nicholas.omosa

ok bullet and stdunbar..how do i print the output put of my query?

If you use a simple System.out.println it should show up in the log file or if you use out.println it should show up on the screen. (Assuming you have create a PrintWriter called out.)

Comments on this post

stdunbar agrees!

Page 2 - How to export data from servlet to excel file through poi lib

Developer Shed Advertisers and Affiliates