Download the PHP package particle-academy/holy-sheet without Composer
On this page you can find all versions of the php package particle-academy/holy-sheet. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download particle-academy/holy-sheet
More information about particle-academy/holy-sheet
Files in particle-academy/holy-sheet
Package holy-sheet
Short Description Standalone spreadsheet writing tool for agentic document creation. Framework-agnostic core with optional Laravel 10-13 integration.
License MIT
Homepage https://github.com/Particle-Academy/holy-sheet
FAQ
Example:
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
- Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
- To use Composer is sometimes complicated. Especially for beginners.
- Composer needs much resources. Sometimes they are not available on a simple webspace.
- If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
- Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Informations about the package holy-sheet
Holy Sheet
Standalone spreadsheet writing tool for agentic document creation.
PHP 8.2+ library for writing valid xlsx files from a JSON-shaped schema. Zero framework dependencies in the core (just ext-zip). An optional Laravel adapter — service provider, facade, artisan command — sits in HolySheet\Laravel\* and only loads when used. No HTTP routes, no controllers, no opinions about how your app exposes the writer; that's your pipeline's job.
Framework-agnostic by design
| Layer | What it requires |
|---|---|
Core (HolySheet\Agent, HolySheet\HolySheet, validator, writer, schema) |
PHP 8.2+, ext-zip. Nothing else. Works in plain PHP scripts, Symfony, Laminas, Slim, CLI tools. |
Laravel adapter (HolySheet\Laravel\*) |
Optional. Auto-registered via extra.laravel.providers if Laravel is installed; ignored otherwise. Provides facade, service provider, and php artisan holy-sheet:write command. |
The package ships no HTTP endpoints. If you need an "Export to xlsx" route, you write the controller — Holy Sheet gives you the writer + facade.
Installation
Laravel apps auto-discover the optional adapter. Non-Laravel projects use HolySheet\Agent::* directly.
Quick start
Plain PHP (Symfony, Laminas, CLI, anywhere)
Laravel (via the facade)
Why this exists
Existing PHP spreadsheet libraries are either:
- Heavy and slow (PhpSpreadsheet pulls dozens of transitive deps), or
- Tightly coupled to a single output format
Agentic flows need something different: a small, deterministic API where an LLM can describe the sheet as data (rows, columns, types, formats) and the package writes the file in one pass — no per-cell ceremony, no global state, no surprise dependencies.
Features
- ✅ Multi-sheet workbooks, inline strings, scalar types, formulas with optional cached values
- ✅ Full styling — bold/italic, text alignment, font color/size, fills, borders
- ✅ Number formats — currency (USD/EUR/GBP/JPY/CNY/INR/AUD/CAD/CHF/KRW + ISO fallback), percent, date, datetime, integer, decimals
- ✅ Date conversion — ISO strings +
DateTimeInterface→ Excel serial numbers - ✅ Themes —
default,business,minimal,plain - ✅ Symbolic totals —
'totals' => ['Revenue' => 'sum']→ SUM/AVG/COUNT/MIN/MAX formulas - ✅ Merged cells, column widths (px), frozen rows/cols
- ✅ Comments with author + color
- ✅ Cross-sheet formula references (
Sheet2!A1) - ✅ Style deduplication — every unique format becomes one record
- ✅ Zero third-party runtime dependencies (uses PHP's built-in
ZipArchive) - ✅ Structured validation errors with
path,expected,got,value,hint - ✅ Read path (1.1+) —
Agent::describe(path)round-trips an existing xlsx back to a Holy Sheet schema with full feature parity - ✅ Schema repair (1.1+) —
Agent::validateAndRepair($schema)applies conservative auto-fixes (singularsheet→sheets, stringified numerics, object-as-list, etc.) - ✅ Schema builders (1.1+) —
Agent::fromArray(),Agent::fromCsv(),HolySheet::fromQuery()(Laravel) — typed schemas from rows / CSV / Eloquent with no hand-crafting - ✅ Formula linter (1.2+) —
Agent::lint($schema)evaluates every formula and reports#VALUE!/#REF!/#DIV/0!/#NAME?/#CIRC!errors. Catches the LLM-classic header-row off-by-one (B1*12when B1 is "Annual" and B2 is the data) with a "Did you mean B2?" hint
Compatibility
| Versions | |
|---|---|
| PHP | 8.2, 8.3, 8.4 |
| Laravel adapter | 10.x, 11.x, 12.x, 13.x (optional) |
| Frameworks | any PHP 8.2+ project — Symfony, Laminas, Slim, plain PHP, CLI |
| Runtime deps | none beyond ext-zip |
Documentation
| Topic | Doc |
|---|---|
| Schema reference — every field, every type, every option | docs/Schema.md |
| Recipes — 14 end-to-end patterns including round-trip + helper builders | docs/Recipes.md |
Read path — describe() contract + lossy-fields list |
docs/ReadPath.md |
| Laravel adapter — facade methods, service provider, artisan command | docs/LaravelAdapter.md |
| Agent skill — system prompt for LLM consumption | skills/holy-sheet.md |
| JSON Schema — for tool-use validators | skills/holy-sheet.schema.json |
Run the demo
Writes a 3-sheet workbook (Sales / Notes / Status) demonstrating every feature — currency + percent + date columns, totals row, frozen header, merged title cell, comment, custom theme. See examples/README.md for the full walkthrough.
Three entry points, one schema
| Caller | Entry |
|---|---|
| Plain PHP | HolySheet\Agent::write($schema, $path) (static, framework-free) |
| Laravel facade | HolySheet\Laravel\Facades\HolySheet::write($schema, $path) |
| CLI / agent shell | php artisan holy-sheet:write --in=schema.json --out=q4.xlsx (Laravel command) |
Need an HTTP route? Build your own controller around the facade — Holy Sheet doesn't ship one. See docs/LaravelAdapter.md for the recommended shape.
License
MIT
All versions of holy-sheet with dependencies
ext-zip Version *