Dowloading a Table as a csv File

[Javoso Torso]

Hello:

In a JSF app, I am trying to find the best way to download a (HTML)table to the client as a CSV file (to be open with excel for example).

Any ideas?

Thanks!
Javo

[John Smith]

Parse the table to output a comma delimited list name.csv, when excel saves it back to that file it will be in the correct excel format.

if you're doing it through struts you can have it as a link pointing to an action containing the following:

StringBuffer disp = new StringBuffer(javax.mail.Part.ATTACHMENT).append("; filename=\"");
disp.append(REPORT_NAME).append(".csv\"");
response.setHeader("Content-Disposition", disp.toString ());
response.setContentType("application/ms-excel");                              
OutputStream out = response.getOutputStream();
String data = "order_id,date,name,email,amount,status\n";
byte [] b = data.getBytes();
out.write(b);
 
// for example
while (outputtingLines) {
    out.write("value1, value2, value3, value4");
}
 

This will create a file with your data and send it to the browser which will automatically deal with it by popping up a download box or displaying if the client has an excel plug-in installed, hope this is what you were after

[Javoso Torso]

Thanks!

I would really like to test that.
But I am using JavaServer Faces...

What is the parallel to "response" in JavaServer Faces?

Regs,
javoso
[ December 13, 2004: Message edited by: Javoso Torso ]

[Javoso Torso]

:

FacesContext.getExternalContext().getResponse();

?
[ December 13, 2004: Message edited by: Javoso Torso ]

[Manish Hatwalne]

You might want to try JExcel API as well.

HTH,
- Manish

[Javoso Torso]

Thank you,

I am giving Apache POI a try!

Rgs,
javo