Databases
StackOverflow2013
Postsdbo
POOpening a client-side Excel file using EPPlus
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POOpening a client-side Excel file using EPPlus
    primarykey
    data
    text
    <p>I am the middle of writing a program which has to create an excel file on a client machine and then, after they have saved and updated it then I need to import it again and apply the changes to my database. The export bit of it works fine, however when I import from the web application I get zero worksheets in my workbook. If I run it on my development machine, i.e. the website is running on the same machine as the file is located then it works fine.</p> <p>My code is as follows:</p> <pre><code>try { Productsfile = new FileInfo(PathandFileName); } catch (Exception ex) { lblStatus.Text = string.Format("Error getting file info {0}", ex.Message); return; } lblStatus.Text += "File Opened succesfully " + Productsfile.FullName + Environment.NewLine; //Open and read file try { using (ExcelPackage datafile = new ExcelPackage(Productsfile)) { ExcelWorkbook wkb = datafile.Workbook; if (wkb != null) { lblStatus.Text += string.Format("The workbook is not null and there are {0} worksheets", wkb.Worksheets.Count) + Environment.NewLine; </code></pre> <p>I have confirmed that the code gets to the last label update, which tells me there are zero worksheets in the workbook, but importantly that the workbook itself is not null.</p> <p>When we created the export the following code was used, which transfers the data stream from server to client - I am wondering if something to reverse it is needed:</p> <pre><code>Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; Response.AddHeader("content-disposition", "attachment; filename=Products.xlsx"); Response.BinaryWrite(pck.GetAsByteArray()); Response.End(); </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USpnuts
    1. USAndrew
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POOpening a client-side Excel file using EPPlus
      1. USJohn Bustos
      1. VTFavorite
    2. VO
      singulars
      1. POOpening a client-side Excel file using EPPlus
      1. This table or related slice is empty.
      1. VTUpMod
    1. COA few questions: Is the file that's uploaded in the 2nd step the same file? Because in the 1st step, the user can use a different file name to save to the local client machine. Then upload a different file... Is the file exported in the 1st step generated correctly? Maybe that file had empty worksheets in the first place. That would explain the non-null workbook but empty worksheets situation.
      singulars
      1. POOpening a client-side Excel file using EPPlus
      1. USVincent Tan
    2. COHi, the file is created server side and then streamed to the users machine using the Response code above. They then select the file to upload and this is where it fails. It would appear from the research I've done that the file is assumed to be on the server and opened from there, which doesn't exist. The default for ExcelPackage when a filename doesn't exist is to create a new, blank workbook which I think explains the zero worksheets.
      singulars
      1. POOpening a client-side Excel file using EPPlus
      1. USAndrew
 

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