DataGrid (Grid view) Question:
Download Questions PDF

Why does saving to XLS instance not work sometimes?

Answer:

From the Toad lists.

One of my co-workers experiences a very strange problem. When he is saving the results of a query using "Save As" into Excel Instance nothing happens. There is 1 opened Excel and it stays empty. All other "save as" option work fine (including saving into Xls File). What could be the problem?

John Dorlon replied :

*
Close excel.
*
Look in task manager.
*
If you still see excel running, kill it.

It seems that Excel gets confused as to whether it is running once or not and the hidden instance of Excel is causing the problem as it is most likely receiving the saved data. (explanation courtesy of Norm and it might even be right! LOL)
How do I name the tabs when I run a script?

Download DataGrid (Grid view) Interview Questions And Answers PDF

Previous QuestionNext Question
Why can not I set a style in my XLS SaveAs exports of DataGrid data?How do I name the tabs when I run a script?