How do I process an excel file on a server farm (shared server).
Posted on 2012-08-24
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=220.127.116.11, 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?