Export xls or csv exceeding the limits of Excel rows
I need your help. I have a code that I use for export .csv data stored in my MySQL database. The code works perfectly!
The file now begins to be large (exceeding the limit on the number of rows in Excel version 2003). I find a solution to circumvent this problem (data loss at the time of export).
Maybe export spread over several sheets, but the question is how! Do you have any docs on it?
Re: Export xls or csv exceeding the limits of Excel rows
it seems to me that you can not generate csv file with more (unless I am mistaken), otherwise you have to generate a file excel, and I think you should be able
Re: Export xls or csv exceeding the limits of Excel rows
yes, it is not possible to generate multiple sheets .csv
right now my export I do .csv but I might as well turn it into .xls that I can not do is to generate multiple sheets
Re: Export xls or csv exceeding the limits of Excel rows
Why do not directly generate xls files?
Re: Export xls or csv exceeding the limits of Excel rows
Quote:
Originally Posted by
Ashok.M
Why do not directly generate xls files?
Maybe because it's boring (it requires lib) is a proprietary format, and moreover can not easily import from mysql?
I do not know why I chose to export a .csv (easy to generate, May be ).
But let's say I generate a .xls but how can I write in the 2nd page of the workbook once the 1st sheet is full?
Re: Export xls or csv exceeding the limits of Excel rows
I see no better than several csv ...
ie count as the number of registration and if it exceeds the limit line, recreate a new one .csv
I think there is no way to insert multiple sheets in file .xls.