Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel bulk transfer
Message
De
17/04/2009 11:04:18
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
17/04/2009 11:00:50
Metin Emre
Ozcom Bilgisayar Ltd.
Istanbul, Turquie
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
01395271
Message ID:
01395277
Vues:
83
>>DBF files used to be a viable option for bulk transfer to Excel, i.e. transfer a large amount of data without the slow speed of setting each cell individually. The bulk transfer might be the first step; later, the Excel file is formatted with additional commands (e.g., column width, numeric format for individual columns, inserting additional header rows).
>>
>>Now, it seems that the DBF format is no longer supported by Excel 2007, so this can be a problem. What would be the recommended method for a bulk transfer from Visual FoxPro? Some other file format? Clipboard? Preferably a method that would work both with Excel 2003 and Excel 2007!
>>
>>Right now I don't have a pressing need to solve this; I was just wondering.
>
>Excel 2007 no longer supported by us than... ;)

You mean, you do use DBF a lot for bulk transfer, right?

Unfortunately, we have to assume that many users will upgrade to the new version. But indeed, "Excel 2007 is not supported" may work as a short-term solution. Just tell the clients they have to keep Excel 2003 on machines that have your program, for certain features to work. I would considert this a short-term solution, however. Eventually most users will want to have the newer version of Excel.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform