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); }