Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 08-04-2009
Member
 
Join Date: Nov 2008
Posts: 1,185
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?
Reply With Quote
  #2  
Old 08-04-2009
Member
 
Join Date: Feb 2008
Posts: 194
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
Reply With Quote
  #3  
Old 08-04-2009
Member
 
Join Date: Nov 2008
Posts: 1,185
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
Reply With Quote
  #4  
Old 08-04-2009
Member
 
Join Date: Feb 2008
Posts: 194
Re: Export xls or csv exceeding the limits of Excel rows

Why do not directly generate xls files?
Reply With Quote
  #5  
Old 08-04-2009
Member
 
Join Date: Nov 2008
Posts: 1,185
Re: Export xls or csv exceeding the limits of Excel rows

Quote:
Originally Posted by Ashok.M View Post
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?
Reply With Quote
  #6  
Old 08-04-2009
Member
 
Join Date: May 2008
Posts: 685
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.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Export xls or csv exceeding the limits of Excel rows"
Thread Thread Starter Forum Replies Last Post
How to normalize Excel data in Excel Rows Hache hi MS Office Support 2 24-02-2012 07:20 PM
Is it possible to have rows above 65,000 in Excel 2007 Nyota MS Office Support 2 21-02-2012 06:07 PM
Maximum rows in Excel 2010 Crooked Windows Software 5 18-02-2010 04:47 AM
Merging duplicate names not rows copy rows into new workbook each time VBA Excel 2003 awkwardsmile Software Development 2 09-07-2009 08:57 AM
Delete rows in Excel [VB] Janet J Software Development 2 03-02-2009 07:31 PM


All times are GMT +5.5. The time now is 02:17 PM.