How to get the cutted column range in ClosedXML?

Question

I want to apply data validation and styling to a column range, but without the header cell. Now I'm doing it in two steps:

It works, but I have to edit header cells after all other cells. And it looks like a hack, there might be a nicer way.

So, how to select the column without a top cell?

score 2 · Answer 1 · answered Jul 23 '15 at 09:32

2

If you know the number of the last row you want to style, you could use a Range() like this:

worksheet.Range(2, col1, row, col2).Style....;

If not you could get the Cells() from your column range and skip the first row like this:

worksheet.Columns(col1, col2).Cells().Where(c => c.WorksheetRow().RowNumber() != 1).Style....;

answered Jul 23 '15 at 09:32

Raidri

Filtering and editing all cells from the second to the bottom is very expensive operation. Code runs for minutes and the result file is about 10MB. That's obviosly a wrong way – astef Jul 23 '15 at 14:22
1

Try using `CellsUsed()` instead of `Cells()`. – Raidri Jul 23 '15 at 14:46
No cells are used yet – astef Jul 23 '15 at 16:31
1

Then there isn't a better alternative to your original method, I fear. – Raidri Jul 23 '15 at 17:01

score 0 · Answer 2 · answered Mar 18 '16 at 11:06

0

If myRange is your column original range (including header row), how about:

var rangeWithoutHeader = worksheet.Range(myRange.FirstCell().CellBelow(), myRange.LastCell());

answered Mar 18 '16 at 11:06

Seb Wills

2 Answers2