How to extract data in invisible rows in acxTable? - Printable Version +- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums) +-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP) +--- Forum: VB Scripting/Descriptive Programming (https://www.learnqtp.com/forums/Forum-VB-Scripting-Descriptive-Programming) +--- Thread: How to extract data in invisible rows in acxTable? (/Thread-How-to-extract-data-in-invisible-rows-in-acxTable)

How to extract data in invisible rows in acxTable? - paul_20k - 11-22-2008 Hi I have an acxTable within windows application. It has 100 rows and 20 columns. Only 11 rows are visble on the screen. When I use rowcount/columncount method it shows correct values for number of rows and number of colmuns. When I try to extract data from some cells, it works perfectly until row 11 and as soon as it touches row 12 and onwards, it shows error message "Type Mismatch" and in msgbox it shows contents of the cell as "Object Reference" and stops. I tried all methods available for activex tables like MakeCellVisible, makevisible etc but nothing worked. I tried sendkeys so that rows after 11 shows up on the screen but it stops even data is showing on the screen. Is there any way to extract data from all cells within acxTable? Ankur...as you already worked with ActiveX controls, maybe you can give me some hint to dig deep into this issue. Thanks RE: How to extract data in invisible rows in acxTable? - Ankur - 11-22-2008 Are the next 89 rows coming up on subsequent pages or they are not showing up at all? RE: How to extract data in invisible rows in acxTable? - paul_20k - 11-23-2008 Hi Ankur Thanks for you quick reply. All 89 rows are in the same page but hidden with scrollbar. So I can see them if I scroll down. Even I can make rows visible with sendkeys, it still gives me the same errors as described in previous post. Thanks RE: How to extract data in invisible rows in acxTable? - Ankur - 11-23-2008 In that case, I am sure there should be a 'method' available for it...just object spy on it. Can you attach 'object spy' image here? RE: How to extract data in invisible rows in acxTable? - paul_20k - 11-23-2008 I don't have access to the application right now as its weekend but I will send you object spy screenshot on monday. I tried all methods available but nothing worked. RE: How to extract data in invisible rows in acxTable? - paul_20k - 11-24-2008 Hi Ankur I am attaching "object spy" image. Please help in finding solution to the above issue. Thanks