public SpreadsheetHyperLink(SpreadsheetWorksheet worksheet, SpreadsheetLocation locationToFocus)
{
var worksheetName = new string(worksheet.Name.Take(30).ToArray());
var locationRef = string.Format("{0}{1}", locationToFocus.ColumnName, locationToFocus.RowIndex);
Target = string.Format("'{0}'!{1}", worksheetName, locationRef);
DisplayValue = string.Format("Go to {0}.", worksheet.Name);
}
public void AddWorksheet(SpreadsheetWorksheet spreadsheetWorksheet)
{
_worksheets.Add(spreadsheetWorksheet);
}