Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to import data from a csv into Excel using EPPlus? [closed]

Tags:

c#

csv

epplus

Does epplus provide a method to import data from a csv file into an Excel document?

like image 259
Vijay Patel Avatar asked Jul 12 '17 06:07

Vijay Patel


People also ask

Does EPPlus support CSV?

EPPlus 5/6 has new methods added to the ExcelRange for exporting data to csv files, streams, strings and data tables.

Does EPPlus support XLS?

EPPlus does not work with the XLS format.

Does Npoi support CSV?

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.


1 Answers

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.

like image 199
Pete Avatar answered Nov 01 '22 01:11

Pete