New To UFT? Join the best UFT Training Online!

Micro Focus QTP (UFT) Forums › Micro Focus UFT (earlier known as QTP) › UFT / QTP Beginners v
How to get data from an xml to excel which have more than 65000 rows

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Modes
How to get data from an xml to excel which have more than 65000 rows
Saket Offline
Super Senior Member
*****
Posts: 1,199
Threads: 5
Joined: Nov 2008
Reputation: 0
#2
Solved: 12 Years, 10 Months, 3 Weeks ago 11-03-2010, 12:20 PM
Basically this is a limit in excel and so in QTP.
what you can do is once you get the row > 65000 then add a new sheet and start writing into it.
By the way , I can see that you are finally exporting it to a excel file, why dont you directly wirte into a excel sheet rather in datatable.

Find
Reply


Messages In This Thread
RE: How to get data from an xml to excel which have more than 65000 rows - by Saket - 11-03-2010, 12:20 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Multiple rows of test data Bhuvana 0 1,670 01-03-2020, 09:30 PM
Last Post: Bhuvana
  Want to read the data from excel and set read value in the JavaTable rajeevk7 0 2,747 07-10-2017, 04:20 PM
Last Post: rajeevk7
  dtLocalSheet empty even though excel file contains data cantorre 2 3,014 05-10-2017, 12:47 PM
Last Post: vidhi
  Reading data from excel sheet serenediva 1 10,397 03-03-2017, 10:07 AM
Last Post: vinod123
  Adding data into rows that add dynamically with setcelldata azar81 4 6,567 04-13-2015, 05:24 PM
Last Post: vidya2k2

Forum Jump:


Users browsing this thread: 1 Guest(s)