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