Hi Mary, How you are importing the Excel file to Datatable? Is it Datatable.import(fileName)?
Can you please check what is printing if you have a statement like xlSheetObj.UsedRange.Rows.Count. If it returns 65536, then that is what Datatable.getrowcount also prints. Also create another sample xls file and enter few rows of data and check import and print getRowCount. It should return you only the rows of data. Thanks, Uday QTP \ UFT Videos <http://www.youtube.com/user/AnemUday/videos> QTP Videos Blog <http://qtpftvideos.blogspot.in> On Monday, 2 September 2013 15:30:47 UTC+5:30, Mary wrote: > > Hi, > I have imported an excel sheet to the datatable. It has values only > in two rows. But when i used datatable.GetRowCount it shows 65536.. > So, it takes more time for the script execution. > > > -- -- You received this message because you are subscribed to the Google "QTP - HP Quick Test Professional - Automated Software Testing" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/MercuryQTP?hl=en --- You received this message because you are subscribed to the Google Groups "QTP - HP Quick Test Professional - Automated Software Testing" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
