Databases
StackOverflow2013
Postsdbo
POVB.NET - save excel file opened by a web application
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POVB.NET - save excel file opened by a web application
    primarykey
    data
    text
    <p>Using VB.NET, I'm trying to save an excel file opened by a web application by clicking on the export button (file remains open with a temp name as 'Book1'). I'm trying to create an exe file using vb.net which will save the existing excel file into a given format, say xlsx or xls or html. This is a mini automation project that I want to implement with a standard product "VB.NET"</p> <p>I'm well versed in vba, where in I use the workbook index to loop on all the existing files without knowing the name of the file, in vb.net (which i'm new at) I couldn't. It's a mini-mini project, that I'm trying to implement.</p> <p>Issue: Excel Interop is unable to recognize the opened file. </p> <p>While getting the count using "workbook.count" it reports zero, but if the file is created by interop using "workbook.add" it reports the count as 1.</p> <pre><code>Imports Microsoft.Office.Interop.Excel Imports Microsoft.Office.Interop Dim xlApp As New Application fileCount1 = xlApp.Workbooks.Count </code></pre> <p>filecount1 = 0 (while watching it after the last line of above code)</p> <p>Can someone direct me towards a solution.</p> <p>thanks!!</p> <p><strong>Updates:</strong> The main idea is to use .net or vbscript or any other technology to save the file as xls or html format. This is part of the automation testing that we are trying to implement. I'm targetting vb.net as it would have better integration with MS Excel. This piece of external exe (.net) or function (vbscript) can be triggered from the automation tool.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USswame_sp
    1. USswame_sp
    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. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COYour question is [especially vague](http://stackoverflow.com/questions/how-to-ask) and lacks needed information. Please specify technologies, intent, expected results and some attempt at your problem.
      singulars
      1. POVB.NET - save excel file opened by a web application
      1. USDavid B
    2. COSure have added the tech, code and other details
      singulars
      1. POVB.NET - save excel file opened by a web application
      1. USswame_sp
    3. CODid you open a workbook? I'm not sure how you're getting the count of a workbook you haven't opened yet.
      singulars
      1. POVB.NET - save excel file opened by a web application
      1. USDavid B
 

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