Information générale
Catégorie:
COM/DCOM et OLE Automation
Versions des environnements
>Hi, I am using the IMPORT FROM command to read in an Office 2007 MS-Excel file, so field names are A, B, ....Z, AA, AB, ...AZ, BA, BB, etc..
>
>I have to handle files defined as:
> Columns A - M: standard information
> Columns N - R: information about charge 1
> Columns S - W: information about charge 2
> Columns X - AB: information about charge 3
> etc.
>
>In other words, past column M, information is in groups of 5 columns.
>
>NOOOO problem, i thought. I have code that calculates the column name.
>
>BUT lo and behold! what column follows DU??? NO, NOT DV, but DW!
>
>What is going on here? any ideas? this is def. breaking my code.
>
>Any input is appreciated.
>
>Guess i have to change the code to using AFields()?
The column is just not there. In MS-Excel it appears empty, and format is "general" - so i entered a "123" and changed the format to numeric.
Still, no column DV in VFP.
Précédent
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