C# (CSharp) CellWriter1ByRow.WriteMergedH2 Examples

Example #1

File: ColxnSummaryExcelWriter.cs Project: peterson1/RentLog

        private void WriteTitles()
        {
            const int COL_SPAN = 8;

            _xl.MoveTo(T1_ROW, T1_COL);
            _xl.WriteMergedH1(_src.Title, 2, COL_SPAN);

            _xl.MoveTo(T1_ROW, T1_COL + COL_SPAN);
            _xl.WriteMergedH2(_src.BranchName, 1, COL_SPAN);

            _xl.MoveTo(T2_ROW, T1_COL + COL_SPAN);
            _xl.WriteMergedH2(_src.DateRangeText, 1, COL_SPAN);
        }

Example #2

File: GLRecapExcelWriter.cs Project: peterson1/RentLog

        private void WriteSheetHeader(string subTitle)
        {
            const int COL_SPAN = 8;

            _xl.MoveTo(T1_ROW, T1_COL);
            _xl.WriteMergedH1($"{_src.Title} :  {subTitle}", 2, COL_SPAN);

            _xl.MoveTo(T1_ROW, T1_COL + COL_SPAN);
            _xl.WriteMergedH2(_src.BranchName, 1, COL_SPAN);

            _xl.MoveTo(T2_ROW, T1_COL + COL_SPAN);
            _xl.WriteMergedH2(_src.DateRangeText, 1, COL_SPAN);

            _xl.MoveTo(null, 1);
            _xl.CurrentCol.Width = GAP1;
        }