Пример #1
0
 public Report(string fileName)
 {
     this.fileName = fileName;
     workbook = new XSSFWorkbook();
     listSumRtkGts = new List<int>();
     cellStyles = new CellStyles(workbook);
     styleDouble = cellStyles.Double();
     styleDoubleBold = cellStyles.DoubleBold();
     styleTable = cellStyles.Table();
     styleCaption = cellStyles.Caption();
     styleDoubleGts = cellStyles.DoubleGts();
     styleGts = cellStyles.Gts();
     styleDoubleRtk = cellStyles.DoubleRtk();
     styleRtk = cellStyles.Rtk();
 }
Пример #2
0
        public SheetLimits(IWorkbook workbook, string date)
        {
            this.workbook = workbook;
            this.date = date;
            sheet = workbook.CreateSheet(date + "-Лимиты");
            summedCells = new List<int>();

            cellStyles = new CellStyles(workbook);
            styleInnerHeading = cellStyles.InnerHeadline();
            styleHeading = cellStyles.Heading();
            styleHeadingSum = cellStyles.HeadingSum();
            styleHeadline = cellStyles.Headline();
            styleTable = cellStyles.LimitsTable();
            styleDouble = cellStyles.LimitsDouble();
            styleDoubleBold = cellStyles.LimitsDoubleBold();
            styleCorpColor = cellStyles.CorpColor();
            styleLimitsDoubleSum = cellStyles.LimitsDoubleSum();
            styleResultHeadline = cellStyles.ResultHeadline();
        }