Forum > FPSpreadsheet
problem writing xls file
nicola69:
Hi
My lazarus version is 1.06 , fpc 2.6.0 , cpu icore 5 and my so is windows xp 32 bit.
I use sqlite as db.
I write a simple application that read a file csv , search some data in a sqlite db and write data in excel in 2003 format
I use FPSpreadsheet .
My problem is when I try to read a file with more than 5600 row and the excel file is the same height , my program generate excel file (.xls) but excel 2007 don't read file and tell me that is corrupt. i tried open with libre office 4 but i have the same problem.
Could someone help me ?
Thank you very much.
you could download project file from
https://dl.dropbox.com/u/64726031/project%20exported.zip
exe compiled for win 32 and sqlite db file and sqlite3.dll
https://dl.dropbox.com/u/64726031/exe.zip
and a txt sample
https://dl.dropbox.com/u/64726031/sample%20file%20txe.zip
If you want try my program with sample txt file you have to push first button "Carica Dati ftp e Genera Excel"
you have to select txt inside sample file txe.zip
After few minutes my program ask you where save xls file.
I read another thread
http://www.lazarus.freepascal.org/index.php/topic,16716.15.html
I think that I have same problem but i have download last version of lazarus. Where i can see if my revision in more than 2454.
Another question
Can I save in ooxml format and it compatible with excel 2007 ?
BigChimp:
Thanks for posting detailed info.
Haven't looked at your application yet.
Note that the version of fpspreadsheet is independent of Lazarus as fpspreadsheet is not bundled with Lazarus.
Please first try to use the newest development version of fpspreadsheet or the recently released (January) new version:
http://wiki.lazarus.freepascal.org/FPSpreadsheet#Latest_release
BigChimp:
Fiddled some with the program; LibreOffice shows an empty file (if saved as .xls) even if only 400 lines are saved....
nicola69:
BigChimp
i have donwloaded lasted svn from sourcefourge (1.1)
but there is same problem excel with more 5600 are saved in a wrong file format.
BigChimp:
Well, as I said, with the latest fpspreadsheet, I couldn't even get 400 rows to save correctly. Maybe I modified your program too much while looking at it....
Navigation
[0] Message Index
[#] Next page