Example #1
0
        private ExcelXml PrepareXL(out List <PrintColumn> cols)
        {
            ExcelXml excel = new ExcelXml();

            excel.AddDefaultStyles();
            excel.AddDefaultWorksheet("Report", "", true, "Список");

            Dictionary <string, PrintColumn> dList = new Dictionary <string, PrintColumn>();

            cols = InitPrintColumn();

            foreach (PrintColumn col in cols)
            {
                excel.AddColumn(col.Width, true, col.GetStyleID());
            }

            excel.AddRow("H3");
            excel.AddRepeatedRows(1, 1);

            foreach (PrintColumn col in cols)
            {
                excel.AddCell(col.ColumnCaption);
            }
            return(excel);
        }