in reply to Re: Need to generate excel having more than 70,000 records
in thread Need to generate excel having more than 70,000 records
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.
|
Re^3: Need to generate excel having more than 70,000 records
by tilly (Archbishop) on Apr 02, 2009 at 15:12 UTC
|
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. | [reply] |
|
|
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.
| [reply] |
|
|
It was a reasonable suggestion the first time you made it. But once you were told that formatting is a requirement, it was unreasonable to come back with the same suggestion when it clearly cannot meet the requirement.
| [reply] |
|
|