Hi Nikhil, I also got the same issue many times. As you said tried, however it did not work.
Please share me if you have updates Thanks, Bhuvan On Sat, Dec 10, 2011 at 1:39 AM, nikhil gangwar <[email protected]>wrote: > Hi Rahul, > > I guess your all rows are imported as used rows, That's why it is showing > whole count. So do one thing Copy all the where you have data and paste in > new excel and now try to import and get count of the same. Try it out and > let me now. I guess you will get desired solution. > > Please let me know the output. > > Thanks > > Nikhil Gangwar > > datatable.importsheet importing All rows instead if only data > rows<http://groups.google.com/group/mercuryqtp/t/a181a06e2f37b5> > >> >> iRahulSingh <[email protected]> Dec 08 11:49PM -0800 >> >> Hi All, >> >> I'm experinecing a tricky situtation where on importing excel file >> using datatable.importsheet method, as even empty rows are also >> getting imported in datatable. By Blank rows i mean, QTP DataTable on >> doing datatable.getrowcount giving me value as 65536 ( that is, total >> rows present in a worksheet by default ). >> >> What i'm doing is i'm copying 5-10 rows from one workbook to a new >> workbook and importing this new workbook in my datatable and for all >> row iteration, qtp is trying to execute for blank rows also. >> >> Does anybody have any clue why this is happening ??? >> >> >> Thanx in Adv. >> Cheers >> /rahul >> >> >> >> >> Prabhleen Kaur <[email protected]> Dec 09 07:29PM +0530 >> >> click on "run on one iteration only" from run option on qtp. >> let me know if that helps. >> >> >> >> >> Bhuvan Sundar <[email protected]> Dec 09 08:06PM +0530 >> >> Hi Rahul, >> >> try below steps and it works fine. >> >> 1. first you copy data and paste in Notepad and >> 2. Again copy the data from Notepad >> 3. paste in new workbook and save it. >> >> Please let me know if you have issues. >> >> Thanks, >> Bhuvan >> >> -- >> Thanks, >> Bhuvan >> 9640391013. >> >> >> >> define a test case and how will we write a test >> case??????????????<http://groups.google.com/group/mercuryqtp/t/ddee8c60428598d4> >> >> Vijayaraja G <[email protected]> Dec 09 07:46PM +0530 >> >> Hi am new in insurance domain in My project? >> >> Can u explain insurance domain in life insurance >> >> >> >> >> web tables<http://groups.google.com/group/mercuryqtp/t/a03977ac4124f152> >> >> narasimha rao <[email protected]> Dec 09 05:53AM -0800 >> >> hi, >> In descriptive programing how we can capture a web table when there is >> no index property available. >> >> >> >> diff b/w associate repository and merge >> repository?????????<http://groups.google.com/group/mercuryqtp/t/a586cbea283689b0> >> >> Test Analyst <[email protected]> Dec 09 12:34AM +0530 >> >> Repository is a resource, you want the resource to be available to >> your >> Actions in QTP. Then you use Associate Repository to your Actions. >> Merging takes place between 2 repositories and finally you can >> Associate >> the Merged Repository. >> >> >> >> >> >> uma mahesh <[email protected]> Dec 09 11:39AM +0530 >> >> associating repository means attaching repository to the current test. >> >> Merge Repository means combining two repositories. >> >> >> >> Problem with window >> name<http://groups.google.com/group/mercuryqtp/t/dfdd5ed34042e7a1> >> >> Vaishali Chaudhari <[email protected]> Dec 09 04:23PM >> +0530 >> >> use following line. It should work. >> E.g. >> Window("Text:=Test").Dialog("Name:=A.*").WinButton("Text:=OK").Click >> >> Use regular expression for the property which is changing. like here >> Name. >> >> ~Vaishali >> >> >> >> QTP 11 >> Certification<http://groups.google.com/group/mercuryqtp/t/6720c8d55ae9af3f> >> >> Test Analyst <[email protected]> Dec 09 12:34AM +0530 >> >> Cost was 3500+. >> >> >> >> >> You received this message because you are subscribed to the Google >> Group mercuryqtp. >> You can post via email <[email protected]>. >> To unsubscribe from this group, >> send<[email protected]>an empty message. >> For more options, >> visit<http://groups.google.com/group/mercuryqtp/topics>this group. >> >> -- >> 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 > "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 -- Thanks, Bhuvan 9640391013. -- 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
