Menu
Does epplus provide a method to import data from a csv file into an Excel document?
259
EPPlus 5/6 has new methods added to the ExcelRange for exporting data to csv files, streams, strings and data tables.
EPPlus does not work with the XLS format.
NPOI : NPOI is open-source third-party library which can be used for xls, xlsx, docx files reading and writing. FileIO: The file class, from the Syste.IO namespace, makes it very easy to do simple reading and writing of a csv file. 'The below file uses NPOI dll to read the xls file type.
EPPlus is a library for working with .XLSX files, which it does incredibly well, but it does not support .CSV files.
Take a look at CsvHelper on NuGet and GitHub - it's a lightweight and high-performance library for reading and writing CSV files. You'll find the documentation and plenty of samples here. The project is regularly updated and well maintained - I've found it to be a good choice.
199
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
