Wednesday, April 3, 2013

How to tell if a chosen range is in the used section of spreadsheet

this is what I did:
I unioned the existing used range with chosen range and checked for equality

if (!worksheet.UsedRange.Union(chosenrange).Equals(worksheet.UsedRange))
throw new EExcelUtilsRangeOutOfBoundsOfData();

No comments:

Post a Comment