Retrieving data from an Excel file in a .NET app

Question

0.00/5 (No votes)

See more:

In my ASP website I use 'Microsoft.ACE.OLEDB.12.0' as the provider to get data from .xlsx Excel sheet.
Site is hosted in two simile 64bit OS servers.

The two servers are alike and in below path of the both server,the same versions of 'ACEOLEDB.DLL' is found

C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE14\ACEOLEDB.DLL

But the issue is when I added new rows to the same .xlsx Excel sheet then one server hosted site doesn't read those new rows added while the other server hosted same site is reading the excel sheet as expected (i.e. with the added new rows)

It is obvious those two servers might be having different component to have different impact on same coding (site) reading same Excel file differently.

Can anyone please help me to track what is the different.

Posted 18-Jul-14 23:45pm

SurangiTi

Add a Solution

2 solutions

Solution 1

Excel is not a multi-user database format/file/engine so you should not expect it to use it in such a manor.

Also you should not use Office Excel automation on ASP.net sites since it will not scale and runs EXCEL.EXE in the background try using a component like : http://epplus.codeplex.com/[^]

Posted 20-Jul-14 4:06am

Mehdi Gholam

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)

SurangiTi · Accepted Answer · 2014-07-30T01:04:00

Solution 2

Using Open XML SDK 2.0 I was able to solve my issue.

Posted 30-Jul-14 1:04am

SurangiTi