Read a sheet
sheet://host/file/query/read
{
"path": "/data/wyciag.xlsx"
}
Accounting connector
Spreadsheet I/O (XLSX/CSV)
sheet:// makes spreadsheet I/O a first-class URI. sheet://host/file/query/read returns {columns, rows} from a .xlsx (any tab) or .csv — for ingesting bank statements and accounting exports. sheet://host/file/command/write writes a list of row dicts to .xlsx or .csv (chosen by extension), with an optional per-column SUM footer — for turning parsed invoice / KSeF VAT-register rows into an Excel an accountant opens. sheet://host/file/query/info lists sheets + dimensions. CSV needs no extra deps; XLSX needs openpyxl (pip).
Co robi
- Read a bank statement or accounting export as columns + rows.
- Write parsed invoice / VAT-register rows to an XLSX an accountant opens.
- List the sheets and dimensions of a workbook.
Schematy URI
sheet://
Wymagania
ArrayArrayArray
Trasy
Przykłady
Write rows
sheet://host/file/command/write
{
"path": "/out/rejestr-vat.xlsx",
"rows": [
{
"nip": "123",
"gross": 123
}
]
}
Komenda instalacji
curl -fsSL 'https://connect.ifuri.com/install?connectors=sheet' | bash
Wpis rejestru
{
"id": "sheet",
"name": "Spreadsheet I/O (XLSX/CSV)",
"status": "available",
"uriSchemes": [
"sheet"
],
"routes": [
"sheet://host/file/query/read",
"sheet://host/file/command/write",
"sheet://host/file/query/info"
],
"install": {
"mode": "urirun-extra",
"pipSpec": "urirun-connector-sheet @ git+https://github.com/if-uri/urirun-connector-sheet.git@v0.1.0"
},
"hubUrl": "https://connect.ifuri.com/connectors/sheet"
}