Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Importing a Calculated field from Excel
Message
De
10/03/2004 17:54:30
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00884994
Message ID:
00885031
Vues:
11
>Hi.
>I have set up a routine to import a file from Excel, but notice that if one of the columns is a calculated field (e.g. = Round(A1 / 100,2) , funny characters get into the imported field.
>
>Anybody know of a way round this ?
>
>Regards,
>
>Gerard

Perhaps you might use the Copy & Paste Special commands in Excel first, to paste the values only, into another range.
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