How to parse .xls file line by line using C#?

Question

How to parse .xls file line by line using C#? Or it is possible to convert from .xls to .csv file using C#?

https://drive.google.com/file/d/0B5QCp8zWvdyLQllmRk9GOHlNM2c/view?usp=sharing

The answer to this question is just a Google search away, there are a host of libraries that allow you to read XLS files even without Excel installed. You can also set up an OleDb connection and query the spreadsheet like you would query any other database. — s.m.
– s.m., Commented Jun 21, 2017 at 8:41

Mert Akcakaya · Accepted Answer · 2017-06-21 08:46:20Z

1

You can read them like a matrix, consisting of rows and columns. There are lots of libraries on NuGet to do that. Or you can look at the answers to convert it to a csv file.

answered Jun 21, 2017 at 8:46

Mert Akcakaya

3,1792 gold badges33 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Gowri Pranith Kumar · Accepted Answer · 2017-06-21 08:55:04Z

0

You can use Microsoft Excel Interop Assemblies to read the excel files .

answered Jun 21, 2017 at 8:55

Gowri Pranith Kumar

1,6852 gold badges12 silver badges22 bronze badges

Collectives™ on Stack Overflow

How to parse .xls file line by line using C#?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related