Jump to content


Photo
- - - - -

65000 records


5 replies to this topic

#1 mmeneses

mmeneses

    Member

  • Members
  • PipPip
  • 43 posts
  • Gender:Male

Posted 15 May 2006 - 12:57 PM

Hi to all!

I have a problem dumping data to excel spreadsheet. I came across with this problem when the program tries to dump a record of more than 65000 (excel maximum number of rows per spreadsheet).

Any idea how to dump the data to the next sheet once I reached this maximum number of rows?

p.s. I call a batch file to open an excel template.


Thanks,
Mike

#2 Mike Schoen

Mike Schoen

    Expert

  • Members
  • PipPipPipPip
  • 198 posts
  • Gender:Male
  • Location:Guelph, Canada

Posted 15 May 2006 - 01:32 PM

#STAT = DDE_POKE('EXCEL',$SHEET,$RC,$$A)

Keep a row counter, and change the $SHEET to a new sheet name as needed.

#3 mmeneses

mmeneses

    Member

  • Members
  • PipPip
  • 43 posts
  • Gender:Male

Posted 15 May 2006 - 01:37 PM

When I UMSG the value of the variable $SHEET it was blank. How can I change it to a new name.

thanks and I really appreciate that.

p.s. I call a batch file to open an excel template. Does it make any difference from opening the excel directly from pro-iv?

-Mike

#4 SteveHoughton

SteveHoughton

    Member

  • Members
  • PipPip
  • 42 posts
  • Gender:Male
  • Location:Kent UK

Posted 15 May 2006 - 02:46 PM

You could also try using Corel Office which allows a considerably larger number of rows in its spreadsheets than Excel.

#5 mmeneses

mmeneses

    Member

  • Members
  • PipPip
  • 43 posts
  • Gender:Male

Posted 15 May 2006 - 03:40 PM

thanks for all the reply.. I already figured it out...

#6 Fabiano Giannetti

Fabiano Giannetti

    Member

  • Members
  • PipPip
  • 16 posts
  • Gender:Male
  • Location:Prato, Italy

Posted 18 May 2006 - 04:38 PM

Hi,

what is the right sintax to change the sheet name.


Thank you.



Reply to this topic



  


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users