示例#1
0
        /// <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);
        }
示例#2
0
 /// <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);
 }
示例#3
0
        /// <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;
        }