madhavi Krishnarajpet

 Profile Answers by madhavi Krishnarajpet 

• Oct 23rd, 2008

 

Select the content in datatable from global sheet
1. Right click the datatable
2. Click edit
3. Click copy

In action sheet
4. Right click the edit and
5.
Click paste

Satish_kunchi

 Profile Answers by Satish_kunchi 

• Jun 16th, 2009

 

You can use the ExportSheet property of the DataTable.

The syntax is as follows :


DataTable.ExportSheet "<Path of the Local excel sheet>" ,"<Global Sheet name>".

For ex:

I have added data to the Datatable in the sheet with the name 'Sheet_001' and then exported that into a local sheet.

DataTable.AddSheet ("Sheet_001").AddParameter  "OrderNumber", ORN
DataTable.ExportSheet "D:OrderDetails.xls" ,"Sheet_001".

sujata_2221981

 Profile Answers by sujata_2221981 Questions by sujata_2221981

• Jun 27th, 2009

 

c=datatable.Value("A",1)
msgbox c
datatable.GetSheet(2)
datatable.SetCurrentRow(1)
DataTable.GetSheet (dtLocalSheet).AddParameter "A", c
d=datatable.Value("A",2)
msgbox d

' but it will be visible only for the run session.

qtpdeepak

 Profile Answers by qtpdeepak 

• Aug 31st, 2009

 

If the User wants to Copy all the Data from all the Rows to a Column in a Separate Sheet. Then the following code will be helpful.

A= DataTable.GetRowCount

DataTable.GetSheet(dtLocalSheet).AddParameter "CopiedData",""

For i=1 to A
 DataTable.SetCurrentRow(i)
 b=DataTable.Value("Values")
 DataTable.Value("CopiedData",dtLocalSheet)=b
Next

swapna.raut

 Profile Answers by swapna.raut 

• Dec 11th, 2009

 

At runtime you can coopy the data from Global sheet to Loca Sheet(Action1) in following sequence:-

1) Export the data of Global sheet to some temporary excel (for eg C:Test1.xls)
DataTable.ExportSheet("C:Test1.xls","Global")

2) Import the data of this temp excel to Action1 datatable as
DataTable.ImportSheet("C:Test1.xls","Global","Action1")

This code is not tested,  but it should work this way.