Is there a free or open source library to read out Excel files (. xlsx) directly from a C# program?
It does not have to be too fancy, simply to choose a worksheet and check out the data as strings. Far, I’ve been utilizing Export to Unicode text function of Excel, and parsing the resulting (tab-delimited) file, but I ‘d like to eliminate the manual action.
The ADO.NET approach is simple and fast, but it has a few quirks which you need to understand, specifically relating to how DataTypes are managed.
How about Excel Data Reader?
I’ve used in it anger, in a production environment, to pull big quantities of data from a range of Excel submits into SQL Server Compact. It works extremely well and it’s rather robust.
Not free, however with the most recent Office there’s a very nice automation.Net API. (there has actually been an API for a long while but was nasty COM) You can do everything you desire/ need in code all while the Office app remains a covert background process.
Recently, partly to get better at LINQ … I’ve been utilizing Excel’s automation API to save the file as XML Spreadsheet and then get process that file utilizing LINQ to XML.
If you are actually cultivating a remedy that runs in a server-side context, you should try to make use of parts that have been actually created risk-free for ignored execution. If you take advantage of an Office application from a server-side solution, the application will certainly do not have several of the needed abilities to operate efficiently.
In the event of binary file layout you need to make use of any kind of third-party elements that perform certainly not required Office/Excel put in on the maker.
I encourage the FileHelpers Collection which is actually a free-and-easy to use.NET public library to import/export information from EXCEL, restored duration or delimited records in reports, flows or even chains + Additional.
I comprehend that people have actually been actually making an Excel “extension” for this objective.
You basically produce a switch in Excel that points out “Export to Program X”, and also after that export and send out off the data in a layout the program may read.
If MS Office is actually not put in, you can’t take advantage of Microsoft Interop libraries. You may intend to examine alternate options to read through Excel or Word data. There are great deals of free of cost and (spent) C# public libraries you could use for this feature.
Excel Package is actually an open-source (GPL) part for reading/writing Excel 2007 reports. I utilized it on a small venture, and also the API is actually uncomplicated. Functions with XLSX merely (Excel 200 &), not along with XLS.
The resource code likewise seems to be well-organized as well as simple to acquire all around (if you call for to expand functionality or fix small concerns as I did).
SmartXLS is actually an additional stand out spreadsheet factor which sustain very most components of stand out Charts, strategies motors, and may read/write the excel2007 openxml format.
I tried the ADO.Net (Excel link chain) strategy, nevertheless it was actually crammed along with unpleasant hacks– for instances if 2nd line has an amount, it is going to return ints for all areas in the row specified below as well as gently go down any data that does certainly not fit.
, if you require to work merely with available XML papers (*. xslx) you could think of taking advantage of the Open XML SDK. Find Welcome to the Open XML SDK 2.5 for Office for even more details.
The.NET part Excel Reader.NET might satisfy your need. It is actually terrific enought for visiting XLSX as well as XLS data.