EzElement.EzOpenXml 1.3.7

EzOpenXml

Creating Excel document

EzOpenXml is a highly performance closed libery for creating excel file

Features

• Edit cell values
• Edit cell formats (range, borders, merge cells and etc)
• Adding images
• Adding Lables
• Configre print properties
• Configre cells properties
• Config print area

Code Sample

using EzOpenXml;
using EzOpenXml.Enums;
using EzOpenXml.StyleConfig;

public void Example()
{
    string fileName = @"EzOpenXml.xlsx";

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

        FontConfig topHeaderFont = new FontConfig() 
        { 
            FontName = "Arial", 
            FontSize = 16, 
            FontColor = "000000", 
            Bold = true,
            HorizontalTextAlignment = EzHorizontalAlignment.Center,
            VerticalTextAlignment = EzVerticalAlignment.Center,
        };

        FontConfig headersFont = new FontConfig()
        {
            FontName = "Arial",
            FontSize = 14,
            FontColor = "000000",
            Bold = true,
            HorizontalTextAlignment = EzHorizontalAlignment.Center,
            VerticalTextAlignment = EzVerticalAlignment.Center,
        };

        FontConfig cellFont = new FontConfig()
        {
            FontName = "Arial",
            FontSize = 12,
            FontColor = "42a5f5",
            Bold = false,
            HorizontalTextAlignment = EzHorizontalAlignment.Left,
            VerticalTextAlignment = EzVerticalAlignment.Center,
        };

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

        BorderConfig headersBorder = new BorderConfig()
        {
            BottomBorder = EzBorder.Double,
            BorderColor = "000000"
        };

        FillConfig fillConfig = new FillConfig()
        {
            PatternValue = EzFillPatternValues.DarkGrid,
            ForeGroundColor = "ffffff",
            BackGroundColor = "ffee00", 
        };

        //table bordering
        doc.FormatRangedBorder("Sheet1", "b2", "d7", borderConfig);
        doc.FormatRangedBorder("Sheet1", "b2", "d2", borderConfig);

        //heqader styling
        doc.MergeCells("Sheet1", "b2", "d2");
        doc.FormatCell("Sheet1", "b2", topHeaderFont, null, null);
        doc.FormatRangedBorder("Sheet1", "b3", "d3", headersBorder);

        //col headers styling
        doc.FormatRange("Sheet1", "b3", "d3", headersFont, null, null);
        doc.AlterColRangeWidth("Sheet1", 2, 2, 7);
        doc.AlterColRangeWidth("Sheet1", 3, 3, 3);
        doc.AlterColRangeWidth("Sheet1", 4, 4, 15);

        //cells formating
        doc.FormatRange("Sheet1", "b4", "d7", cellFont, null, null);
        //overriding formating for version column to be centered
        doc.FormatRange("Sheet1", "c4", "c7", new FontConfig() { HorizontalTextAlignment = EzHorizontalAlignment.Center}, null, null);

        //table data
        string[] headers = new string[] { "Name", "Version", "Link" };
        string[] names = new string[] { "AbstractInfra", "MvvmInfra", "EzDocument", "EzOpenXml" };
        string[] versions = new string[] { "1.10.0", "2.7.0", "1.1.0", "1.0.2" };

        doc.PlantValue("Sheet1", "b2", "EzElement nugets");

        char col = 'b';
        foreach (string header in headers)
        {
            doc.PlantValue("Sheet1", $"{col}3", header);
            col++;
        }

        int row = 4;
        foreach (string name in names)
        {
            doc.PlantValue("Sheet1", $"b{row}", $"Ezelement.{name}");
            row++;
        }

        row = 4;
        foreach (string version in versions)
        {
            doc.PlantValue("Sheet1", $"c{row}", version);
            row++;
        }

        row = 4;
        foreach (string name in names)
        {
            doc.PlantValue("Sheet1", $"d{row}", "https://" + $"www.nuget.org/packages/Ezelement.{name}");
            row++;
        }

        TextBoxConfig textBoxConfig = new TextBoxConfig()
        {
            Bold = true,
            FontSize = 12,
            FontColor = "42a5f5",
            Rot = 0,
            OutLineColor = "000000",
            BackGroundColor = null,
            RightToLeftColumns = false,
            TextAlignment = EzTextAlignment.Center,
            FontAlignment = EzFontAlignment.Baseline,
            TextAnchoring = EzTextAnchoring.Center,
        };

        doc.PlantTextBox("Sheet1", "Absolute anchored textbox", 8, 5, 6, 1, textBoxConfig);
        doc.PlantTextBox("Sheet1", "One Cell anchored textbox", "b9", 0, 0, 6, 1, textBoxConfig);

        string imagePath = AppDomain.CurrentDomain.BaseDirectory + @"ezelementLogo.png";

        doc.PlantImage("Sheet1", imagePath, 0, 0, "b2",  0.18, 0.18);


        doc.DefinePrintArea("Sheet1", "a1", "e12");
    }
}

The table

Print area

License

MIT

Free Software, Hell Yeah!