Faulty .xls file produced when exporting 2007/05/15 19:52
Karma: 1
ms excel yells see attachment. And file contents are messed up - some cols and rows got to be placed to the wrong positions.
As soon as you make something idiot proof, Nature makes better idiots!!!
The topic has been locked.
#391
alex(Admin)
Admin
Posts: 301
Re:Faulty .xls file produced when exporting 2007/05/15 20:16
Karma: 8
Could you send me that xls file you generated?
The topic has been locked.
#395
crazycat(User)
Platinum Boarder
Posts: 73
Re:Faulty .xls file produced when exporting 2007/05/15 20:20
Karma: 1
Do you mean - send to your email or post here? You told me that you didn't receive my email I sent you previously.
As soon as you make something idiot proof, Nature makes better idiots!!!
The topic has been locked.
#443
rsd(User)
Senior Boarder
Posts: 15
Re:Faulty .xls file produced when exporting 2007/05/16 11:58
Karma: 1
That is because the file is not a xls file, but a CSV file with space used instead of commas. If you rename it to forme.csv instead of forme.xls, excel might not complain.
The topic has been locked.
#458
crazycat(User)
Platinum Boarder
Posts: 73
Re:Faulty .xls file produced when exporting 2007/05/16 19:41
Karma: 1
rsd wrote: That is because the file is not a xls file, but a CSV file with space used instead of commas. If you rename it to forme.csv instead of forme.xls, excel might not complain.
Not quite. After renaming the file worning is gone, but the contents of the file are such a mess. Not even close to perfectly ordered rows and columns though.
Any other suggestions? I thought it is all connected to the way data is collected to a certain type of file, isn't it?
Cheers, Adam
As soon as you make something idiot proof, Nature makes better idiots!!!
The topic has been locked.
#471
rsd(User)
Senior Boarder
Posts: 15
Re:Faulty .xls file produced when exporting 2007/05/17 02:38
Karma: 1
I don't really have a copy of Excel to see how to open the CSV file. Maybe Importing it would do (instead of opening).
Because the file is Tab separated field and not comma, this might be an issue to excel. (on OpenOffice after renaming to csv it works fine).
see attachment. And file contents are messed up - some cols and rows got to be placed to the wrong positions. 
