fede186 fede186 - 1 year ago 74
C# Question

Take only a portion of rows in an Excel file

I have an excel sheet with 98 columns and 58 rows
I saw that with code

IXLRow row = ws.Row(6);

the line takes the A6 column to the last XFD6.
There is the option to take only up to 98 or say to take only the columns are not empty?

Thank you

Answer Source

If you're after specifically IXLRow, I don't think it's possible. If you're after getting or setting values for the specific range, you might want to check either Cells property of the worksheet:


or the Range property of the Worksheet:

ws.Range("A1", "CT58")