public static string GetAddress([ExcelArgument(AllowReference = true, Description = "Range to check")] object TheRange, [ExcelArgument(AllowReference = false, Description = "Specify true if you wish to return the address in External format (E.g. [WorkbookName]SheetName!A1:C1)")] bool External, [ExcelArgument(Description = "Specify true if you wish to return the address in absolute style (E.g. $A$1:$C$1)")] bool FixedStyle, [ExcelArgument(Description = "Specify true if you wish to return the address in R1C1 Style)")] bool R1C1Style)
{
if (!Utilities.IsExcelReference(TheRange))
{
return("Not a Range");
}
ExcelRange rng = new ExcelRange(TheRange as ExcelReference);
return(rng.Address(External, FixedStyle, R1C1Style));
}