The limitations listed below are specifically for QTP 8.2:
Maximum worksheet size—65,536 rows by 256 columns
Column width—0 to 255 characters
Text length—16,383 characters
Formula length—1024 characters
Number precision—15 digits
Largest positive number—9.99999999999999E307
Largest negative number— -9.99999999999999E307
Smallest positive number—1E-307
Smallest negative number— -1E-307
Maximum number of names per workbook—Limited by available memory
Maximum length of name—255
Maximum length of format string—255
Maximum number of tables (workbooks)—Limited by system resources (windows and memory)
If you want to keep track of further articles on QTP. I recommend you to subscribe via RSS Feed. You can also subscribe by Email and have new QTP articles sent directly to your inbox.
Please use the Testing Tools forum for posting questions now!
Limitations of DataTable
Subscribe to:
Post Comments (Atom)
21 comments:
What is a difference between Column width and Text Length?
In excel - -Column width must be b/w 0 to 255 characters.
Open Excel - Select column - Right click - select Column width - enter 256 - - click on OK button.
Hi,
Can I save my userdefined variable value in a Data Sheet ?
Dim textValue
textValue= Browser("Browser").Page("Pag1").WebEdit("WebEdit").GetROProperty("innertext")
I want to save textValue in a column in Global Data Sheet. Then I want to compare this column with another column.
Is that possible ?
Thanks
Sairam
Hi Ankur,
I have one query in my data table i have 5 rows in gloal sheet and 3 rows in local sheet and i gave run all iterations in file test settings hows many times script will run?
Hi,
Assume in the database we have a table named "X".
I have Created or added a new column to the table "X".
Now I want to insert a check point to ensure the Newely created column is added to the table.
Could some one let me know your comments.
Is it possible?????
@ Rajesh: Please use Testing Tools forum for posting QTP related questions now onwards!
Hi Ankur,
i am trying to capture the URL from the open browser and store it. pls give me solution how we can do this in QTP.
thanks
Hi Ankur,
i want to use regular expression for my web content testing with qtp version9.2.
is there any settings need to be made in QTP to activate regular expression . I read article of using regular expression n used that but not working.
1> Scenario is need to check Subject content having only alphabets.My script line is as follows:;
If Browser("Name:=Welcome To abc.*").page("Title:=Welcome To abc.*").WebEdit("html tag:=INPUT","type:=text","name:=to","value:=[a-z]").Exist then
reporter.ReportEvent 0,"To text field empty","check for empty TO text field"
else
reporter.ReportEvent 1,"To text field empty","check for empty TO text field"
end if
it s not working. Can u guide me how to use regular expression for that. My mail id is singhmanyu@rediffmail.com.
Thanks and regards.
Please use Testing Tools forum for posting QTP related questions as I have already mentioned above.
Hi ankur
This blog is very useful....
can you tell me is there any demo version of QTP 9.2. so that it will be more easier for me to learn
Thanks in advance
Hi Ankur...
i am sasi...
i need more objective type question from QTP.... i got only 50 questions from you...
please send me more..
by this id kmrsas@gmail.com
bye
hello sir
i am praveena.
how can i print the values in fly from combobox to global sheet?
Hi Ankur thanks for providing a QTP Community, i am supriya working as test engineer in bangalore, now in our company we work on manual process as our is a small company & we cant use any tools, i am planning to do QTP advanced level course that provides an idea for writing scripts, i want to know any good training institutes or any employees who teach QTP. i want to know whether u can teach QTP, i request you to please mail me back as soon as possible my mail id is supriyashen@gmail.com....
Please provide ur email so that i can have a discussion with u..my mail id is supriyashen@gmail.com
Hi Ankur,
I am new to QTP and it's urgent for me to complete this task. Please help me out. I have a comment dialog in a window and check box for spell checker. so when a user select this spell check check box the system need to underlign the wrong spelling text. I need to automate this process. Mine is a vc++ satndalone application i am using qtp 9.5
Thanks,
Sonu
Hi Ankur,
I have a very typical problem in my application. Can you send me your Email-id so that I can mail you my problem. My email id is mukesh.jain@yahoo.com.
Thanks.
Can you please send sample qtp framework.
Hi,
What is the difference b/w global data sheet and Action parameters?
Using global data sheet also we can pass value from one action to another action.
Action parameters is also used to pass value b/w actions..
Please explain the difference b/w action parameter and global data sheet..
Thanks in advance...
How do we input blank fields on qtp? trying to change a field from filled to blank!
Hello,
My company has decided to use silverlight frame work with .NET application. How do I use QTP with silverlight controls and .NET? Please advise me. We have 9.5 QTP version.
My e-mail is 21deven@gmail.com
Thanks!
Deven
Hi Ankur..
This is my longterm problem
i am not able to launch qtp apllication
Set qtp_app=createobject("Quicktest.Application")
qtp_app.launch
qtp_app.visible=true
Its giving activex can't create object
plz wat to do ..answer me...waiting for u r reply
Appreciated u r help
Hi Anusha,
Please check whether your current login a/c have got sufficient rights or not...
Workaround:
1. Store the code in .vbs file
2. Request your sys admin to login to your workstation
3. Try executing this .vbs file... If it works, then its the problem with security policies... request them to grant the same to your a/c.
Regards,
Anonymous
Post a Comment