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
6
examples
in Conditional formatting
Icon set status indicators
EnableConditionalFormattingAttaches traffic-light icons to a health-score column with explicit percentage thresholds, giving an at-a-glance status column that stays numeric underneath.
Write.cs
using FormulaEngineer.Api;
using FormulaEngineer.Api.Styling;
var stylingOptions =
new ExcelStylingOptions
{
EnableConditionalFormatting = true
};
using (var writer = new ExcelStyledWriter("icon-set-status-indicators.xlsx", null, stylingOptions))
{
using (var sheet = writer.CreateWorksheet("Health"))
{
sheet.WriteRow("Service", "Health score");
sheet.WriteRow("Formula API", 95);
sheet.WriteRow("Import Worker", 70);
sheet.WriteRow("Export Worker", 42);
sheet.WriteRow("Dashboard Job", 88);
sheet.AddConditionalFormat(
"B2:B5",
ExcelConditionalFormat.IconSet(
ExcelIconSet.ThreeTrafficLights1,
new[]
{
ExcelConditionalFormatValue.Percent(0),
ExcelConditionalFormatValue.Percent(33),
ExcelConditionalFormatValue.Percent(67)
}));
}
writer.Close();
}
Style your own workbooks
Styling is part of the same package — no separate install, no Excel, no COM automation.