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 Cells and text

Wrapped multi-line status cells

Turns on wrap text and top vertical alignment so long status notes containing newlines render as readable paragraphs, with column widths set wide enough to show them.

Write.cs

using FormulaEngineer.Api;
using FormulaEngineer.Api.Styling;
using FormulaEngineer.Licensing;

var headerStyle =
		ExcelStyle.Default.With(
				font: ExcelFontStyle.Default.With(
						bold: true,
						color: ExcelColor.FromRgb(255, 255, 255)),
				fill: ExcelFillStyle.Solid(
						ExcelColor.FromRgb(31, 78, 121)));

var wrappedStyle =
		ExcelStyle.Default.With(
				alignment: ExcelAlignmentStyle.Default.With(
						wrapText: true,
						vertical: ExcelVerticalAlignment.Top));

using (var writer = new ExcelStyledWriter("wrapped-status-cells.xlsx"))
{
	using (var sheet = writer.CreateWorksheet("Status"))
	{
		sheet.SetColumnStyle(
				1,
				ExcelColumnStyle.Default.With(width: 18d));

		sheet.SetColumnStyle(
				2,
				ExcelColumnStyle.Default.With(width: 42d));

		sheet.WriteRow(
				new object?[] { "Task", "Status notes" },
				headerStyle);

		sheet.WriteRow(
				new object?[]
				{
								"Import",
								"Completed successfully.\nAll rows were validated before the workbook was saved."
				},
				new ExcelStyle?[] { null, wrappedStyle });

		sheet.WriteRow(
				new object?[]
				{
								"Review",
								"Pending approval.\nFinance team must confirm the final amount."
				},
				new ExcelStyle?[] { null, wrappedStyle });
	}

	writer.Close();
}

Previous Next

Style your own workbooks

Styling is part of the same package — no separate install, no Excel, no COM automation.

Get FormulaEngineer on NuGet Contact for styling questions