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

General Error While Importing Sheet In Qtp

Disgrace on Google for no longer positioning this put up upper! If the qtp is in execution mode and user stops the execution. Function GetTotalRowCount(FileNameWithPath) DataTable.Import FileNameWithPath iTotalRow=DataTable.GetRowCount GetTotalRowCount=iTotalRow End Function When I call this function two consecutive times I get error. Click on "Apply" then "Ok" to close dialogs accepting changes Note: depending on the clean up done by QTP, processing time to later show data on the Data Table pane may have a peek at this web-site

I know this is kinda off topic however , I'd figured I'd ask.Would you be interested in trading links or maybe guest authoring a blog article or vice-versa?My blog goes over Open QuickTest Professional and a new blank test script 2. This new file is of type .xls format. To start viewing messages, select the forum that you want to visit from the selection below. http://www.learnqtp.com/forums/Thread-Importing-excel-not-working

I am still working on it.' Some sample codes on excel objectsintRow=1Set excelObj=CreateObject"Excel.Application")Set workBooks = excelObj.Workbooks.Open("C:\IMPORT\abc.xls")Set workSheets = excelObj.worksheets("abc")For Each c In workSheets.Range("A1:Z1").CellsIf c.Value = "XXX" Then intCol = c.Column Exit So copying and pasting the data into a new file is very time consuming.Is there any other solution to this issue?RegardsMahesh 0 Kudos Reply ginmax Occasional Visitor Options Mark as New Value ofresExcelvariable contains alphabets, numbers and "_"2. Thanks a lot!Also see my site: savior November 26, 2012 at 5:13 PM Anonymous said...

The following error is displayed - "Unable to create the specified run results folder. If you have any suggestions, please let me know. Noted below is the HP-Mercury KB article and detailed steps for the same ************************************************************************* Issue 1: Exporting runtime datasheet to localpath.(Export error no:"-214746725 9") During runtime, when we try to export That could explain why your recovery scanario sometimes works.

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. Template images by luoman. All RSS Forum Timezone: UTC -8 Most Users Ever Online: 70Currently Online: 12 Guest(s)Currently Browsing this Page: 1 Guest(s) Top Posters: Techhelp: 1815Manu: 114Shan Nathan: 80Palanki sai charan: 67Userone: 59Vishal Anand: http://www.itelearn.com/forum/qtp-automation/general-error-occurred-while-importing-excel-sheet-to-datatable Linear ModeThreaded Mode Setup Menus in Admin Panel Login Online Courses Selenium WebDriver + Robot Framework + Python Programming Training Online AngularJS Training Online Domain Training BFSI Training Online Agile Testing

If you're interested feel free to send me an e-mail. 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 so that you can write path of the file as simple like in d: drive like datable.importsheet "D:/input.xls","dtglobalsheet",1 CN CD CRD CustomerA DescriptionA active_customers CustomerB DescriptionB add_project CustomerC DescriptionC add_more_customers_action   Thanks Find Reply « Next Oldest | Next Newest » Possibly Related Threads...

Copyright BetaSoft Inc. https://community.hpe.com/t5/Unified-Functional-Testing/Excel-sheet-import-issue-in-QTP-These-sheets-were-working-fine/td-p/5993723 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 If you find a similar thread and still have a question, reply to that topic. Also, the error message you get is back to front in that It describes the error wrong so it makes it difficult to analyse.

Then, I have the same export statement within the error handling statements. http://glitchtest.org/general-error/general-error-fcp-export.html We thought its excel version issue, so modified the sheet in different excel version(Office 2007 and office 2010) but still getting error.Please find attachedsheet to be imported after doing small change.Please Yesterday I was able to access the Excel file with no problem, today it is giving me an error. l variable is used for the sheetcount, k variable is used for the column count and j variable is used for the row count Code can be like this: colcount =

I am able to export the file without any errorsa. We were able to import them properly. 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 Source This can be done using following steps. 1.

The problem was the .xlsx as you mentioned. This works fine but problem is when we are doing any change (Delete 1strow, change column width etc) in exported sheet, it again start giving error "Invalid File". Minha contaPesquisaMapsYouTubePlayNotíciasGmailDriveAgendaGoogle+TradutorFotosMaisShoppingDocumentosLivrosBloggerContatosHangoutsOutros produtos do GoogleFazer loginCampos ocultosPesquise grupos ou mensagens Search Sign Up Sign In Quality Testing Quality is delighting customers HomeMy PageCommunityForumBlogsGroupsEventsPoll of the DayTop Content @ QTMembersChatJobsTrainingTesting ToolsFunctional Testing

I'm bookmarking and will be tweeting this to my followers!

Select Forum NoSQL .NET Big Data Hadoop ETL Testing Manual Software Testing QTP Automation Selenium Automation Web Security Testing Mobile App Testing Selenium LIVE Project Web Services SoapUI Testing ISTQB Master Superb blog by the way!Take a look at my blog ... As of now, I haven't been able to resolve the problem. You also said that removing the calls to external actions solves your problem which is sort of wierd.

InputDataSheet_MillimanRegression5--old4.xls ‏1127 KB 0 Kudos Reply All Forum Topics Previous Topic Next Topic 8 REPLIES Ryoganat1 Regular Advisor Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Highlight Print Email Come on over and consult with my website . Only change you need to do is to save the excel in .xls format. have a peek here So try reinstalling and all the best !! 0 Kudos Reply Suman04 Occasional Advisor Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Highlight Print Email to a Friend Report

January 28, 20137:48 pm Techhelp Member Forum Posts: 1815 Member Since: October 26, 2012 Offline 2 Below code will work fine. Yes, I am storing results in the Global Sheet and No, I don't have the file opened while executing the test. SPONSORS: Tweet User Tag List Thanks: 0 Likes: 0 Dislikes: 0 Results 1 to 4 of 4 Thread: A general error occurred while importing file Thread Tools Show Printable Version Search SQA Forum..

The time now is 04:31 PM. 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 add a breakpoint in the line where the excel should be exported. 2. I look forward to hearing from you!

Select a location/path and name to save this new version of XLS file • Using VBScript and QTP Automation Object Model (AOM) Note: The following script is provided for example purposes Select "Excel 97-2003 Workbook" from "Save as type" 6. Sometimes sooner. 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.

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 Someone in my Myspace group shared this website with us so I came to take a look.I'm definitely enjoying the information. I wonder if this is related. We tried deleting the temp results folder but we were not able to delete file 'Default.xls'.So every time I had to kill the QTP and its process tree to proceed. 0

Convert it to .xls format and then import. Select "Save as" 4. When we copy few rows and paste it below, it start showing the error "Invalid file".3. I am trying to export the results to excel using DataTable.ExportSheet "C:\QTPResults\executionInfo.xls","Global" and it fails!!!the only message I get is that a general error occured and that is it.