NPOI support CSV/TSV?

c# excel csv npoi tsv
109221793 picture 109221793 · Feb 18, 2011 · Viewed 11.4k times · Source

I'm using the NPOI library with a C# application.

What I'm creating is a reporting system that automatically reads, and extracts data from an excel sheet. I was given a spec, informing me that all reports I needed to ingest in my system were in .xls format however now this appears not to be the case.

I'm wondering is it possible to read in a CSV or TSV file using the NPOI library? I've crawled the web but only seem to be able to find answers relating to the Java version of this library.

Any help would be appreciated, thanks :)

Answer

Oliver picture Oliver · Feb 18, 2011

To read csv files in .Net you should take one of these:

Related questions

How to create CSV Excel file C#?

I'm looking for a class for creating CSV Excel files. Expected features: Extremely simple to use Escapes commas and quotes so excel handles them fine Exports date and datetimes in timezone-proof format Do you know any class capable of this?

Read More
C# convert csv to xls (using existing csv file)

i believe here are lot a discussion with this matter. but i read all post and try but it never work with c#. my goal is simple that i have existing csv file. just want convert exel file and done. …

Read More
c# Error: “Could Not Find Installable ISAM” in converting Excel file into .CSV file

I'm working on a project that would be able to convert Excel files to .CSV File, I think there are some problems in my C# code that is generating and error message Could Not Find Installable ISAM, please help me …

Read More