Spreadsheet pikeun manusa jeung agén.

import mog

wb = mog.create_workbook()
ws = wb.active_sheet()

# Set values and formulas
ws.set_cell("A1", "Revenue")
ws.set_cell("A2", 150000)
ws.set_cell("A3", "=A2 * 1.15")

# Dynamic arrays just work
ws.set_cell("B1", '=FILTER(A1:A3, A1:A3>100000)')

# Convert to pandas DataFrame
wb.calculate()
df = ws.to_dataframe()

wb.save("forecast.xlsx")

import { createWorkbook } from "@mog-sdk/node";

const wb = await createWorkbook();
const ws = wb.getActiveSheet();

// Set values and formulas
await ws.setCell("A1", "Revenue");
await ws.setCell("A2", 150000);
await ws.setCell("A3", "=A2 * 1.15");

// Structured table references
await ws.tables.add({ range: "A1:A3", name: "Forecast" });
await ws.setCell("B1", "=Forecast[@Revenue]");

// Batch operations into a single undo step
await wb.batch(async () => {
  await ws.setRange("C1:C3", [["Q2"], [170000], ["=C2*1.15"]]);
});