Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Export to Excel Row Limitation
Message
De
26/05/2004 05:45:41
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
FoxPro 2.x
Divers
Thread ID:
00907027
Message ID:
00907229
Vues:
11
Frederick,
Up to maxrows (for current versions 65536) you don't need to do anything. Just open a copy of dbf in excel (you'd lose memo).
If you want to automate excel then in Fox2x you need to use DDE* commands.
Cetin

>Sergey,
>
>Thanks for the info. Just knowing the problem helps. Unfortunantly, I need to run the program "copy2xls" in FPW26, and it is written in VFP. Any other ideas off the top of your head???
>
>
>
>>>Yes, the limit is approx. 16,383 rows.
>>
>>The limit is 16,384 rows in VFP7 and earlier and 65,535 rows in VFP8 which is Excel limit also.
>>
>>> Daniel Gramunt wrote a program back in 2000 that was (I believe) out in the download area. It was called copy2xls. But I could not find it in my quick search before telling you. I will look around for my copy, or maybe someone else can point you to it.
>>
>>How to copy more than 16,383 records to Excel FAQ #8026
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform