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
Note added after streaming rows
EnableCommentsAdds a note to a cell whose row has already been written and flushed — notes are collected separately and emitted on close, so annotating does not force the sheet to be buffered.
Write.cs
using FormulaEngineer.Api;
using FormulaEngineer.Api.Styling;
var stylingOptions =
new ExcelStylingOptions
{
EnableComments = true
};
using (var writer = new ExcelStyledWriter("note-after-streamed-rows.xlsx", null, stylingOptions))
{
using (var sheet = writer.CreateWorksheet("Review"))
{
sheet.WriteRow("Item", "Status");
sheet.WriteRow("Formula validation", "Passed");
sheet.WriteRow("Workbook generation", "Passed");
sheet.WriteRow("Manual review", "Pending");
sheet.AddNote(
"B4",
ExcelNote.Create(
"Reviewer should confirm final numbers before sending.",
"Asha"));
}
writer.Close();
}
Style your own workbooks
Styling is part of the same package — no separate install, no Excel, no COM automation.