Reputation: 13
I have Excel file with header and few data ,i have to read Excel file without using oledb provider because i need to install oledb provider on server so i don't have a permission. Is there any alternative solution.
is it possible to read excel file using pure .net framework? if possible then what are the ways to read Excel file.
Upvotes: 0
Views: 2860
Reputation: 300529
You can use EPPLus to read and write Excel files without OLEDB or Office installed:
EPPlus is a .net library that reads and writes Excel 2007/2010 files using the Open Office Xml format (xlsx).
Upvotes: 1