Gravicode.OfficeNet 1.0.0

OfficeNet

Bahasa Indonesia

Word, Excel, PowerPoint and PDF for .NET 10 — no Office install, no native dependency, identical output on Windows, Linux and macOS.

OfficeNet is a rewrite of the Python document stack. Each library mirrors one of the originals and keeps its shape, so if you know the Python you already know the API.

Dibuat oleh Gravicode Studios, dipimpin oleh Kang Fadhil.

Install

dotnet add package Gravicode.OfficeNet          # everything
dotnet add package Gravicode.OfficeNet.WordNet  # or just the one you need

Quick start

Word

using WordNet;
using OfficeNet.Core;

using var doc = WordDocument.Create();
doc.Properties.Title = "Annual Report";

doc.Section.SetPageSize("A4");
doc.Section.SetMargins(Units.Cm(2.5));

doc.AddHeading("Annual Report", 0);
doc.AddParagraph("Prepared by Gravicode Studios.", "Subtitle");

doc.AddHeading("Summary", 1);
var p = doc.AddParagraph();
p.Alignment = ParagraphAlignment.Justify;
p.AddRun("Revenue grew ");
p.AddRun("32%", bold: true);
p.AddRun(" year on year.");

doc.AddList(["Word", "Excel", "PowerPoint", "PDF"]);

doc.AddTable(new[]
{
    new[] { "Region", "Revenue" },
    new[] { "Jakarta", "1,250" },
    new[] { "Bandung", "980" },
});

doc.Save("report.docx");
doc.SaveAsPdf("report.pdf");

Excel

using ExcelNet;
using ExcelNet.Styles;

using var wb = Workbook.Create("Sales");
var sheet = wb["Sales"];

sheet.WriteHeader("A1", ["Date", "Product", "Qty", "Price", "Total"]);

sheet["A2"].Set(new DateTime(2026, 1, 15));
sheet["B2"].Set("WordNet");
sheet["C2"].Set(12);
sheet["D2"].Set(85_000.0).WithNumberFormat(NumberFormats.Rupiah);
sheet["E2"].SetFormula("C2*D2").WithNumberFormat(NumberFormats.Rupiah);

sheet["E3"].SetFormula("SUM(E2:E2)");
wb.Recalculate();                 // fills the cached results Excel would compute on open

Console.WriteLine(sheet["E2"].Number);   // 1020000

sheet.AddColorScale("C2:C100", OfficeColor.Red, OfficeColor.Green);
sheet.AutoFitColumns();

wb.Save("sales.xlsx");
wb.SaveAsPdf("sales.pdf");

DataFrames. ExcelNet does not reimplement pandas — it bridges to GraviFrame, the pandas analogue Gravicode Studios already built:

using ExcelNet.DataFrames;

var frame = sheet.ToDataFrame();
var byRegion = frame.GroupBy("Region").Sum("Total");
wb.WriteDataFrame(byRegion, "Summary");

PowerPoint

using PowerPointNet;
using PowerPointNet.Charts;

using var deck = Presentation.Create();          // 16:9, master + 6 layouts + theme

deck.AddTitleSlide("OfficeNet", "Four libraries, one API");
deck.AddBulletSlide("Components", ["WordNet", "ExcelNet", "PowerPointNet", "PdfNet"]);

var slide = deck.AddSlide(2);
slide.SetTitle("Revenue by region");
slide.AddChart(new ChartData
{
    Type = ChartType.Column,
    Categories = ["Jakarta", "Bandung", "Surabaya"],
    Series = [new ChartSeries("2026", [150, 110, 105])],
    ValueFormat = "#,##0",
    ShowDataLabels = true,
});

deck.Save("deck.pptx");
deck.SaveAsPdf("deck.pdf");

HTML → slides, the feature PptxGenJS calls html2ppt:

using PowerPointNet.Html;

using var deck = HtmlToSlides.CreatePresentation(html, new HtmlSlideOptions
{
    TitleSlide = "Q1 Review",
    SplitOnHeadingLevel = 2,     // h1 and h2 start a new slide
});

Headings become slide titles, content below them becomes the body, and anything that does not fit paginates onto a continuation slide. Inline formatting — bold, italic, underline, colour, font, size, links — survives run by run. TableToSlides splits one large table across as many slides as it needs, repeating the header row.

PDF

using PdfNet.Document;
using PdfNet.Content;

// Merge, split, rotate
using var merged = PdfDocument.ConcatFiles(["a.pdf", "b.pdf"]);
merged.Pages.RotateAll(90);
merged.Save("merged.pdf");

// Extract
using var source = PdfDocument.Open("scan.pdf");
Console.WriteLine(source.ExtractText());
foreach (var image in source.Pages[0].ExtractImages())
    image.SaveTo("out");

// Draw
using var doc = PdfDocument.Create();
var page = doc.Pages.Add(PageSize.A4);
using (var canvas = page.OpenCanvas())
{
    canvas.TopDown = true;
    canvas.SetFont(StandardFont.HelveticaBold, 22);
    canvas.DrawText("Invoice", 50, 60);
}

// Encrypt — AES-256 by default
doc.Encrypt("user-password", "owner-password", PdfPermissions.Print);
doc.Save("invoice.pdf");

Forms fill and flatten, annotations and watermarks are one call each:

var form = AcroForm.Open(doc)!;
form.Fill(new Dictionary<string, string?> { ["name"] = "Kang Fadhil" });
form.Flatten();

page.AddHighlight([new PdfRectangle(50, 700, 200, 715)]);
page.AddWatermark("DRAFT");

Design notes

PdfNet is the leaf. Word, Excel and PowerPoint all export through it, so PDF export needs no extra dependency and behaves the same from all three.

Everything is one OPC container. .docx, .xlsx and .pptx differ only in which parts go inside; OfficeNet.Core implements the container once and all three inherit packaging, relationships, units, colour, image sniffing and metadata.

Parts the library does not model survive a round trip. Open a file, change one paragraph, save: macros, custom XML, pivot caches and vendor extensions all come back byte for byte.

Formatting is tri-state. null means inherit, false means explicitly off. That is what lets you write an unbolded word inside a bold heading — a distinction a plain bool cannot express.

Verified against an independent reader. A .docx this library writes and this library reads proves nothing about whether Word can open it, so every format is checked by a validator that shares no code with the library: content-type coverage, relationship resolution, schema child order, and the format-specific invariants Office enforces.

Building

dotnet build OfficeNet.sln -c Release
dotnet test

310 tests, zero warnings.

What is not implemented

Honest gaps, tracked in Progress.md:

• WordNet — footnotes, endnotes, comments, text boxes
• ExcelNet — charts, pivot tables, data validation, sheet protection
• PowerPointNet — SmartArt, image/video export
• PdfNet — rasterisation (PDF → image), PDF → Word/Excel conversion
• Word→PDF export handles flow layout, not floating objects, footnotes or hyphenation

Licence

MIT. Dibuat oleh Gravicode Studios, dipimpin oleh Kang Fadhil.