Why does saving to XLS instance not work sometimes? - 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?

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

MICROSOFT

DATAGRID

DETAILS

Question: 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?

Category	DataGrid Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.3) By 6588 users
Added on	8/31/2014
Views	69186
Rate it!

Question: 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? Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	Why can't I set a style in my XLS SaveAs exports of DataGrid data?	View Answer
	Why can't I edit the results of a query in the SQL Editor?	View Answer
	Why can't I add an entry via the grid for a table containing a CLOB column?	View Answer
	Why can't I add a new record by hitting the down arrow key in the data tab?	View Answer
	What is the OCI Buffer Array Size option for in the View - Options - Oracle - General section?	View Answer
	What is the Clone Cursor Options for on the SaveAs dialogs in the Schema Browser and (SQL) Editor?	View Answer
	My string data is all coming out as question marks!	View Answer
	How do I delete a record?	View Answer
	How do I copy a whole row or multiple rows of data?	View Answer
	How can I view the Chinese and Japanese character sets through Toad?	View Answer
	How can I see the data in nested tables?	View Answer
	How can I see nested object data?	View Answer
	How can I see TIMESTAMP and INTERVAL data?	View Answer
	Consider a sales invoice and the programmer has to save multiple items in one sales invoice. On entering the rate and qty, the amount and total amount should be automatically calculated. The invoice number will be the same for all items in that invoice. Item, Rate, Qty Amount will be in grid and total amount will be voucher wise. Please let me know the coding for that.	View Answer
	How to insert value in the combo box cell of dataGridView using insert query in C#?How to handle the data error event?	View Answer
	What is the Datagird ?	View Answer
	In DataGrid, is it possible to add rows one by one at runtime. That means after entering data in one row next row will be added.	View Answer
	How to add DateTime Control in ormal DataGrid Server Control	View Answer
	How to refresh the data in datagrid automatically	View Answer
	How to sort the data in Datagrid ? when we use DataBound event of Datagrid, I want to display te data using controls.... For an example, If i click a button, which is outside of the datagrid, entire data should be shown. 1st column in TextBoxs. second column in Drop down List Boxs.. How to bind the data in Dropdownlist,which is in DataGrid at run time? Row1 Row2 Row3 Row4 ----------------- This is the record in datagrid... When we click button (Bottom of the DataGrid), This Record should be shown... Row1 in TextBox,,, Row2 in TextBox, Row3 in DropDownlistbox, Row4 in TextBox... How to do this one? Which event we should use?	View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All DataGrid Interview Questions & Answers - Exam Mode / Learning Mode