👁 Image
EzElement.EzOpenXml 1.9.0

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

👁 image

Print area

👁 image

License

MIT

Free Software, Hell Yeah!