Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Character data mangled with datatoclip into Excel
Message
De
14/12/2004 18:30:58
 
 
À
13/12/2004 19:21:50
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP1
Divers
Thread ID:
00968947
Message ID:
00969304
Vues:
12
Great! Just what I needed / Jim

>>I'm exporting a table to Excel by copying it to the clipboard (using _vfp.datatoclip) and then pasting it in Excel.
>>
>>However, I'm having problem with character data that "looks like" data of some other data type. For instance, I have a field which is length of time, and which looks like hours and minutes (2:02, 4:15, etc). Excel is thoughtful enough to convert these to time-of-day.
>>
>>Is there some way to force Excel to accept character data and not try to be so handy as to do conversion for me?
>>
>>Thanks
>
>Yes, if you give the Excel cells a corresponding format, for instance, "Text", before inserting the values, it should not interpret your data.
Jim Nelson
Newbury Park, CA
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform