How to read excel file datas in webforms - hosted?

Question

1.00/5 (1 vote)

See more:

Hi, I have a small project in VS2015 asp.net - c#, to read excel file data's. When I run it as localhost it's working fine. But after hosting to FTP, it's not working, giving error like
"

The Microsoft Access database engine cannot open or write to the file ''. It is already opened exclusively by another user, or you need permission to view and write its data.

My Connection String - XLSX file

//String MyExcelFile = Server.MapPath(MyInput1.PostedFile.FileName); // Not Working
//String MyExcelFile = System.IO.Path.GetFullPath(Server.MapPath(MyInput1.PostedFile.FileName)); // Not Working

String MyExcelFile = MyInput1.PostedFile.FileName; // Working good in localhost
But giving error after published to ftp...........??????

String StrConn2 = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + MyExcelFile + "; Extended Properties=\"Excel 12.0; HDR=YES; \"";

String MyExcelSheet = "[Sheet1$]";
String  MySQLSelect = "select * from " + MyExcelSheet;

Thanks for the helps !

What I have tried:

Read Excel File Data using Microsoft.Ace.Oledb.12.0

Posted 18-Aug-17 16:50pm

Paramu1973

Updated 21-Aug-17 6:49am

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

BobbyStrain · Accepted Answer · 2017-08-18T17:06:00

Solution 1

One usually uses a client side application to fill a webform with data from local Excel, or other local applications. Or writes to a server Excel file for download. Microsoft makes it difficult to work with Excel via automation, even local.

Posted 18-Aug-17 17:06pm

BobbyStrain

adriancs · Accepted Answer · 2017-08-18T20:18:00

Solution 2

You can use ClosedXML as alternative, which is more reliable than Microsoft.ACE.OLEDB.

Project URL: https://github.com/ClosedXML/ClosedXML[^]

Posted 18-Aug-17 20:18pm

adriancs

RickZeeland · Accepted Answer · 2017-08-18T21:02:00

Solution 3

This seems to be a good library: EPPlus is a .net library that reads and writes Excel 2007/2010 files using the Open Office Xml format (xlsx). EPPlus-Create advanced Excel spreadsheets on the server - Home[^]

Posted 18-Aug-17 21:02pm

RickZeeland

Richard Deeming · Accepted Answer · 2017-08-21T06:49:00

Quote:

//String MyExcelFile = Server.MapPath(MyInput1.PostedFile.FileName); // Not Working
//String MyExcelFile = System.IO.Path.GetFullPath(Server.MapPath(MyInput1.PostedFile.FileName)); // Not Working
String MyExcelFile = MyInput1.PostedFile.FileName; // Working good in localhost

The FileName property returns the path - or sometimes just the name - of the file on the client.

Your code is running on the server. It does not have access to the client's file system.

It appears to work when you're debugging in Visual Studio. But that's only because, in that specific case, the client and server happen to be the same.

You have two options:

Use MyInput1.SaveAs(...) to save the file somewhere on the server, and then read the server's copy. You will need to use a random filename, since multiple users might be accessing your site at the same time, and you don't want the file from one user to overwrite the file from a different user.
Use a library which lets you read the file from a Stream, without saving it to disk. You can then pass in MyInput1.FileContent, which gives you access to the raw content of the uploaded file.