Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
GetCellData from a global sheet
#1
Solved: 11 Years, 4 Months ago
Hey guys,

I need to pull data from a specific cell in my datatable, i imported it from excel and now I want it to search to see the value in whatever cell I designate. Excel_Row is the current row. I developed a function that returns Column_Index, a numerical value representing a particular column. So to find the data in the Cell I wrote:
I
Code:
nput_Value = Datatable.GetCellData(Excel_Row,Column_Index)

I'm having an error come up that reads :
Object doesn't support this property or method: 'datatable.GetCellData'

This is because GetCellData requires a object. Is there a way I can tell QTP to consider my datatable a object or a different command altogether to give me the cell data?

Thanks,
Jay

Resolved, I used Datatable.RawValue(Column_Index, dtGlobalsheet)

Thanks for looking anyway
Reply


Messages In This Thread
GetCellData from a global sheet - by J112910f - 01-05-2011, 10:12 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Reading Global Sheet's DataTable Value Bhuvana 0 1,640 01-05-2020, 10:03 PM
Last Post: Bhuvana
  Error as Global Not defined while trying to retrieve value from Datatable siddharth1609 0 965 09-11-2019, 02:52 PM
Last Post: siddharth1609
  On Saving Script in QTP 11 my Global Data Sheet data is removed M Adnan Iftikhar 0 2,178 06-02-2015, 09:19 PM
Last Post: M Adnan Iftikhar
  global object which can be called in any action excellentpawan123 2 2,769 04-01-2015, 07:34 PM
Last Post: babu123
  GetCellData not implemented aranucci 4 6,742 01-08-2014, 03:42 PM
Last Post: aranucci

Forum Jump:


Users browsing this thread: 2 Guest(s)