Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Append From (spreadsheet): column names?
Message
From
09/07/2006 09:52:13
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Append From (spreadsheet): column names?
Miscellaneous
Thread ID:
01134756
Message ID:
01134756
Views:
65
If you export to a spreadsheet using the command:

EXPORT TO MySpreadsheet TYPE XLS (or some other spreadsheet type)

and then later, in another program, you import data from that same spreadsheet into a cursor using the statement:

APPEND FROM MySpreadsheet TYPE XLS (or some other spreadsheet type)

is there any way to get the column names from the spreadsheet that that were created in the first step when the spreadsheet was created?

I know that for character columns, the column name appears in the first row, but all numeric columns appear as 0. Is there some way to query the spreadsheet to determine the column names?

I need to to do this in order to check if the user imported an incorrect spreadsheet (which I would know because the spreadsheet would not have the correct columns) or if the user moved the columns around between the time the spreadsheet was created and the time it was re-imported.

TIA
Next
Reply
Map
View

Click here to load this message in the networking platform