General information
Category:
Coding, syntax & commands
Title:
Append From (spreadsheet): column names?
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only