How do I process an excel file on a server farm (shared server).

Posted on 2012-08-24
Last Modified: 2012-10-30
I've got a ASP .NET [C#] 3.5 web application written that lives on a server farm, (shared server). So, i've got an excel file (.xls) that i have to process, that lives in the file directory structure of my application on this same shared server / server farm. On my local machine i use:

using Excel = Microsoft.Office.Interop.Excel;

in my C# file (referencing the appropriate .dll file) and in my web config file"

<add assembly="Microsoft.Office.Interop.Excel, Version=, Culture=neutral, PublicKeyToken=71E9BCE111E9429C" />

and that works great when in my code behind i use:

OleDbConnection _con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + @"C:\Data\myExcelFile.xls;Extended Properties=Excel 12.0;");


however, in the shared server / server farm environment this does no good as i would need to register that .dll file on that shared server / server farm and this is not do-able as the owners of this shared server / server farm environment (GoDaddy) aren't goin to give me access to do this.

so my question is: Is there another way to process an excel file in this type of environment, with out the excel .dll?
Question by:mikesExpertExchange
    LVL 96

    Assisted Solution

    by:Bob Learned
    You don't need the interop library for OLEDB access:

    <add assembly="Microsoft.Office.Interop.Excel, Version=, Culture=neutral, PublicKeyToken=71E9BCE111E9429C" />

    That library is only for opening, and manipulating Excel files as spreadsheets, and has nothing to do with OLEDB.
    LVL 1

    Author Comment

    @TheLearnedOne: ok so then how do i process the excel spreadsheet? Are there examples some where?
    LVL 18

    Accepted Solution

    Look at the NuGet package LinqToExcel for a non-interop way of reading/writing an excel file.

    Gary Davis
    LVL 1

    Author Closing Comment

    thank you

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
    More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now