Example #1
0
        internal void AddRankLeague(XLWorkbook workbook, DataTable dataRank)
        {
            IXLWorksheet worksheet = workbook.Worksheets.Add("rank_league");

            worksheet.ShowGridLines = false;

            int firstRow   = 1;
            int firstColum = 1;

            worksheet.Cell(firstRow, firstColum).Value = "Rank Pkm League";
            worksheet.Cell(firstRow, firstColum).Style.Font.SetBold(true).Font.SetFontSize(18);
            worksheet.Cell(firstRow, firstColum).Style.Alignment.SetHorizontal(XLAlignmentHorizontalValues.Center);
            worksheet.Cell(firstRow, firstColum).Style.Font.FontName = "Berlin Sans FB Demi";
            worksheet.Range(firstRow, firstColum, firstRow, dataRank.Columns.Count + 1 + firstColum).Merge();

            ExportTable.ExportTableData(worksheet, dataRank, firstRow + 1, 1);
        }