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
Error While Exporting Excel

Thread Rating:
  • 1 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Error While Exporting Excel
Ankesh Offline
Senior Member
****
Posts: 424
Threads: 10
Joined: Aug 2011
Reputation: 0
#1
10-21-2011, 02:49 PM
I am getting attached excel error in the script when I export the QTP datatable to excel using - DataTable.Export statement.



Attached Files Image(s)
   
Find
Reply
Ankesh Offline
Senior Member
****
Posts: 424
Threads: 10
Joined: Aug 2011
Reputation: 0
#2
10-24-2011, 12:52 PM
Any solution for the above issue? I am still facing this problem?

Any help would be appreciated?

Regards,
Ankesh
Find
Reply
parminderdhiman84 Offline
Member
***
Posts: 61
Threads: 0
Joined: Jun 2011
Reputation: 0
#3
10-24-2011, 04:00 PM
have you tried exporting the datatable manually from run time datatable? Could you please attach a copy of the exported datatable.
Find
Reply
Ankesh Offline
Senior Member
****
Posts: 424
Threads: 10
Joined: Aug 2011
Reputation: 0
#4
10-24-2011, 05:49 PM (This post was last modified: 10-24-2011, 05:52 PM by Ankesh.)
Hi Parminder,

Thanks for looking into this.

I tried exporting the run-time datatable, but i couldnt as i got the error "A general error occured while exporting the sheet."

I am attaching the error screenshot.


Attached Files Image(s)
   
Find
Reply
parminderdhiman84 Offline
Member
***
Posts: 61
Threads: 0
Joined: Jun 2011
Reputation: 0
#5
10-28-2011, 11:28 AM
Hi Ankesh,

So now we can say that there is nothing wrong with the script. I only see two possibilities of the error:

1) There might be something wrong with the data that you are trying to export
2) The version of excel and the QTP might not be compatible(did you verify the export with some sample data to excel, if that is working fine then it should not be the case)

Regards,
Parminder
Find
Reply
ravi.gajul Offline
Moderator
*****
Posts: 257
Threads: 9
Joined: Oct 2011
Reputation: 2
#6
10-28-2011, 11:48 AM
Find
Reply
Ankesh Offline
Senior Member
****
Posts: 424
Threads: 10
Joined: Aug 2011
Reputation: 0
#7
10-28-2011, 02:16 PM
Thanks Parminder and Ravi for ur support.

I will have a look at it and will update u the status.

Regards,
Ankesh
Find
Reply
Ankesh Offline
Senior Member
****
Posts: 424
Threads: 10
Joined: Aug 2011
Reputation: 0
#8
11-03-2011, 04:09 PM
Hi Ravi,

The solution provided in the Link worked for me. Big Grin
Thanks a lot for helping me out.

Regards,
Ankesh
Find
Reply
ravi.gajul Offline
Moderator
*****
Posts: 257
Threads: 9
Joined: Oct 2011
Reputation: 2
#9
11-03-2011, 05:40 PM
Find
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Error while saving an already opened Excel TurtleRock 1 3,916 08-28-2014, 06:35 PM
Last Post: dplank
  Exporting List of ltems from Weblist to Excel shayk1985 1 3,197 05-22-2013, 06:55 AM
Last Post: basanth27
  Getting ODBC error while executing the sql query in excel(DB) Shkumari 5 6,049 05-10-2013, 06:15 PM
Last Post: Shkumari
  QTP not exporting to excel vwk2 3 3,351 01-07-2013, 09:57 AM
Last Post: Ankesh
  Error:-Creation of excel sheet shwetha_m 1 3,308 02-01-2012, 08:42 PM
Last Post: basanth27

Forum Jump:


Users browsing this thread: 1 Guest(s)