Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to get row count if xls file is generating dynamically.
#6
Solved: 11 Years, 3 Months, 4 Weeks ago
Hi Sekhar,

The above script which i given is with out giving any file name while saving.

1.First click the Save button (Browser("xxx").Dialog("xxx").Winbutton("xxx").Click
2. Here you will not be knowing what is the file name which you have saved.
3. The above file will be saving in specific folder( My assumption: Here file name is dynamically varying but folder name is constant, i.e all files are by default saving in same folder)
4. By usin this folder you can find out the last modified file name i.e the last file which you have saved.
5. Now you know what is the last modified file i.e file which u saved recently
6. You will come to know what is the last modified file is by using the above script
7. Once u come to know then import the file to datatable i.e Datatable.Import "file name" this file name is the one whic u got it from script
8. After importing find the row count by using Datatable.GetRocount


Finally u will be having Rowcount in that particular Excel file.


Please let me know for further clarification.


Regards,
Venkat.Batchu
Reply


Messages In This Thread
RE: How to get row count if xls file is generating dynamically. - by venkatbatchu - 08-24-2010, 10:01 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  How to dynamically find the OracleFormWindow? arpan 0 1,775 04-26-2017, 12:45 AM
Last Post: arpan
  How to click on all links dynamically in UFT? Rohan 9 18,515 02-25-2016, 10:42 AM
Last Post: vinod123
  Searching for and selecting row in Datawindow zsl0009 0 2,810 08-04-2015, 01:02 AM
Last Post: zsl0009
  How to Verify Static Object Text which is changing Dynamically with Expected Result johnny77 0 3,305 06-25-2015, 11:32 AM
Last Post: johnny77
  SAPGuiSession get the active SAPGuiWindow dynamically cko77 2 5,334 01-27-2014, 12:04 PM
Last Post: cko77

Forum Jump:


Users browsing this thread: 2 Guest(s)