Sriram

• Oct 16th, 2007

 

You can use datatable.Addsheet("sheetName") after that use datatable.ImportSheet function

Anshoo_Arora

 Profile Answers by Anshoo_Arora 

• Dec 8th, 2007

 

Another way is to modularize your script.

newqtp

 Profile Answers by newqtp Questions by newqtp

• Feb 12th, 2008

 

v=DataTable.AddSheet ("SheetName").AddParameter ("ColumnName Time","ColumnValue 8:00" )
msgbox"go"

DataTable.ImportSheet  "c:temp.xls",1,"SheetName"
msgbox "look"

SheetName is depend on you..you can give any sheet name.

manyam_muralireddy

 Profile Answers by manyam_muralireddy 

• Oct 1st, 2008

 

in data table two sheet are there : global,action
if global

window("  ").winedit("  ").set datatable(" ",dtglobalsheet)

if action

for i=1 to 10 step 1
datatable.set current row (i)
window(" ").winedit(" ").set datatable(" ",dtlocalsheet)

kotike

 Profile Answers by kotike 

• Apr 14th, 2010

 

We can dynamically add/delete sheets to runtime datatable.

datatable.addsheet "sheet name" '

It will add sheet to runtime datatable during runtime.  We can see this table in results runtime datatable.  Once adding sheet at runtime then import data into that sheet

datatable.importsheet "path of the sheet",sourcesheet id,3

3 indicates destination sheet id which we add at runtime
then we can see data in results-->Runtime datatable

Gowthami

• Dec 13th, 2017

 

datatable.addsheet
Using above statement we can insert a new sheet to the datatable