public Range(Worksheet ws, string address)
{
this.XlRange = ws.XlWorksheet.get_Range(address);
}
public static void ShowGridlines(Excel app, Worksheet ws, bool value)
{
((XL._Worksheet)ws.XlWorksheet).Activate();
app.XlApplication.ActiveWindow.DisplayGridlines = value;
}
public Worksheet GetWorksheet(int wsNumber)
{
XL.Worksheet xlWs = this.XlWorkbook.Worksheets[wsNumber + 1]; // Excel is index-1 based.
Worksheet retValue = new Worksheet(xlWs);
return retValue;
}
public Worksheet GetWorksheet(string wsName)
{
XL.Worksheet xlWs = this.XlWorkbook.Worksheets[wsName];
Worksheet retValue = new Worksheet(xlWs);
return retValue;
}
public Worksheet GetNewWorksheet()
{
XL.Worksheet xlWs = this.XlWorkbook.Worksheets.Add(Missing.Value, Missing.Value, Missing.Value, Missing.Value);
Worksheet ws = new Worksheet(xlWs);
return ws;
}
public static void Hide(Worksheet ws)
{
ws.Hide();
}