Thanks, that worked!
On Wed, 18 Jul 2001, William Kaufman wrote:
><>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
><>>
><>
