Naming convention of datatable global sheet.

[TurtleRock]

Hi,

I need to know that can the name of global sheet be only "Global" .

[harishshenoy]

Yes , you cant rename the global sheet , but it is possible for the local sheets , loca sheets takes the name of 'Action Name' of the respective actions.

Thanks,
Harish Shenoy

[nilanjans]

Hi,

Globalsheet name should be global only. It can't be renamed. But Local datasheets can be renamed and for that you need to rename the corresponding action name.

But if you want to import sheets from external .xls sheet and want to keep the sheet name intact then better not to import the whole Workbook.

Better you should go for add those many sheets on runtime and import those specific sheets to those added sheets accordingly.
You can try with the below code for that:

Code:

DataTable.AddSheet "Sheet1"
DataTable.AddSheet "Sheet2"
DataTable.AddSheet "Sheet3"

DataTable.ImportSheet "C:\Mytest.xls","Sheet1","Sheet1"
DataTable.ImportSheet "C:\Mytest.xls","Sheet2","Sheet2"
DataTable.ImportSheet "C:\Mytest.xls","Sheet3","Sheet3"

Thanks,
Nilanjan.