Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Storing to an Excel SS
#1
Not Solved
I need help with this code. Currently, the View, Fax and Zip links are in one column in the import table, and my export is also get stuck on one line,

My wish is to have the column and row numbers in two seperate columns followed by a third colum that indicates the Link innertect name (ie... rig004, View, Fax, or Zip). The WebElement:WebTable is being selected that innertext equals [View] [Zip] [Fax]. I need the WebTable: Select All -> Link : View where the innerhtml, innertext or text equals View, Fax or Zip.

see the attachment for how my output looks now, and what I am am hoping for.

Any coding help?



Code:
Set objExcel = createobject("Excel.Application")
objExcel.Visible=True
objExcel.Workbooks.Add
Set TableObj = Browser("Wisdom").Page("Wisdom IA_2").Frame("parent").WebTable("Select All")

RowCount = TableObj.RowCount
msgbox RowCount

For i = 1 to RowCount
ColCount = TableObj.ColumnCount(i)
'msgbox ColCount
For j = 1 to ColCount
ChildCount = TableObj.ChildItemCount(i, j, "Link")
If ChildCount > 0 Then
InnerHtml = TableObj.Object.rows(i-1).Cells(j-1).innerHTML
For k = 0 to ChildCount - 1
Set LinkObj = TableObj.ChildItem(i, j, "Link", k)
LinkName = LinkObj.GetROProperty("text")
objExcel.Cells(i, j).Value = TableObj.getcelldata(i,j)
Next
End If
Next
Next

thx everyone for looking ;-)


Attached Files
.pdf   Try to create an Excel with header row of Column Row DocView.pdf (Size: 99.58 KB / Downloads: 76)
Reply


Messages In This Thread
Storing to an Excel SS - by mv8167 - 06-11-2011, 01:28 AM
RE: Storing to an Excel SS - by rajpes - 07-05-2011, 08:31 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Storing runtime value into datasheet priyaUFTlearner 4 3,443 04-10-2015, 10:08 PM
Last Post: priyaUFTlearner
  storing QTP test resources(library functions,repositories) in Quality Center Pallavi 8 9,633 09-21-2009, 02:14 PM
Last Post: basanth27
  Problem with storing value in DataTable Parke 3 3,114 10-02-2008, 04:35 PM
Last Post: Parke
  Storing dynamic data at run time Rupesh 5 5,451 07-29-2008, 02:13 AM
Last Post: kishoreinchennai

Forum Jump:


Users browsing this thread: 1 Guest(s)