Read Excel as DataTable using OpenXML and C#
Posted by Anuraj on Friday, July 11, 2014 Reading time :1 minute
.Net .Net 3.0 / 3.5 .Net 4.0 ASP.Net ASP.Net MVC
In the current project we were using OpenXML extensively for reading Excel files. Here is the code snippet, which will help you to read / convert Excel files to DataTable.
Happy Programming :)
Update : Previous code snippet had some problem, now I fixed it.
What do you think? I would like to hear your thoughts, suggestions, and questions in the comments section below.
Copyright © 2019 - Anuraj P. Blog content licensed under the Creative Commons CC BY 2.5
| Unless otherwise stated or granted, code samples licensed under the MIT license
. This is a personal blog. The opinions expressed here represent my own and not those of my employer. Hosted with ❤ by GitHub