Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Export to Excel problem
Message
De
02/09/2002 10:23:31
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Titre:
Export to Excel problem
Divers
Thread ID:
00695943
Message ID:
00695943
Vues:
55
Hi All,

This is a hard one: I have some data, which I need to send to Excel. This data is a collection of numeric values, logical expression and characters within the same column. To sort this problem, I have transferred all the values to characters making logical Yes and No and numbers STR(). After that
I EXPORT it to Excel.

The problem is that when it goes to Excel, I cannot format the numeric cells from VFP, because they are all interperted as characters. Even when I go to Excel itself and try to format the cells, it does not respond.

Is there any other way to sort it out?

Thanks

Jonathan
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform