|
in reply to Re^2: Need to generate excel having more than 70,000 records
in thread Need to generate excel having more than 70,000 records
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. |
Re^4: Need to generate excel having more than 70,000 records
by Ish (Acolyte) on Apr 02, 2009 at 15:52 UTC
|
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] |
|
|
Thanks. Obviously I misunderstood the scope of 'some formatting requirement'. I'll leave this sort of stuff to others in future, in case I confuse the issue.
| [reply] |
|
