Home > General Error > General Error While Importing Sheet In Qtp

General Error While Importing Sheet In Qtp

SQA Forum.. Showing results for  Search instead for  Do you mean  Menu Categories Solutions IT Transformation Internet of Things Topics Big Data Cloud Security Infrastructure Strategy and Technology Products Cloud Integrated Systems Networking P.S. You have created a file inside "DDAFW2" folder but when importing you are trying to get it from "DDAFW" folder. weblink

Close other program that are using this folder." The troubleshooting steps taken:1. Yes, I am storing results in the Global Sheet and No, I don't have the file opened while executing the test. call GetRowCount("C:\temp\t1.xls") call GetRowCount("C:\temp\t2.xls") I changed the code and I do not get error message. I needed to count total rows from the spread sheet so I was importing the file using following function. http://www.learnqtp.com/forums/Thread-Importing-excel-not-working

but now, I am facing this exact issue.ExportSheet used to work earlier several times, Now, all of a sudden, without any code change, this statement is failing with the same General My script run successfully, but in the very last line it fails. Try to Execute your code. I tried creating an object for this excel and read the cells from it and everything seemed to be working well but when I try to import it I get this

That was a great info Jonty........it really helpedThankyou so much November 3, 2011 at 5:14 AM Anonymous said... Εxcellent blog уou have here but І was cuгіous іf you κnew of Share opinions: Please feel free to reply, add or comment on any ongoing topics. Email: [email protected] Contact: +1-314-827-5272 +91-837-4323-742 (INDIA) Connect with us top COPYRIGHT © 2009-2015 iTeLearn.com | Powered by Atomic77 About ITeLearn Contact Terms Teach Privacy Affiliates Main MenuOnline Courses Selenium WebDriver That could explain why your recovery scanario sometimes works.

But now when we try to import it, we get invalid file error.Few Observations--1.If wecopy the samedata one by one in other excel. Contact Us ITeLearn, 18118 Parthenia Street, Northridge, CA 91325. If the sheet "Global" does not exist in the file, then it would append it to the end. As of now, I haven't been able to resolve the problem.

Anyway, I had the same problem with import sheet functionality. Thanks a lot!Also see my site: savior November 26, 2012 at 5:13 PM Anonymous said... Maybe something got corrupt within QTP. Howdy!

Please check your browser settings or contact your system administrator. https://community.hpe.com/t5/Unified-Functional-Testing/Excel-sheet-import-issue-in-QTP-These-sheets-were-working-fine/td-p/5993723 Copyright BetaSoft Inc. Have we been upgraded to death, AGAIN? 0 Kudos Reply The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. Please let me know ASAP.

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 http://meditationpc.com/general-error/general-error-last-fm.php Patience, please: Our Tech team or other members will usually try to respond within 24 hours on weekdays and max within 48 hours on weekends. I don't think it has to do with the code, since the code hasn't changed, but here is an example:dft_id=Browser("").Page("").WebElement("Draft ID").GetROProperty("innertext") 'get the draft idreporter.ReportEvent micPass,"Save As Draft Successful", dft_id&" saved Else it will be tough to get support from other members.

I wonder if this is related. I am able to export the file without any errorsa. The time now is 04:31 PM. check over here Share opinions: Please feel free to reply, add or comment on any ongoing topics.

Proper Subject: Ensure you choose a very appropriate topic name. Function GetTotalRowCount(FileNameWithPath) DataTable.Import FileNameWithPath iTotalRow=DataTable.GetRowCount GetTotalRowCount=iTotalRow End Function When I call this function two consecutive times I get error. Some times it works, and some others it doesn't :SIt is VERY weird 0 Kudos Reply Joshua S_1 Honored Contributor [Founder] Options Mark as New Bookmark Subscribe Subscribe to RSS Feed

Remember me Important News: UFT Certification has changed! (August 2016) HP QTP (UFT) Forums › HP UFT (earlier known as QTP) › VB Scripting/Descriptive Programming « Previous 1 ... 18 19

Regards, Sankalp Find Reply Adam82 Junior Member Posts: 5 Threads: 2 Joined: Jun 2012 Reputation: 0 #3 11-02-2012, 03:09 PM Hi Sankalp Thanks for the reply. I guess Excel does not support more than 256 sheets.Did you try running this on a totally new file ? 0 Kudos Reply jclosa10 Occasional Advisor Options Mark as New Bookmark Regards, Sankalp Find Reply Adam82 Junior Member Posts: 5 Threads: 2 Joined: Jun 2012 Reputation: 0 #7 11-05-2012, 05:22 PM Yes it worked now. I'm bookmarking and will be tweeting this to my followers!

If the qtp is in execution mode and user stops the execution. the path to the excel file is correct Find Reply sshukla12 Senior Member Posts: 426 Threads: 4 Joined: Aug 2011 Reputation: 0 #2 11-02-2012, 03:01 PM Hi, U want to import Contact Us ITeLearn, 18118 Parthenia Street, Northridge, CA 91325. this content and my head is drunk), but:if you guys cannot import sheet to UFT/QTP or export or whatevermake sure the file extention of your importing excel file is ".xls", not ".xlsx"also make

Under the "Data Table" field, select "Other location" option and click on the browse button ("...") 5. I'd really like to be a part of community where I can get feed-back from other knowledgeable individuals that share the same interest. Any clue? 0 Kudos Reply All Forum Topics Previous Topic Next Topic 17 REPLIES Reju George Honored Contributor [Founder] Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Highlight Print Great blog and brilliant design and style.Feel free to visit my blog post :: acheter tweet March 9, 2013 at 4:33 AM Anonymous said... Нi thеre, this weеκеnd iѕ gοоd foг

All you need to do is to save your excel file in .xls format. Find Reply Adam82 Junior Member Posts: 5 Threads: 2 Joined: Jun 2012 Reputation: 0 #4 11-02-2012, 04:56 PM My excel extenstion is .xlsx so I tried using C:\QTP\Training\Calc\Calc and C:\QTP\Training\Calc/Calc without