SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Results 1 to 4 of 4
  1. #1
    New Member
    Join Date
    Oct 2009
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    regarding import sheet error

    hi friends,
    When i execute this line i always end with an General error statement.
    datatable.ImportSheet "E:\sample.xls", 1, 2
    Can any one give me solution for this one.
    My current version of QTP is 9.2
    Iam sure that the line as no problem interms of syntax

  2. #2
    Junior Member
    Join Date
    Nov 2009
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: regarding import sheet error

    Hi,
    when u get a general error, click on debug button and type
    describeResult(err.number) in the debug viewer. You can see the exact error message there.

    Another possible solution is, please convert that excel sheet into 97 format. Sometimes, QTP doesnt support 2007 format.


    ---------------
    Sujitha

  3. #3
    Senior Member
    Join Date
    Dec 2006
    Posts
    114
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: regarding import sheet error

    Try to give the sheet names instead of index.
    Cheers,
    Diwakar

  4. #4
    Junior Member
    Join Date
    Jul 2002
    Posts
    29
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: regarding import sheet error

    Close the excel and try it

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Search Engine Optimisation provided by DragonByte SEO v2.0.36 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Resources saved on this page: MySQL 10.00%
vBulletin Optimisation provided by vB Optimise v2.6.4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.2.8 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominate (Lite) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 12:35 AM.

Copyright BetaSoft Inc.