>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.
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
___________________________________________________________________________
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
