public ExcelWorksheetInstance GetWorksheet(object worksheetName) { ExcelWorksheet worksheet; if (TypeUtilities.IsString(worksheetName)) { var strWorksheetName = TypeConverter.ToString(worksheetName); worksheet = m_excelPackage.Workbook.Worksheets.FirstOrDefault(w => w.Name == strWorksheetName); if (worksheet == null) { throw new JavaScriptException(this.Engine, "Error", "A worksheet with the specified name does not exist."); } } else if (TypeUtilities.IsNumeric(worksheetName)) { var index = TypeConverter.ToInteger(worksheetName); worksheet = m_excelPackage.Workbook.Worksheets.ElementAtOrDefault(index); if (worksheet == null) { throw new JavaScriptException(this.Engine, "Error", "A worksheet at the specified index does not exist."); } } else { throw new JavaScriptException(this.Engine, "Error", "The first argument must either be the name or index of a worksheet."); } var worksheetInstance = new ExcelWorksheetInstance(this.Engine.Object.InstancePrototype, worksheet); return(worksheetInstance); }
public ExcelWorksheetInstance AddExisting(string name, ExcelWorksheetInstance worksheet) { var result = m_excelWorksheets.Add(name, worksheet.ExcelWorksheet); return(new ExcelWorksheetInstance(this.Engine.Object.InstancePrototype, result)); }