How to read / Write Excel Files without using OLEDB

Question

User-1501335889 posted

Hi,

I want a solution to read/write excel files without using OLEDB and also should not have any dependeny on exce i.e. it is not required to install Excel on client machines or on server where my application is hosted. Any third party component or open source would work.

Thanks

Answer 1

User1283497924 posted

Hi,

check the link

http://forums.asp.net/t/1616826.aspx/1

http://www.codeproject.com/Articles/37055/Working-with-MS-Excel-xls-xlsx-Using-MDAC-and-Oled

http://codehill.com/2009/01/reading-excel-2003-and-2007-files-using-oledb/

http://www.aspsnippets.com/Articles/Read-and-Import-Excel-Sheet-into-ASP.Net-GridView-Control.aspx

Answer 2

User-1501335889 posted

Hi,

All the links use OLEDB for excel intraction, I do not want to use OLEDB as I have mentioned.

Thanks