Greetings, Instead of CSV, you might try using SYLK. It's a text-based format that includes information on formatting, formulas, etc. It's supported by most spreadsheets including Excel, Lotus, etc.
A quick search on google for "SYLK format" yielded these references... http://www.worldgate.ca/~rschulz/misc/ http://www.worldgate.ca/~rschulz/misc/parseslk.awk http://www.worldgate.ca/~rschulz/misc/sylksum.doc http://myfileformats.com/search.php?name=SYLK I believe the mime-type you would want to use is "application/sylk". In fact, a search on google for "SYLK mime-type" yields many references which indicate that using SYLK as a download format is (was) not uncommon. Regards, -Lou Lembcke, Principal Chicago Systems Group ---- "Nahid, Nazneen (CORP, Consultant)" <[EMAIL PROTECTED]> wrote: > Hi Everybody, > > > Problem - Client wants to export the data from a web in an excel file. > When he downloads the excel file, he wants the cells of the excel file to > have the format not as "General ", but to have the > format as "Currency", "number" etc. > > I know how to download the excel file as "CSV", but give each column of the > cell a format as "Number" ? > > We also have the solution that download the exel and let the user run a > macro? > But this is not favoured by the client ? > > Any ideas/Solution? > > Thanks > Nazneen > > > > > To change your membership options, refer to: > http://www.sys-con.com/java/list.cfm > > To change your membership options, refer to: http://www.sys-con.com/java/list.cfm
