EzElement.EzOpenXml 1.0.1

EzOpenXml

The Fastest OpenXml Creator

EzOpenXml is a closed libery for creating and editing Xml Files

Features

• Adding images
• Adding Lables
• configre print properties
• configre cells properties
• Export documents as Markdown, Excel and PDF

Code Exmples

string fileName = @"ExcelFileName.xlsx";

 using (EzSheet doc = new EzSheet(fileName))
            {
                doc.AddSheet("Sheet1");//you must atleast have one sheet

                FillConfig fill = new FillConfig()
                {
                    PatternValue = EzFillPatternValues.LightGrid,
                    ForeGroundColor = "00ff00",
                    BackGroundColor = ""
                };

                BorderConfig borderConfig = new BorderConfig()
                {
                    LeftBorder = EzBorder.Dotted,
                    RightBorder = EzBorder.Double,
                    BottomBorder = EzBorder.Thick,
                    TopBorder = EzBorder.Thick,
                    BorderColor = "000000"
                };

                FontConfig fontConfig = new FontConfig()
                {
                    FontName = "Arial",
                    FontSize = 11,
                    FontColor = "FF00EE",
                    Bold = true,
                    HorizontalTextAlignment = EzHorizontalAlignment.Center,
                    VerticalTextAlignment = EzVerticalAlignment.Center,
                    NumberFormatId = EzNumberingFormat.EURO_P2
                };

                doc.FormatRangedBorder("Sheet1", "B",2, "F", 6,borderConfig);

                doc.DefinePrintArea("Sheet1", "A", 5, "hh", 10);

                doc.FormatCell("Sheet1", "b", 5, fontConfig, fill, null);

                doc.MergeCells("Sheet1", "B", 5, "C", 100);

                doc.PlantValue("Sheet1", "b", 5, 550000.05);

                doc.AddSheet("Sheet2");

                doc.MergeCells("Sheet2", "b", 5, "c", 10);

                doc.PlantValue("Sheet2", "b5", "hey");

                doc.FormatCell("Sheet2", "b", 5, null, null, null);
                doc.FormatCell("Sheet2", "b", 5, fontConfig, fill, null);

                doc.AlterDefaultCellDimentions("Sheet2", 3, 3);
                doc.DefinePrintArea("Sheet2", "A", 5, "hh", 10);
                doc.AlterSheetFitToOnePage("Sheet2", true);
                doc.AlterSheetTabColor("Sheet2", "00ff00");

                doc.PlantValue("Sheet2", "c5", "bye");

            }

License

MIT

Free Software, Hell Yeah!