How Do I Read The Opened Excel File Data Into Datatable?

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

I am reading the excel data into datatable and storing into database table.
But i was unable to load the excel data when excel file is opened.
Can anybody give me the solution to read the data from opened excel.

Thanks in advance.

Posted 2-Jan-16 9:55am

Member 11069263

Add a Solution

3 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)

Dave Kreskowiak · Answer 1 · 2016-01-02T11:49:00

Solution 1

You can't. The file is locked exclusive by another process no other application can open the file and read it until whatever process has locked the file closes it.

Posted 2-Jan-16 11:49am

Dave Kreskowiak

Comments

Abhinav S 3-Jan-16 0:18am

I don'[t totally agree with this. An excel can still be copied and the copy can be opened.
FileShare.ReadWrite can also be tried.

BobbyStrain · Answer 2 · 2016-01-02T14:57:00

Solution 2

Give up and open a copy. Microsoft for some reason made it nearly impossible to do anything with an open workbook except from another workbook. I searched long for a way to communicate with an open workbook, but found nothing but dead ends. Good luck.

Posted 2-Jan-16 14:57pm

BobbyStrain

Abhinav S · Answer 3 · 2016-01-02T15:48:00

Solution 3

Open the file in readonly mode for e.g. <codelang>File.OpenRead(path).
This way, even if the file is in write-open mode by some other program, the file can still be read.

There will, be, of course, no way to write to the file.

Posted 2-Jan-16 15:48pm

Abhinav S

Comments

Dave Kreskowiak 2-Jan-16 23:48pm

Actually, that's wrong. The mode of the open operation has nothing to do with the file being locked. What DOES has affect it is if the file is opened with Shared Access. By default, a file is opened with exclusive access. No other process can access the file so long as it's open exclusive. A file must be opened with Shared.Read access for another application to be able to open it in a ReadOnly mode and ONLY if the 2nd application requests a ReadOnly mode.

With Excel being used as a database file being read by OleDb, the file must be opened with Read AND Write access. This will cause the operation to fail in the file is locked or does not specify Shared.All.

Abhinav S 3-Jan-16 0:17am

Well in that case, the excel can still be copied.
So a copy of the excel can still be opened!