We've got it working exactly as you say, but only if the data is delimited
with _tabs_, not _commas_.
-- Bill K.
> -----Original Message-----
> From: Erin Lester [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 18, 2001 2:21 PM
> To: [EMAIL PROTECTED]
> Subject: Generate Excel File
>
>
> Hi, I'm trying to generate an excel file as the response
> returned from a
> servlet. I have set the response's content type to
> "application/vnd.ms-excel" and this seems to cause excel to open. The
> data I return is comma separated values.
>
> Once upon a time I read on a newsgroup (don't think it was
> this one) that
> someone had done the same thing and excel interpreted the
> data as a csv
> file and it displayed nicely in excel. Unfortunately excel
> seems to think
> that the entire row of comma separated values that I'm
> sending it is one
> single cell (not a row of cells which are the values between
> the commas).
>
> Can anyone tell me where I'm going wrong or of another way to
> generate an
> excel spreadsheet using JSP?
>
> Thanks!
> Erin
>
