How to deserialize Excel file to 2-dimensional array?

Question

I have an Excel worksheet where all the fields are strings. I would like to de-serialize all the data from the excel file to a 2D array (matrix).

Any ideas how I can get started?

Idan Arye · Accepted Answer · 2011-10-11 23:24:35Z

2

If your Excel file is built like a table, you can use ADO.NET to access your Excel file like a database and pull your data via SQL.
Excel 97-2003: http://connectionstrings.com/excel#p21
Excel 2007+: http://connectionstrings.com/excel-2007#p20

answered Oct 11, 2011 at 23:24

Idan Arye

12.7k5 gold badges52 silver badges70 bronze badges

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

Comments

Kyle Trauberman · Accepted Answer · 2011-10-11 22:27:00Z

2

If you're trying to open a .xlsx file, you should use the Open Xml SDK.

If you're trying to open a .xls file, I recommend saving yourself some headaches and checking out filehelpers.sourceforge.net.

answered Oct 11, 2011 at 22:27

Kyle Trauberman

25.7k13 gold badges88 silver badges124 bronze badges