Exemple #1
0
        static void EasyWriterTest(string FileName)
        {
            var styles = new OpenXmlExStyles(
                new List <BaseOpenXmlExStyle>()
            {
                new BaseOpenXmlExStyle()
                {
                    FontColor = System.Drawing.Color.Crimson, IsBoldFont = true
                },
                new BaseOpenXmlExStyle()
                {
                    FontSize = 20, FontName = "Calibri", BorderColor = System.Drawing.Color.Red
                }
            });

            using var writer = new EasyWriter(FileName, styles);



            #region 1 лист
            var sheet_name_1 = "Test_sheet_name";
            writer.AddNewSheet(sheet_name_1);

            #region Надстройка страницы - кнопки группировки сверху

            writer.SetGrouping(false, false);

            #endregion

            #region Установка ширины колонок

            //Установка размеров колонок
            var width_setting = new List <WidthOpenXmlEx>
            {
                new (1, 2, 7),
                new (3, 3, 11),
                new (4, 12, 9.5),
                new (13, 13, 17),
                new (14, 14, 40),
                new (15, 16, 15),
                new (18, 20, 15)
            };
            writer.SetWidth(width_setting);

            #endregion

            var(key, value) = writer.FindStyleOrDefault(
                new BaseOpenXmlExStyle()
            {
                FontColor        = System.Drawing.Color.Crimson,
                FontSize         = 20,
                IsBoldFont       = true,
                LeftBorderStyle  = BorderStyleValues.Dashed,
                RightBorderStyle = BorderStyleValues.Dashed
            });

            #region SheetData

            writer.AddRow(3, 0, true, true);

            writer.AddCell("Test", 1, 3, 0);
            writer.AddCell("Test", 7, 3, 0);
            writer.AddRow(4, 0, true, true);
            writer.AddCell("Test", 4, 4, 1);
            writer.AddCell("Test", 5, 4, 2);
            writer.AddCell("Test", 6, 4, 3);

            writer.AddCell("Test", 7, 4, 3);

            #endregion

            #region Secondary setting

            writer.MergeCells(6, 3, 10, 5);
            writer.SetFilter(1, 5, 3, 5);


            #endregion


            #endregion

            #region 2 лист

            var sheet_name_2 = "Sheet 2.0";
            writer.AddNewSheet(sheet_name_2);

            #region Надстройка страницы - кнопки группировки сверху

            writer.SetGrouping(false, false);

            #endregion

            #region Установка ширины колонок

            writer.SetWidth(width_setting);

            #endregion

            #region SheetData

            writer.AddRow(3, 0, true, true);

            writer.AddCell("Test 2", 1, 3, 0);
            writer.AddCell("Test 2", 7, 3, 0);
            writer.AddRow(4, 0, true, true);
            writer.AddCell("Test 2", 4, 4, 1);
            writer.AddCell("Test 2", 5, 4, 2);
            writer.AddCell("Test 2", 6, 4, 3);

            writer.AddCell("Test 2", 7, 4, 3);
            writer.MergeCells(6, 3, 10, 5);

            #endregion

            #region Secondary setting

            writer.SetFilter(1, 5, 3, 5);


            #endregion


            #endregion
        }