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?

score 2 · Answer 1 · answered Oct 11 '11 at 22:27

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 '11 at 22:27

Kyle Trauberman

score 2 · Accepted Answer · answered Oct 11 '11 at 23:24

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 '11 at 23:24

Idan Arye

score -3 · Answer 3 · answered Oct 11 '11 at 22:33

-3

You can do

Sub ReadArray()

Dim MyArray As Variant

MyArray = Sheets(1).Range("A1").CurrentRegion

End Sub

[]'s

answered Oct 11 '11 at 22:33

Bruno Leite

2

-1. The question asks for C#, this code *seems* incomplete, and the question gives no context (eg. API used?) – Rob Oct 11 '11 at 23:04

3 Answers3