Link to home
Start Free TrialLog in
Avatar of Michael Sterling
Michael SterlingFlag for United States of America

asked on

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

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=12.0.0.0, 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;");

_con.Open();

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?
SOLUTION
Avatar of Bob Learned
Bob Learned
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Michael Sterling

ASKER

@TheLearnedOne: ok so then how do i process the excel spreadsheet? Are there examples some where?
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
thank you