Foxhole Atheist
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment