export values to the excel sheet

[rjkmr.aiht]

this is my code

Code:

Set oWebtable = Description.Create() oWebtable("micclass").value = "Webtable" oWebtable("column name").value = "Type;Trade Show;Media Type;Email" Set oChildObjects = Browser("title:=Campaign Framework:.*").Page("title:=Campaign Framework:.*").webtable("innertext:=TypeTrade ShowMedia TypeEmailPartneryesCampaign SeriesBig DataSFDC Campaign.*","html tag:=table") a=ochildobjects.GetROProperty("rows") b=ochildobjects.GetROProperty("cols") c=ochildobjects.GetCellData(3,2) msgbox c

can any one please help me to export the values "c" to excel sheet

please find the attachment here and help me out

[falvi]

[Ankesh]

Hey just add one column to your global sheet and give some name.

Write the vale to the datatable and expot using the below code

Code:

Datatable.value("<Your Column Name>",dtGlobalSheet)=c Datatable.Export "<Full File Path>"

Regards,
Ankesh

[rjkmr.aiht]

hi thank u for reply


caan u please help out for this

Code:

set camptable=browser("title:=Campaign Framework:.*").page("title:=Campaign Framework: Home ~ salesforce.com - Unlimited Edition").webtable("column names:=Campaign Name;Status;Start Date","html tag:=TABLE") c=camptable.GetROProperty("rows") 'msgbox c datatable.SetCurrentRow(1) For i=2 to c a=camptable.getcelldata(i,1) msgbox a datatable.Value("id","Global")=a datatable.setnextrow Next

here i want to put the values in next cell it not happening its oly showing the value in first cell


Regards,
raj

[Ankesh]

Use the below code...

Code:

set camptable=browser("title:=Campaign Framework:.*").page("title:=Campaign Framework: Home ~ salesforce.com - Unlimited Edition").webtable("column names:=Campaign Name;Status;Start Date","html tag:=TABLE") c=camptable.GetROProperty("rows") 'msgbox c intCurrentRow=1 datatable.GetSheet("Global").SetCurrentRow intCurrentRow For i=2 to c a=camptable.getcelldata(i,1) msgbox a datatable.Value("id","Global")=a intCurrentRow=intCurrentRow+1 datatable.GetSheet("Global").SetCurrentRow intCurrentRow Next

Let me know if this doen't help.

Regards,
Ankesh

[rjkmr.aiht]

thanku for the reply i tried and get the code

Code:

set camptable=browser("title:=Campaign Framework:.*").page("title:=Campaign Framework: Home ~ salesforce.com - Unlimited Edition").webtable("column names:=Campaign Name;Status;Start Date","html tag:=TABLE") c=camptable.GetROProperty("rows") For i=2 to c a=camptable.getcelldata(i,1) row=DataTable.GetSheet("Global").getCurrentRow datatable.getsheet("Global").SetCurrentRow(row) datatable.Value("id","Global")=a datatable.getsheet("Global").SetCurrentRow(row+1) datatable.Export "c:\test11.xls" next

[Ankesh]

Glad that it worked for you.

[rjkmr.aiht]

thank u its working fine

please help for the last post for REgular expression