Hi nikhil,

Thanx for your reply.
Im doing the same, importing a new excel yet all the rows are getting imported.
Even i dont understand why, any reason why ???


Regards -
Rahul

Sent from my iPod. Please ignore any spelling mistake if any.

On 10-Dec-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
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??????????????
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
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?????????
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
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
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.
To unsubscribe from this group, send an empty message.
For more options, visit 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

Reply via email to