Another alternative is to create Symbolic Link (.sylk) files, which Excel will
pick up in the same fashion as .csv. The advantage is that you can do more (as
opposed to none with csv) formatting e.g. cell widths, fonts, printable area
etc.
The disadvantage is that they are a LOT more complicated than csv, and I've
never found any real documentation on the format. Excel sometimes reports
errors loading the ones I am producing in servlets, though there is no evidence
in the resulting pages of what problems those errors caused!
Fruittrell: could you expand somewhat on how one might uuencode a flat file to
an Excel file?
- simon
B L wrote:
> >There is a requirement in our project where I need to generate Excel
> >Spreadsheets on the fly on Unix (Solaris).
>
> We had the same need in our project
>
> >Currently I am generating ASCII flat file, FTPing it to Windows and
> >importing it in Excel.
>
> We also generate a flat ASCII file, but we use HTTP instead of FTP
> and we send the flat file to the client's browser, saying the
> MIME type is: application/csv
>
> When using MSIE this mimetype should be recognized, when using
> Netscape, the user should 'pick' an 'app', the first time he
> receives such a file.
>
> After that, when the user requests such a CSV-file from a servlet,
> Excel is automatically opened and the CSV-file is automatically
> imported (clientside conversion!).
>
> There is only 1 possible problem, namely the regional settings
> of the client.
> In Settings -> Control Panel -> Regional Settings -> Number
> the value of the 'ListSeparator' should be set to the delimiter
> you are using in your flat files.
>
> ______________________________________________________
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
