Skip to content

README.md

Latest commit

 

History

History
62 lines (43 loc) · 1.74 KB

README.md

File metadata and controls

62 lines (43 loc) · 1.74 KB
Raw

OfficeIMO.Markup.Excel - Markup to Excel export

OfficeIMO.Markup.Excel exports the semantic OfficeIMO.Markup workbook model to editable Excel .xlsx files through OfficeIMO.Excel.

This project is built from the OfficeIMO source tree and is not published as a standalone NuGet package.

Quick start

using OfficeIMO.Markup;
using OfficeIMO.Markup.Excel;

var result = OfficeMarkupParser.Parse("""
---
profile: workbook
title: Revenue Workbook
---

@sheet {
  name: Revenue
}

::range address=A1
Product,2024,2025
A,100,120
B,80,92

::table name="RevenueTable" range=A1:C3 header=true

::formula cell=D2
=C2-B2
""");

result.Document.SaveAsExcel("revenue.xlsx", new MarkupToExcelOptions {
});

What it exports

  • Sheets, sheet-qualified ranges, and formulas.
  • Named tables and styled cell formatting.
  • Dashboard charts from inline CSV data, worksheet ranges, or sheet-qualified table sources.
  • Safe workbook defaults including gridline handling, table header freeze panes, auto-fit columns, defined-name repair, and Open XML validation controls.

Boundaries

  • Markup parsing and validation stay in OfficeIMO.Markup.
  • Workbook creation and save behavior stay in OfficeIMO.Excel.
  • This package maps semantic workbook nodes into editable Excel output.

Targets and license

Dependency footprint

  • External: None beyond the dependencies of its OfficeIMO format packages.
  • OfficeIMO: OfficeIMO.Markup and OfficeIMO.Excel; the exporter maps semantic nodes to editable workbook content.

See the complete OfficeIMO package map for related formats and conversion paths.