FormulaEngineer examples
Create, read, and style Excel workbooks in .NET.
Style workbooks as you write them — fonts, fills, borders,
number formats, alignment, and layout — using
ExcelStyledWriter. Every example below is a complete,
runnable snippet.
Group
Cells and text
10
Layout
10
Conditional formatting
6
Named styles and themes
4
Tables and notes
10
Images and shapes
4
Charts and sparklines
6
Dashboards
4
Example
10
examples
in Tables and notes
Department budget table
EnableTablesA four-column budget table carrying a variance formula per row, using a lighter built-in table style than the default.
Write.cs
using FormulaEngineer.Api;
using FormulaEngineer.Api.Styling;
var stylingOptions =
new ExcelStylingOptions
{
EnableTables = true
};
using (var writer = new ExcelStyledWriter("department-budget-table.xlsx", null, stylingOptions))
{
using (var sheet = writer.CreateWorksheet("Budget"))
{
sheet.WriteRow("Department", "Budget", "Actual", "Variance");
sheet.WriteRow("Engineering", 50000m, 47250m, ExcelFormula.From("B2-C2"));
sheet.WriteRow("Marketing", 25000m, 26890m, ExcelFormula.From("B3-C3"));
sheet.WriteRow("Operations", 30000m, 29110m, ExcelFormula.From("B4-C4"));
sheet.AddTable(
ExcelTable.Create(
"BudgetTable",
"A1:D4",
new[]
{
ExcelTableColumn.Create("Department"),
ExcelTableColumn.Create("Budget"),
ExcelTableColumn.Create("Actual"),
ExcelTableColumn.Create("Variance")
},
ExcelTableStyle.Create("TableStyleLight9")));
}
writer.Close();
}
Style your own workbooks
Styling is part of the same package — no separate install, no Excel, no COM automation.