How to verify data in excel sheet dowloaded from web appln

[Ravi_Chandra]

Hi,

Can anyone suggest solution for the below scenario?
Below is the scenario:

From a web application, we have to check the export to excel functionality.
Ex, there is a data grid with lot many records (rows).
We have to export the data by clicking on Export to Excel button
Click on Open button in File Dowload window
Open the Excel sheet (without saving)
Verify the total record count in excel sheet matches with the count displayed in application.
When tried to add objects for the excel sheet which is open... later OR is not identifying the same excel sheet. How can we add the Excel sheet as an object uniquely?

Thanks,
Ravi.

[sravaniqa]

Hi Ravi,

Does the imported excel workbook gets opened after the import operation? If so, I guess u can make the QTP identify the opened excel book by Descriptive programming. If the excel workbook does not get opened physically and the excel.exe runs in hidden mode, I think u can access the same using CreateObject("Excel.Application").

Please let me know if I am wrong.

Regards,
Sravanthi

[Ravi_Chandra]

Hi,

Found solution for my query. Used below code to retreive the row count from an open application:

Code:

Set objExcel = Createobject("Excel.Application")
Do
     Wait(2)
Loop Until objExcel.Visible = True
rowCount = objExcel.ActiveWorkbook.ActiveSheet.usedrange.rows.count

Thanks,
Ravi.