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