Office Documents Without Office

using var doc = ExcelDocument.Load("sales-data.xlsx");
var sheet = doc.WorkSheets[0];

// Read typed data from rows
var rows = sheet.RowsAs(r => new SalesRecord {
    Region = r.String("Region"),
    Revenue = r.Decimal("Revenue"),
    Growth = r.Double("Growth")
});

// Add a summary chart
var chart = sheet.AddChart(ExcelChartType.ColumnClustered);
chart.Title = "Revenue by Region";
chart.AddSeries("Revenue", rows.Select(r => r.Revenue));

doc.Save("sales-report.xlsx");

PowerPointDesignBrief brief = PowerPointDesignBrief
    .FromBrand("#008C95", "client-demo", "technical rollout proposal")
    .WithIdentity("Client Theme", footerLeft: "CLIENT", footerRight: "Service deck")
    .WithVariety(PowerPointDesignVariety.Exploratory);

var plan = new PowerPointDeckPlan()
    .AddSection("Service proposal", "Generated from a semantic plan.")
    .AddProcess("Implementation path", "The selected design handles layout.", new[] {
        new PowerPointProcessStep("Discover", "Collect constraints."),
        new PowerPointProcessStep("Design", "Choose the target model."),
        new PowerPointProcessStep("Roll out", "Deliver in waves.")
    });

var best = brief.DescribeDeckPlanAlternatives(plan, 3)
    .OrderByDescending(alternative => alternative.ContentFitScore)
    .First();

using var ppt = PowerPointPresentation.Create("proposal.pptx");
ppt.SlideSize.SetPreset(PowerPointSlideSizePreset.Screen16x9);
ppt.UseDesigner(brief, best.Index).AddSlides(plan);
ppt.Save();

var doc = MarkdownDoc.Create()
    .H1("Release Notes")
    .P("Version 2.0 brings major improvements.")
    .H2("New Features")
    .BulletList(
        "Parallel Excel operations",
        "PowerPoint chart support",
        "AOT-ready CSV module"
    )
    .H2("Performance")
    .Table(t => t.FromSequence(benchmarks,
        ("Scenario", b => b.Name),
        ("Before", b => b.Before),
        ("After", b => b.After)
    ));

var html = doc.ToHtmlFragment();
File.WriteAllText("release-notes.md", doc.ToString());

New-OfficeWord -FilePath 'Report.docx' {
    WordSection {
        WordParagraph -Text 'Monthly Report' -Style Heading1
        WordParagraph -Text 'Generated with PSWriteOffice'

        WordTable -DataTable $SalesData -Style LightGrid
    }
}

New-OfficeExcel -FilePath 'Data.xlsx' {
    ExcelSheet -Name 'Sales' {
        ExcelTable -DataTable $Records -AutoFilter -AutoFit
    }
    ExcelSheet -Name 'Charts' {
        ExcelChart -Type ColumnClustered -Title 'Revenue'
    }
}