Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
export values to the excel sheet
#5
Solved: 11 Years, 3 Months, 4 Weeks ago
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
Reply


Messages In This Thread
export values to the excel sheet - by rjkmr.aiht - 04-26-2012, 12:43 PM
RE: export values to the excel sheet - by falvi - 04-26-2012, 01:32 PM
RE: export values to the excel sheet - by Ankesh - 05-03-2012, 01:07 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  How to export the output value of a webedit object to a new excel file. mounika6677 1 1,529 04-14-2019, 05:18 PM
Last Post: mounika6677
  Need help for copying values from one excel to another excel vinodhiniqa 0 1,363 07-06-2017, 05:33 PM
Last Post: vinodhiniqa
  Reading data from excel sheet serenediva 1 9,618 03-03-2017, 10:07 AM
Last Post: vinod123
  How import final calculated values by cell formula from Excel not the formula itself. qtped 1 4,854 01-17-2017, 04:05 PM
Last Post: sagar.raythatha
Smile Importing Excel sheet - Reference Values are not recognized michiusa69 3 7,884 01-23-2015, 02:36 AM
Last Post: lkng2001

Forum Jump:


Users browsing this thread: 4 Guest(s)