Categories

← View All Tools

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" }

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

Key Facts

Category
Format Conversion
Input Types
file, text, select, textarea, number, checkbox
Output Type
file
Sample Coverage
4
API Ready
Yes

Overview

The XLSX Print Setup Pack allows you to standardize print configurations across your Excel workbooks in a single operation. Easily define paper size, margins, scaling, and repeating title rows to ensure your spreadsheets are print-ready and formatted consistently for professional exports.

When to Use

  • •Preparing large financial reports or data tables that require consistent headers and footers across every page.
  • •Standardizing print layouts for multiple sheets within a workbook to ensure uniform margins and orientation.
  • •Ensuring long data sets fit perfectly on a specific number of pages by applying custom scaling or fit-to-page settings.

How It Works

  • •Upload your Excel workbook file to the tool.
  • •Select your preferred paper size, orientation, and define custom margins using the JSON input.
  • •Specify optional settings like repeating title rows, print areas, or custom header and footer text.
  • •Process the file to generate a new version of your workbook with all print settings applied.

Use Cases

Standardizing corporate invoice templates with consistent margins and company headers.
Formatting complex data exports to ensure column titles repeat on every page for readability.
Preparing multi-sheet project reports for PDF conversion with uniform orientation and page scaling.

Examples

1. Finance Report Print Setup

Financial Analyst
Background
A quarterly financial report needs to be printed, but the default Excel settings cut off columns and lack consistent headers.
Problem
The report spans multiple pages and needs to fit on A4 landscape with specific title rows repeating.
How to Use
Upload the workbook, set orientation to landscape, and define the title rows and header text.
Example Config
{"paperSize": "a4", "orientation": "landscape", "repeatTitleRows": "1:2", "fitToWidth": 1, "headerText": "&LFinance Report&RPage &P of &N"}
Outcome
The generated file prints in landscape mode with the first two rows repeating on every page and all columns scaled to fit the page width.

Try with Samples

json, xml, xlsx
XLSX Samples
Sample XLSX spreadsheets for worksheet parsing and data extraction testing
title token xlsx
xlsx, xls
Web Data Serialization Rust Samples
Web Rust data serialization examples including JSON serialization, deserialization, and XML parsing
preferred input family json
json
Windows Serialization C++ Samples
Windows C++ data serialization examples including JSON serialization/deserialization and XML parsing
preferred input family json
json
Web Data Serialization Go Samples
Web Go data serialization examples including JSON encoding/decoding and XML parsing
preferred input family json
json

Related Hubs

Json Convert Tools
Explore 100 json tools for convert workflows and compare closely related utilities quickly.
Text Convert Tools
Explore 80 text tools for convert workflows and compare closely related utilities quickly.
Xml Convert Tools
Explore 32 xml tools for convert workflows and compare closely related utilities quickly.
Json Tools
Explore 43 json tools for utility workflows and compare closely related utilities quickly.

FAQ

Can I apply settings to specific sheets only?

Yes, you can specify individual sheet names in the 'Target Sheets' field, separated by commas.

How do I repeat header rows on every printed page?

Enter the row range (e.g., '1:2') in the 'Repeat Title Rows' field.

What format should the margins JSON use?

Use a standard JSON object with keys for top, bottom, left, right, header, and footer, representing inches.

Does this tool change the actual data in my spreadsheet?

No, this tool only modifies the print metadata and layout settings of the file; your data remains untouched.

Can I fit my data to a specific page width?

Yes, use the 'Fit To Width Pages' field to force the content to scale to a specific number of pages wide.

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]