C# read data from excel file

Great post. Just what I was looking for. Thank you so much. Btw, what will happen with apps built with EPPlus once it stops being free? Awesome Rick, thank you. Do you have a recomendation on something to use to convert xlsx to pdf? ExportAsFixedFormat Microsoft. Recommending three different soon to be dead and unsupported open source. That means you get less than 2 years before you have to pay the expense to rewrite all of your Excel file handling code.

Continue driving your car without any maintenance change of the oil. ExcelReaderFactory worked great for me so far. I already have a csv implementation very similar so I just needed to tweak it slightly to load into same format. Your email address will not be published. NET QnA. Join over 3, subscribers who are receiving our weekly post digest, a roundup of this weeks blog posts. We hate spam. Your email address will not be sold or shared with anyone else.

However keep in mind that OpenXML only works with the newer. You can try ZetExcel. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. How to read an excel file in C without using Microsoft. Excel libraries Ask Question. Asked 9 years, 11 months ago. Active 2 years, 5 months ago. Viewed k times. Improve this question. Jeremy Thompson 55k 26 26 gold badges silver badges bronze badges. Add a comment. Active Oldest Votes. They both work perfectly.

They have absolutely no dependency on anything. Cell iRow, iCol. Cell 6, iCol. Improve this answer. Mohammad Dehghan Mohammad Dehghan ExcelDataReader is migrating to GitHub : github. Aleksandar Vucetic Aleksandar Vucetic Aleksandar , does this solution also works on linux? What is the namespace required? Value; Console.

Jeremy Thompson Jeremy Thompson 55k 26 26 gold badges silver badges bronze badges. Manfred Radlwimmer You can try OleDB to read data from excel file. Please try as follow.. Fill dsExcel ; conn. Close ;. I have used Excel. ReleaseComObject xlRange ; Marshal. Close ; Marshal. Quit ; Marshal.

Generic; using System. IO; using System. Linq; using System. InteropServices; using System. Text; using System. Written by Teddy Garland. Related protips. How to convert json to csv excel. Best regards, Otmar. MyTestdata This is with the exact same reference and using directive you specify here.

Thank you for this. Thanks , I have been used many approaches but, only this has helped Tim Carter. Have a fresh tip? Share with Coderwall community!

Best Excel Authors. STK