bioroffice-excel

name	bioroffice-excel
description	Create and edit Excel (.xlsx) workbooks with the BiorOffice officecli tool — cells, complex formulas (150+ functions with auto-evaluation), charts, pivot tables, conditional formatting, named ranges, data validation, sorting, and tables.

BiorOffice — Excel (.xlsx)

Use the officecli MCP tool (bioroffice extension). Read the bioroffice-office-suite skill for the calling convention. For substantive workbooks, first call {"command":"load_skill","name":"excel"} (or financial-model / data-dashboard when those fit) and follow its rules.

Cells and values

Cell paths are /SheetName/A1. Set values, formatting, and formulas with set:

{"command":"set","file":"/abs/data.xlsx","path":"/Sheet1/A1",
 "props":["value=Region","bold=true","fill=1A1A2E","color=FFFFFF"]}
{"command":"set","file":"/abs/data.xlsx","path":"/Sheet1/B2","props":["value=1250.75","format=#,##0.00"]}

Common cell props: value, formula, format (number format code), bold, italic, color, fill, border, align, wrap, merge=range, font.size, width (on columns). Bulk-fill a row: add type row with "c1=Name", "c2=Score" shorthand props.

Formulas — auto-evaluated, 150+ functions

Values starting with = are auto-detected as formulas and evaluated on save (no Excel needed). Dynamic-array functions get _xlfn. auto-prefixed.

{"command":"set","file":"/abs/data.xlsx","path":"/Sheet1/D2",
 "props":["formula==IF(C2>=90,\"A\",IF(C2>=80,\"B\",\"C\"))"]}
{"command":"set","file":"/abs/data.xlsx","path":"/Sheet1/E2",
 "props":["formula==VLOOKUP(A2,Lookup!$A$2:$B$50,2,FALSE)"]}
{"command":"set","file":"/abs/data.xlsx","path":"/Sheet1/F1",
 "props":["formula==SUMIFS(Sales!C:C,Sales!A:A,A1,Sales!B:B,\">=100\")"]}

Cross-sheet references (Sheet2!A1), absolute refs, OFFSET/INDIRECT, XLOOKUP, SUMPRODUCT, statistical and date functions are all supported. Read back the computed value with get to verify each key formula:

{"command":"get","file":"/abs/data.xlsx","path":"/Sheet1/D2"}

Sheets, tables, named ranges, validation

{"command":"add","file":"/abs/data.xlsx","parent":"/","type":"sheet","props":["name=Summary"]}
{"command":"add","file":"/abs/data.xlsx","parent":"/Sheet1","type":"table","props":["range=A1:E20","name=SalesTable","style=TableStyleMedium9"]}
{"command":"add","file":"/abs/data.xlsx","parent":"/","type":"namedrange","props":["name=TaxRate","refersTo=Summary!$B$1"]}
{"command":"add","file":"/abs/data.xlsx","parent":"/Sheet1","type":"validation","props":["range=C2:C100","type=list","formula1=\"Low,Medium,High\""]}

Charts, conditional formatting, sparklines

{"command":"add","file":"/abs/data.xlsx","parent":"/Sheet1","type":"chart",
 "props":["type=bar","data=Sheet1!A1:B10","title=Sales by Region","anchor=7,1,15,20"]}
{"command":"add","file":"/abs/data.xlsx","parent":"/Sheet1","type":"cf",
 "props":["range=B2:B100","type=colorscale"]}
{"command":"add","file":"/abs/data.xlsx","parent":"/Sheet1","type":"cf",
 "props":["range=C2:C100","type=cellIs","operator=greaterThan","value=90","fill=C6EFCE"]}

Pivot tables

{"command":"add","file":"/abs/data.xlsx","parent":"/Sheet1","type":"pivottable",
 "props":["source=Sheet1!A1:E100","rows=Region,Category","cols=Year",
          "values=Sales:sum,Qty:count","position=Summary!A3"]}

Aggregators: sum, count, average, max, min, stdDev, var… Date columns auto-group. Full schema: {"command":"help","format":"xlsx","type":"pivottable"}.

Sort and import

Sort: {"command":"set","path":"/Sheet1","props":["sort=C desc","sortHeader=true"]}. CSV import is available via the CLI import command shape in batch.

Verify

Use batch for large fills (one save cycle). Then get key formula cells to confirm computed values, {"command":"view","mode":"stats"}, validate, and {"command":"view","mode":"issues"} before delivering.