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.
>
>Is there any other Excel file you can try to import? The code I provided in my last message creates an ExcelColTest.xls file, what happens if you try to import that? You can change that code to 132 columns if necessary.
>
>Does your Excel file have more than one row? If so, can you test with half of the rows deleted (the top half)?
>
>Like I said, I can't duplicate your issue, I really think there's something weird with your Excel file.
>
>FWIW I'm on VFP9 SP2 build 7423 (the latest hotfix), not that I think it makes any difference from VFP9 SP1.
Hi Al, yes, thanks...when i delete 2 rows that have the data out to the DV column...no problem....will have to mess around w/it a bit more.
J
Précédent
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