REading excel in C#

Question

Hello all How can I read Excel in c# ? Is it possible to do without using 3rd party

Shweta Lodha · Answer

Go for OleDB. Sample code is available here: http://www.codeproject.com/Articles/8500/Reading-and-Writing-Excel-using-OLEDB

Alex Smith · Answer

Hi If you want to load and read Excel from code you could check free Excel API (http://freenetexcel.codeplex.com/) with following code snippet: Workbook workbook = new Workbook(); workbook.LoadFromFile(string fileName); If you want to open and read Excel with visual interface then you can check this component instead. http://www.e-iceblue.com/Introduce/spreadsheet-for-net.html

Nithika · Answer

Thanks Shweta Lodha I will give a try