Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>You need to get a reference to the Excel application opened by your web application and still running. When you have this reference you could work with the Excel.Interop and save/close your workbook with the desired name</p> <pre><code>public bool SaveOpenExcel(string fileName) { int iSection = 0, iTries = 0; Microsoft.Office.Interop.Excel.Application oExcel; tryAgain: try { iSection = 1; // Attempting GetObject. oExcel = (Microsoft.Office.Interop.Excel.Application) System.Runtime.InteropServices.Marshal.GetActiveObject("Excel.Application"); iSection = 0; // Resume normal error handling. oExcel.ActiveWorkbook.SaveAs(@"d:\temp\running.xlsx", Microsoft.Office.Interop.Excel.XlFileFormat.xlXMLSpreadsheet, System.Type.Missing, System.Type.Missing, System.Type.Missing, System.Type.Missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, System.Type.Missing, System.Type.Missing, System.Type.Missing, System.Type.Missing, System.Type.Missing); oExcel.Quit(); oExcel = null; return true; } catch (Exception err) { if (iSection == 1) { //GetObject may have failed because the //Shell function is asynchronous; enough time has not elapsed //for GetObject to find the running Office application. Wait //1/2 seconds and retry the GetObject. If you try 20 times //and GetObject still fails, assume some other reason //for GetObject failing and exit the procedure. iTries++; if (iTries &lt; 20) { System.Threading.Thread.Sleep(500); // Wait 1/2 seconds. goto tryAgain; //resume code at the GetObject line } else { Console.WriteLine("GetObject still failing. Process ended."); return false; } } else { //iSection = 0 so use normal error handling: Console.WriteLine(err.Message); return false; } } } </code></pre> <p>This code sample has been adapted from the Microsoft Support Article regarding a similar issue with WinWord. You could <a href="http://support.microsoft.com/kb/316125" rel="nofollow">read the article</a> to better understand the problems with this kind of approach.<br> I really suggest to change your Web Application to complete its task saving the file.</p>
    singulars
    1. This table or related slice is empty.
    1. POVB.NET - save excel file opened by a web application
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USSteve
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COThanks Steve, from the link you gave, I was able to locate (http://support.microsoft.com/kb/308409) .NET version of it for Excel and it works only when the shell creates the excel file, not the one that's opened by the application.
      singulars
      1. PO
      1. USswame_sp
    2. COYou mean the web application opens the file on the remote pc?
      singulars
      1. PO
      1. USSteve
    3. COno, the file is opened on the same machine. I have updated the question with further details, please see if that helps.
      singulars
      1. PO
      1. USswame_sp
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload