Excel 转 PDF

这款工具的作用

A spreadsheet has no pages, no margins and frequently no sensible width, so converting one is a series of choices rather than a straight translation. This reads the .xlsx directly, resolves what each cell actually displays, and sets the sheets as tables on paper you pick. The defaults are landscape, fit to width, and the header row repeated after every page break.

Use it when a sheet has to be read rather than worked in: a price list going to a client, a timesheet attached to an invoice, an export from an accounting system that somebody needs on paper, or a table you want to hand over in a form that will not be quietly edited.

工作原理

1. Drop your .xlsx files onto this page. Every sheet in each workbook is converted.
2. Leave the orientation on landscape unless your sheet is unusually narrow - most are wider than they are tall.
3. Keep fit to width on so the table is set at 9 point and the columns cross the page instead of running off it.
4. Decide whether to draw grid lines, and whether each sheet's name should be printed as a heading above it.
5. Raise the column limit under advanced options if your sheet is wider than 20 columns and you want all of them.
6. Press Convert and the PDF downloads.

Dates are what spreadsheet converters get wrong most often. A date in a .xlsx is a plain number with a number-format attached to it; read the number without resolving the format and every date in the document turns into a five-digit integer. The format is resolved here, in the reader, before anything reaches the layout - which is why 45000 arrives as a date and not as forty-five thousand.

Formulas are read as their last calculated value rather than as formulas, which is almost always what a printed table should show and is also the only honest option: evaluating a workbook's dependency graph would mean implementing Excel's function library. The consequence worth knowing is that a workbook saved without recalculating carries stale values, and the PDF will faithfully reproduce them.

The column ceiling exists so the tool says something rather than shrinks. A sheet forty columns wide, scaled until all forty fit across A4, produces four-point type that nobody can read - so 20 columns is the default and the remainder are left out visibly instead of being crushed in. Raise the limit to 50 if you need to, and think about A3 in landscape at the same time.

Fit to width sets the base type at 9 point instead of 11. That is the whole of what it does, and the bluntness is deliberate: a fixed size you can predict beats an automatic scale factor that comes out differently on every sheet, and 9 point fits roughly a fifth more columns across a page than 11 does.

Each sheet starts on a fresh page by default, and its name becomes both a heading and a bookmark, so a twelve-sheet workbook arrives as a twelve-entry outline. Switch to run on under advanced options and the break between sheets is removed, which is worth doing when the sheets are short enough that each would otherwise waste most of a page.