public void SetTextHeaderTable(Worksheet sheet) { sheet[0, 0].Value = ""; int mountStart = shedule != null ? shedule.FirstDaySem.Month : 9;//сентябрь по умолчанию SetMonthsHeader(sheet, mountStart, 0, 1, 5); sheet[6, 0].Value = "День"; FontOptionsBase font = (FontOptionsBase)sheet[6, 0].Font; font.Bold = true; AlignmentOptionsBase alOptR = (AlignmentOptionsBase)sheet[6, 0].Alignment; alOptR.Rotate = 90; BorderOptionsBase brOptC = (BorderOptionsBase)sheet[6, 0].Border; brOptC.Color = Color.Black; brOptC.Sides = BorderSides.All; sheet[7, 0].Value = "Часы"; font = (FontOptionsBase)sheet[7, 0].Font; font.Bold = true; alOptR = (AlignmentOptionsBase)sheet[7, 0].Alignment; alOptR.Rotate = 90; brOptC = (BorderOptionsBase)sheet[7, 0].Border; brOptC.Color = Color.Black; brOptC.Sides = BorderSides.All; }
internal void MakeCellAlignment(int row, int column, HorizontalAlignment horizontal, VerticalAlignment vertical) { AlignmentOptionsBase ao = sheet[column - 1, row - 1].Alignment as AlignmentOptionsBase; ao.Horizontal = horizontal; ao.Vertical = vertical; }
public void Export() { lsnCntMult = shedule.Setting.CountLessonsOfDay; book = new ExcelXmlWorkbook(); Worksheet sheet = book[0]; sheet.FreezeTopRows = 1; sheet.FreezeLeftColumns = 8; sheet.PrintOptions.Orientation = PageOrientation.Landscape; sheet.PrintOptions.SetMargins(0.5, 0.4, 0.5, 0.4); AlignmentOptionsBase alOpt = (AlignmentOptionsBase)sheet.Alignment; alOpt.Horizontal = Yogesh.ExcelXml.HorizontalAlignment.Center; alOpt.ShrinkToFit = true; alOpt.Vertical = VerticalAlignment.Center; alOpt.WrapText = true; FontOptionsBase font = (FontOptionsBase)sheet.Font; font.Name = "Arial"; SetTextHeaderTable(sheet); SetWeeksHeaderTable(sheet); SetDaysTable(sheet, 1, 6, 1, 6); SetDaysTable(sheet, 1, 6, 6 * lsnCntMult * lessonHorizontalMult + 1, 12); int monthStart = shedule.FirstDaySem.Month; FillDays(sheet, monthStart, 1, Week.FirstWeek, Week.TreeWeek); FillDays(sheet, monthStart, 6 * lsnCntMult * lessonHorizontalMult + 1, Week.SecondWeek, Week.FourWeek); FillHours(sheet, 1); FillHours(sheet, 6 * lsnCntMult * lessonHorizontalMult + 1); int counter = 0; foreach (string name in nameElements) { FillEntitiesData(sheet, name, 8 + counter); counter += 2; } SetColumnSize(sheet); SaveToFile(book); }
public void SetMonthsHeader(Worksheet sheet, int monthStart, int rowIndex, int columnIndexStart, int columnIndexEnd) { for (int counterClmn = columnIndexStart, counterMonth = monthStart; counterClmn <= columnIndexEnd; counterClmn++) { sheet[counterClmn, rowIndex].Value = GetMonthName(counterMonth); FontOptionsBase font = (FontOptionsBase)sheet[counterClmn, rowIndex].Font; font.Bold = true; counterMonth = counterMonth == 12 ? 1 : counterMonth + 1; AlignmentOptionsBase alOptR = (AlignmentOptionsBase)sheet[counterClmn, rowIndex].Alignment; alOptR.Rotate = 90; BorderOptionsBase brOptC = (BorderOptionsBase)sheet[counterClmn, rowIndex].Border; brOptC.Color = Color.Black; brOptC.Sides = BorderSides.All; } }
public void SetDaysTable(Worksheet sheet, int dayStart, int columnIndex, int rowIndexStart, int rowIndexEnd) { for (int counterRow = rowIndexStart, counterDay = dayStart; counterRow <= rowIndexEnd * lsnCntMult * lessonHorizontalMult; counterRow += lsnCntMult * lessonHorizontalMult, counterDay++) { sheet[columnIndex, counterRow].Value = GetDayName(counterDay); FontOptionsBase font = (FontOptionsBase)sheet[columnIndex, counterRow].Font; font.Bold = true; AlignmentOptionsBase alOptR = (AlignmentOptionsBase)sheet[columnIndex, counterRow].Alignment; alOptR.Rotate = 90; Range range = new Range(sheet[columnIndex, counterRow], sheet[columnIndex, counterRow + lsnCntMult * lessonHorizontalMult - 1]); range.Merge(); BorderOptionsBase brOptC = (BorderOptionsBase)range.Border; brOptC.Color = Color.Black; brOptC.Sides = BorderSides.All; } }
void SetWeeksHeaderTable(Worksheet sheet) { int i = 1; string week1 = "I" + Environment.NewLine + "Н Е Д Е Л Я"; sheet[0, i].Value = week1; FontOptionsBase font = (FontOptionsBase)sheet[0, i].Font; font.Bold = true; AlignmentOptionsBase alOptR = (AlignmentOptionsBase)sheet[0, i].Alignment; alOptR.Rotate = 90; Range range = new Range(sheet[0, i], sheet[0, (i + lsnCntMult - 1) * 6 * lessonHorizontalMult]); range.Merge(); BorderOptionsBase brOptC = (BorderOptionsBase)range.Border; brOptC.Color = Color.Black; brOptC.Sides = BorderSides.All; i += 6 * lsnCntMult * lessonHorizontalMult; string week2 = "II" + Environment.NewLine + "Н Е Д Е Л Я"; sheet[0, i].Value = week2; font = (FontOptionsBase)sheet[0, i].Font; font.Bold = true; alOptR = (AlignmentOptionsBase)sheet[0, i].Alignment; alOptR.Rotate = 90; range = new Range(sheet[0, i], sheet[0, i * 2 - 2]); range.Merge(); brOptC = (BorderOptionsBase)range.Border; brOptC.Color = Color.Black; brOptC.Sides = BorderSides.All; }