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


Attached Files Image(s)
   
Reply
#2
Solved: 11 Years, 3 Months, 3 Weeks ago
please try to read the contents of this page, and tell if it helps you.

http://www.rlmueller.net/Programs/XLRead.txt
or try this simpler one:

Code:
Set objXL = CreateObject("Excel.Application")
Set objWB = objXL.WorkBooks.Open("C:\Scripts\test1.xls")
Set objWS = objXL.ActiveWorkBook.WorkSheets("test1")
objWS.cells(i,j).value = YourVariable // i,j defines the cell you wish to put the data in.

objWB.Close
objXL.Quit
Reply
#3
Solved: 11 Years, 3 Months, 3 Weeks ago
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
Reply
#4
Solved: 11 Years, 3 Months, 3 Weeks ago
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
Reply
#5
Solved: 11 Years, 3 Months, 3 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
#6
Solved: 11 Years, 3 Months, 3 Weeks ago
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
Reply
#7
Solved: 11 Years, 3 Months, 3 Weeks ago
Glad that it worked for you. Big Grin
Reply
#8
Solved: 11 Years, 3 Months, 3 Weeks ago
thank u its working fine

please help for the last post for REgular expression

Reply


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,515 04-14-2019, 05:18 PM
Last Post: mounika6677
  Need help for copying values from one excel to another excel vinodhiniqa 0 1,353 07-06-2017, 05:33 PM
Last Post: vinodhiniqa
  Reading data from excel sheet serenediva 1 9,594 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,850 01-17-2017, 04:05 PM
Last Post: sagar.raythatha
Smile Importing Excel sheet - Reference Values are not recognized michiusa69 3 7,876 01-23-2015, 02:36 AM
Last Post: lkng2001

Forum Jump:


Users browsing this thread: 1 Guest(s)