Select only one column values from Excel

Question

So I'm using C# to read through an Excel (.xlsm) file, everything is fine... Until all I want to do is read one column. That's all I want to do, some sample code here:

Worksheet sheet = (Worksheet)workBookIn.Sheets[sheetName];
Range r =
    sheet.get_range("B2", sheet.Cells.SpecialCells(XlCellType.xlCellTypeLastCell));
Array vals = pitch.Cells.Value;

Also, if anyone could suggest a more elegant approach to the latter part of the code (i.e. processing the range of Excel values), please feel free to comment.

It works, but not the way in which I want it; i.e. it is selecting beyond the B column. — user1092809, Dec 12 '12 at 16:22
The answer to http://stackoverflow.com/a/16051/16391 addresses what you need here. — StingyJack, Dec 12 '12 at 16:23

score 2 · Accepted Answer · answered Dec 12 '12 at 16:41

2

Worksheet sheet = (Worksheet)workBookIn.Sheets[sheetName];
Range r =
    sheet.get_range("B2", "B" + sheet.Cells.SpecialCells(XlCellType.xlCellTypeLastCell).Row);
Array vals = pitch.Cells.Value;

answered Dec 12 '12 at 16:41

InContext

2,461
12
24

Select only one column values from Excel

1 Answers1