I have since decided against this as well in the end.. I have gone back to csv...
but as for why this is better then normal xls.. is that the perl module will only write xls that all the office apps will totally understand.. there is no diff in any of them.. excel often writes xls files that look bad on others.. anyway, the main reason I gave up on this module was because it requires the file be written to temp drives and then to master xls file.. I want to open a header and stream the info to the user.. no file creation on the server.. I have achieved that with csv currently. and it will be much faster for not having to do file creation... I also got headers of a sort with csv now as well.. I had the headings in an array (a list)... so I did a count on them.. and inserted this in the script: $csv_output .= '-------------,' x $count; so it adds an underline for each header... gives it some seperation from the data.. testing in OOo looks ok.. rgds Franki -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Anne Wilson Sent: Wednesday, 2 April 2003 1:57 AM To: [EMAIL PROTECTED] Subject: Re: [expert] open source spreadsheet file format. On Tuesday 01 Apr 2003 6:45 pm, Frankie wrote: > yeah, I agree with all of that.. > > problem is the end user is not gonna understand downloadin the data as > html.. > > so I went looking at cpan and found this: > http://search.cpan.org/author/JMCNAMARA/Spreadsheet-WriteExcel-0.40/WriteEx >c el.pm > > > it creates what is as close to standards compliant xls as possible.. > > so maybe that will have to do for now... csv is just missing to much... I > need basic formatting.. > Not trying to stir this up, Franki, but how is that more satisfactory than using .xls to start with? Or is it that the .csv data is not translatable (by you) to .xls? Perhaps we are not understanding your application. Anne -- Registered Linux User No.293302
Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
