SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Results 1 to 3 of 3
  1. #1
    Advanced Member
    Join Date
    Sep 2011
    Posts
    524
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Error while exporting DataTable!!

    Hi all,

    I am running a script in which exporting the datatable is needed after every iteration to keep it updated. But, after some random iterations, I am getting error:

    The DataTable.Export(file) operation failed
    Cannot open \\172.27.0.66\Tech QA\PA Report Automation\Port_Temp.xls file because it is already open in another application

    Line(69):"DataTable.Export("\\172.27.0.66\Tech QA\PA Report Automation\Port_Temp.xls")"

    when I hit Retry button, it does not give error again and start working fine. I checked that Port_Temp.xls file is not open and suppose, if it is open, then hitting Retry button would not have worked.

    Can anyone please let me know, what may be the cause of this error?

    Note: I am running this script on Win XP VM with IE8
    Attached Images Attached Images

  2. #2
    Moderator
    Join Date
    Oct 2010
    Location
    Norway
    Posts
    3,265
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    1 Thread(s)
    Total Downloaded
    0

    Re: Error while exporting DataTable!!

    Are you performing any other operation after the exporting the DataTable?
    Rajkumar

  3. #3
    Advanced Member gencke's Avatar
    Join Date
    Feb 2008
    Location
    Seattle, Washington, United States
    Posts
    531
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    2 Thread(s)
    Total Downloaded
    0

    Re: Error while exporting DataTable!!

    I close excel processes and that seems to have fixed my random excel failures
    Patience is like bread I say.... I ran out of that yesterday.

 

 

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.34%
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 03:51 AM.

Copyright BetaSoft Inc.