Information générale
Catégorie:
COM/DCOM et OLE Automation
Titre:
Export to Excel problem
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement