pdf_excel_to_pdf_batch
Excel to PDF (Batch) — Apply the same Excel-to-PDF configuration to up to 20 spreadsheets. Returns a ZIP with per-file subfolders. [category: pdf]
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| pdfa | No | Archival PDF/A output. 2b is the safe default. | none |
| files | Yes | Up to 20 input spreadsheets | |
| scale | No | Print scaling percent. Overrides fitToPage when set. | |
| footer | No | Per-page footer template. Same tokens as header. | |
| header | No | Per-page header template. Tokens: {page}, {pages}, {sheet}, {date}, {filename}. | |
| sheets | No | Sheet selection: 'all', comma-separated names (e.g. 'Sales,Ledger'), or comma-separated 0-based indexes (e.g. '0,2'). Non-selected sheets are hidden before conversion. | |
| margins | No | default|narrow|normal|wide (Excel's inch presets); default keeps the sheet's own margins. Only applies to .xlsx input; unknown → default. | default |
| quality | No | Output compression quality preset. | |
| password | No | Open password for the output PDF (user password). | |
| bookmarks | No | Add PDF bookmarks, one per sheet. | |
| fitToPage | No | Fit each sheet to a page. 'width' prevents column cutoff; 'one-page' squeezes each sheet onto a single page. | none |
| gridlines | No | Show gridlines. Empty leaves the sheet's own setting. | |
| paperSize | No | a4 (default) | letter | legal | tabloid | a3. Only applies to .xlsx input (excelize preprocess); unknown values silently become a4. | a4 |
| splitMode | No | combined = one multi-page PDF; per-sheet = ZIP with one PDF per sheet. | combined |
| repeatRows | No | Print titles — rows that repeat on every page. e.g. '1' or '1-3'. | |
| orientation | No | Page orientation. 'auto' picks landscape for sheets with ≥8 data columns. | auto |
| showHeaders | No | Show row/column headers (A/B/C + 1/2/3). Empty leaves the sheet's own setting. | |
| permPassword | No | Owner password for permission restrictions. Optional. | |
| watermarkText | No | Optional text watermark stamped on every page of the output. |