/// <summary>Creates a new Worksheet.</summary> /// <param name="data">The data.</param> /// <param name="sheetName">Name of the sheet.</param> /// <param name="workbookAuthor">The workbook author.</param> /// <param name="workbookTitle">The workbook title.</param> /// <param name="orientation">The orientation.</param> public void WorkSheet_New(pcExcelData_ data, string sheetName, string workbookAuthor = "", string workbookTitle = "", enExcel_Orientation orientation = enExcel_Orientation.Portrait) { var workbook = Workbook_New(workbookAuthor, workbookTitle); WorkSheet_New(data, workbook, sheetName, orientation); }
/// <summary>Creates a new Worksheet.</summary> /// <param name="sheetName">Name of the sheet.</param> /// <param name="orientation">The orientation.</param> /// <param name="workbookAuthor">The workbook author.</param> /// <param name="workbookTitle">The workbook title.</param> public void WorkSheet_New(string sheetName, enExcel_Orientation orientation = enExcel_Orientation.Portrait, string workbookAuthor = "", string workbookTitle = "") { _lamed.lib.Excel.WorkSheet.WorkSheet_New(this, sheetName, workbookAuthor, workbookTitle, orientation); }
/// <summary>Creates a new Worksheet.</summary> /// <param name="data">The data.</param> /// <param name="workbook">The workbook.</param> /// <param name="sheetName">Name of the sheet.</param> /// <param name="orientation">The orientation.</param> internal void WorkSheet_New(pcExcelData_ data, Workbook workbook, string sheetName, enExcel_Orientation orientation = enExcel_Orientation.Portrait) { var sheet = new Worksheet(sheetName); workbook.Add(sheet); sheet.PageSetup.Orientation = (enOrientation)orientation; sheet.PageSetup.PrintRepeatRows = 2; sheet.PageSetup.PrintRepeatColumns = 2; data._sheet = sheet; }