I used Datatable.ImportSheet operation to import sheet from external file to the dtLocalSheet.
But I throw run error:
The DataTable.ImportSheet operation failed. The specified sheet index value does not exist in the Data Table.
I checked the SheetSource and the SheetDest, there are correct, and i tried to use names/index, always fail.
Is this because the column name in the external file doesn't match those of the dtLocalSheet?(But it reports as sheet index not found)
I don't know how to change the column name in Excel.
Re: DataTable.ImportSheet error
I resolved the previous problem, add column head just at the first row in the sheet.
But now I have another question.
I use DataTable.ImportSheet to replace the content of the local sheet at run-time.
When use the action as reusable action in another script, say, the action that imports sheet is "ChangeRule",and is in Script1, in the new script Script2 that use "ChangeRule" as an external action, how to reference its sheet name which in Script1 is simply "ChangeRule"?
In Script2, the sheet name of the action "ChangeRule" is displayed as "ChangeRule[ChangeRule]", but i tried use it and "ChangeRule" to reference the sheet, both failed.
Certainly i can use the number index of data sheet to reference it, but i think sheet name is more understandable.
[ 02-13-2006, 10:33 PM: Message edited by: oliviabean ]