Connect to excel-spreadsheet using .net odbc/oledb without ms-excel installed
Posted on 2015-01-05
i have an excel spreadsheet - myfile.xls
I have a windows 2008 server(mywin2008server) . It does not have ms-office installed on it.
I wrote a .net application(mydotnetapp.exe) in c# that connects to myfile.xls (using odbc or oledb ) and reads that file.
I want to run mydotnetapp.exe app on mywin2008server. But since it does not have ms-office or ms-excel installed, mydotnetapp.exe cannot not connect to myfile.xls
Is it possible to connect to myfile.xls even if ms-excel is not installed on that server?