Read Object Values and write in Excel or Notepad?
i got task ...to read and write in notepad.
1.Read or take Object Values of WebTable
2.Write then in Notepad or Excel
3.Web Table Data is combined how can i give space or spile the data?
Please can anyone help me or sample code.
Re: Read Object Values and write in Excel or Notepad?
If you want to read all the data from the webtable and write it to the notepad/Excel then here is the sample code.
Set ItenCount = Browser("...").Page("...").WebTable("...")
RCount = ItenCount.GetROProperty("rows")
Ccount = ItenCount.GetROProperty("cols")
For i = 1 to RCount
For j = 1 to Ccount
CData = ItenCount.GetCellData(i,j)
'Here u could create one excel sheet and enter each value from CData into it.