XLSX Print Setup Pack

Apply paper, margins, scaling, repeating titles, and header/footer print settings to Excel workbooks in one pass

Configure Excel print settings in one run. - Applies paper size, orientation, margins, and centering - Supports scaling or fit-to-page width/height - Repeats title rows/columns on every printed page - Writes odd-page header/footer text for consistent exports

Example Results

1 examples

Set Print Layout for Finance Workbook

Apply A4 landscape print settings, title rows, and corporate header/footer across all sheets

xlsx-print-setup-pack-example1.xlsx View File

View input parameters

{ "workbookFile": "/public/samples/xlsx/finance-source.xlsx", "paperSize": "a4", "orientation": "landscape", "marginsJson": "{\n \"top\": 0.5,\n \"bottom\": 0.45,\n \"left\": 0.3,\n \"right\": 0.3,\n \"header\": 0.2,\n \"footer\": 0.2\n}", "fitToWidth": 1, "fitToHeight": 0, "repeatTitleRows": "1:2", "headerText": "&LFinance Pack&CQ1 Summary&RPage &P of &N", "footerText": "&LInternal Use Only&R&D" }

Workbook File *

Click to upload file or drag and drop file here

Maximum file size: 200MB Supported formats: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet, application/vnd.ms-excel

Target Sheets

Paper Size

Orientation

Margins JSON

Scale Percent

Fit To Width Pages

Fit To Height Pages

Repeat Title Rows

Repeat Title Columns

Print Area

Header Text

Footer Text

Center Horizontally

Center Vertically

Print Grid Lines

API Documentation

Request Endpoint

POST /en/api/tools/xlsx-print-setup-pack

Request Parameters

Parameter Name	Type	Required	Description
workbookFile	file (Upload required)	Yes	-
sheetNames	text	No	-
paperSize	select	No	-
orientation	select	No	-
marginsJson	textarea	No	-
scalePercent	number	No	-
fitToWidth	number	No	-
fitToHeight	number	No	-
repeatTitleRows	text	No	-
repeatTitleColumns	text	No	-
printArea	text	No	-
headerText	text	No	-
footerText	text	No	-
horizontalCentered	checkbox	No	-
verticalCentered	checkbox	No	-
showGridLines	checkbox	No	-

File type parameters need to be uploaded first via POST /upload/xlsx-print-setup-pack to get filePath, then pass filePath to the corresponding file field.

Response Format

{
  "filePath": "/public/processing/randomid.ext",
  "fileName": "output.ext",
  "contentType": "application/octet-stream",
  "size": 1024,
  "metadata": {
    "key": "value"
  },
  "error": "Error message (optional)",
  "message": "Notification message (optional)"
}

File: File

AI MCP Documentation

Add this tool to your MCP server configuration:

{
  "mcpServers": {
    "elysiatools-xlsx-print-setup-pack": {
      "name": "xlsx-print-setup-pack",
      "description": "Apply paper, margins, scaling, repeating titles, and header/footer print settings to Excel workbooks in one pass",
      "baseUrl": "https://elysiatools.com/mcp/sse?toolId=xlsx-print-setup-pack",
      "command": "",
      "args": [],
      "env": {},
      "isActive": true,
      "type": "sse"
    }
  }
}

You can chain multiple tools, e.g.: `https://elysiatools.com/mcp/sse?toolId=png-to-webp,jpg-to-webp,gif-to-webp`, max 20 tools.

Supports URL file links or Base64 encoding for file parameters.

If you encounter any issues, please contact us at [email protected]

Categories