Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Using ADO to populate Excel has 16k row limit
Message
 
 
À
06/08/2008 16:19:07
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01336326
Message ID:
01337043
Vues:
10
>Hi Yuri,
>
>I found the problem. Thanks for your input. Another change unrelated to ADO caused the issue. The wrapper class invoked workbook.SaveAs() using an earlier version of Excel as the file type, for backward compatibility. (Excel 95)
>
>The ADO call properly put all the rows into the sheet from the cursor, but after SaveAs() saves the file in that earlier version, it imposes the excel 95 sheet size limit at that time. I had to fix that part to resolve the problem.
>
>Thanks again, I apologize for the delay in responding.
>

Great you found the problem.
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform