Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much
 
PerlMonks  

Re: Need to generate excel having more than 70,000 records

by gube (Parson)
on Apr 02, 2009 at 02:19 UTC ( #754834=note: print w/ replies, xml ) Need Help??


in reply to Need to generate excel having more than 70,000 records

Thanks Ish. But, they need excel since for some formatting purpose.

Gubs


Comment on Re: Need to generate excel having more than 70,000 records
Re^2: Need to generate excel having more than 70,000 records
by Ish (Acolyte) on Apr 02, 2009 at 02:27 UTC
    Hi, I'm sure they will use Excel, but there is any reason why you couldn't produce a CSV file and let them import it into Excel? CSV files are the most frequently used 'glue' between things like databases and spreadsheets (and ordinary files of course). A sort of common denominator as it were.
      There is absolutely a good reason and you were just told it. CSV is the wrong answer if you want any control of formatting. And there are a lot of valid reasons to care about formatting, from keeping Excel from breaking things by trying to convert things to dates to producing something that looks nice because that is what the client was promised.
        The data is being produced from a 'table' so must be put into some form that is acceptable to Excel. If this format can not be generated such that Excel understands it as required (and the old module can generate it like that) then agreed you can not use cvs. However as I don't know what format is required I felt it was a reasonable suggestion. From my experience of extracting data from DBs for import into Excel spreadsheets (thankfully limited!) cvs has worked reasonably well. This was only company internal though, so if you have external clients it could be more of a problem. But the new modules seem as though they will address the problem, so all's well.
Re^2: Need to generate excel having more than 70,000 records
by derby (Abbot) on Apr 02, 2009 at 12:47 UTC

    Ish is correct. If the report is just plain tabular data then just create a CSV file and slap a '.xls' extension on the end of it. When you go to open it with Excel, Excel will do the right thing.

    -derby

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://754834]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others having an uproarious good time at the Monastery: (8)
As of 2014-08-28 09:15 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (259 votes), past polls