Databases
StackOverflow2013
Postsdbo
POReading Client excel file using EPPlus
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POReading Client excel file using EPPlus
    primarykey
    data
    text
    <p>I'm trying to read and excel file from the client using EPPlus without uploading it to the server or using a file upload control. The file will be located in the same location all the time.</p> <p>Is this possible? When looking it to it, I only found solutions which read from the server or this <a href="https://stackoverflow.com/questions/17955325/opening-a-client-side-excel-file-using-epplus">one</a> which uses a file upload control which I do not want.</p> <p>If it is not possible using EPPlus, what other method would you suggest to read an excel file in ASP.net C# from a client location (network drive available to all users) without sending it to the server and using the file upload control. </p> <p>Thanks for the help!</p> <p>EDIT: So iv added this active x script on my aspx page:</p> <pre><code>&lt;script type="text/javascript"&gt; var readExcel = function() { var excel = new ActiveXObject("Excel.Application"); var excel_file = excel.Workbooks.Open("C:\\Users\\qt98512\\Desktop\\Book1.xlsx"); var excel_sheet = excel_file.Worksheets("Sheet1"); var data = excel_sheet.Cells(1, 1).Value; var data2 = excel_sheet.Cells(0, 0).Value; return data; } &lt;/script&gt; </code></pre> <p>Assuming that is correct, how do I access the returned data in my c# page? I have a button running the script like this:</p> <pre><code>protected void testbuttonExcel_Click(object sender, EventArgs e) { string text = ScriptManager.RegisterClientScriptBlock(Page, this.GetType(), "script", "readExcel();", true); } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USSafinn
    plurals
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    3. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COTo achieve what you want you need some piece of software on the client itself with enough permission to do what you want - That is only possible with some ActiveX control/JavaApplet
      singulars
      1. POReading Client excel file using EPPlus
      1. USYahia
    2. COThanks for the replies. Does not look like there is a nice way :( May have to scrap this idea.
      singulars
      1. POReading Client excel file using EPPlus
      1. USSafinn
 

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