Limitations of DataTable

by | Last Updated On Feb 20, 2014 | Tips and Tricks in QTP | 28 comments

The limitations listed below are specifically for QTP 8.2:

  1. Maximum worksheet size—65,536 rows by 256 columns
  2. Column width—0 to 255 characters
  3. Text length—16,383 characters
  4. Formula length—1024 characters
  5. Number precision—15 digits
  6. Largest positive number—9.99999999999999E307
  7. Largest negative number— -9.99999999999999E307
  8. Smallest positive number—1E-307
  9. Smallest negative number— -1E-307
  10. Maximum number of names per workbook—Limited by available memory
  11. Maximum length of name—255
  12. Maximum length of format string—255
  13. 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 QTP forum for posting questions now.

You Should Read These 3 Related Articles Too!

28 Comments

  1. nupur talwar on Mar 28, 2013 at 11:24

    Hi,

    As there is a limitaion of datatables column of 256 in QTP. Is there a way that we can increase the column numbers???

    Reply
  2. Aisha on Dec 7, 2011 at 19:01

    Hi Ankur,

    I intend to provide some value starting with zero for example credit card security number which starts from 00**, but when i remove my cursor it automatically makes the value to absolute number and removes my zero, i tried data table format but it did not worked out, can you please tell me an alternative or any way i can set my values starting from zero digit? (Dont want to use import sheet)

    Reply
    • Vishal on Aug 20, 2014 at 12:00

      In the Excel cell use ‘ before 0s.

      Reply
  3. archana on Jun 16, 2011 at 18:17

    hi All,
    i am new in QTP & I am trying to script registration form, here i script ones by sumiting form with any username & password but when i try it again i found error message that username is already exit.

    cane this prob. resove with regular expression or any other way.
    i want to run my script that is filling the registration form and submit it without any error, means it will take random username with its own and run the script.

    archana
    archii84@gmail.com

    Reply
  4. Anonymous on Oct 15, 2009 at 02:31

    Hi Ankur,

    Thanks for all the postings, it really helps a lot.

    I am facing an issues with data table. I am loading addresses with data table, but when the zip code starts with zero (ex. 01158) QTP is truncating the zero and web page throwing an error. I changed the data type to text in the excel sheet, but still qtp considers as numbers.
    Any help is much appreciated.
    Thanks.

    Reply
    • Aditya Dwivedi on Jan 20, 2016 at 19:09

      hello,
      Change the format of datatable to number.
      then it will work properly.

      Reply
  5. Anonymous on Jul 25, 2009 at 00:55

    Hi Ankur,

    I want to know if QTP supports VC++.Please let me know urgently.

    Thanks a lot!

    Reply
  6. Anonymous on Jul 4, 2009 at 18:50

    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

    Reply
  7. Anusha Ananthu on Jul 1, 2009 at 04:48

    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

    Reply
  8. Deven on Jan 17, 2009 at 01:37

    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

    Reply
  9. Anonymous on Jan 13, 2009 at 17:52

    How do we input blank fields on qtp? trying to change a field from filled to blank!

    Reply
  10. Tamil Elango on Jan 9, 2009 at 17:55

    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…

    Reply
  11. Anonymous on Oct 31, 2008 at 06:15

    Can you please send sample qtp framework.

    Reply
  12. Anonymous on Oct 20, 2008 at 13:02

    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.

    Reply
  13. Usha on Aug 27, 2008 at 05:57

    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

    Reply
  14. Anonymous on Aug 12, 2008 at 15:22

    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

    Reply
  15. Anonymous on Jul 8, 2008 at 11:32

    hello sir
    i am praveena.
    how can i print the values in fly from combobox to global sheet?

    Reply
  16. sasi on Mar 24, 2008 at 17:47

    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

    Reply
  17. Anonymous on Feb 20, 2008 at 17:29

    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

    Reply
  18. Ankur on Jan 25, 2008 at 16:46

    Please use Testing Tools forum for posting QTP related questions as I have already mentioned above.

    Reply
  19. Anonymous on Jan 25, 2008 at 16:35

    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.

    Reply
  20. Anonymous on Jan 21, 2008 at 17:30

    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

    Reply
  22. rajesh on Jan 10, 2008 at 17:36

    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?????

    Reply
  23. Anonymous on Dec 26, 2007 at 18:15

    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?

    Reply
  24. sairam on Dec 21, 2007 at 02:09

    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

    Reply
  25. Deepak on Jul 19, 2007 at 12:03

    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.

    Reply
  26. Anonymous on Jun 18, 2007 at 13:37

    What is a difference between Column width and Text Length?

    Reply

Submit a Comment

Your email address will not be published. Required fields are marked *