CODEWITHSUNDEEP
c#excelepplus
Sami
Sami

Reputation: 125

how to identify range in EPPlus?

Is there no way to do sth like this in EPPlus

var r = ws.Cells["myRange"];

so I can identify a range and find out its location?

Start cell and start column.

Upvotes: 0

Views: 1013

Answers (1)

Sanjay
Sanjay

Reputation: 515

You can try this

ExcelNamedRange myRange = worksheet.Names["RangeName"];
int startRow = myRange.Start.Row;
int startCol = myRange.Start.Column;
int endRow = myRange.End.Row;
int endCol = myRange.End.Column;

You can also try

string address=myRange.Address;
string fullAddress= myRange.FullAddress;
string absAddress=myRange.FullAddressAbsolute;

Upvotes: 1

Related Questions