0

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

PAT
  • 41
  • 1
  • 6
  • 3
    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. Jun 21 '17 at 08:41

2 Answers2

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.

Mert Akcakaya
  • 3,109
  • 2
  • 31
  • 42
0

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

Test12345
  • 1,625
  • 1
  • 12
  • 21