离线 · 无上传 · 浏览器本地完成Offline · no uploads · runs in the browser
Excel 转 PDF——本地两步成档,多 sheet 连续排版Excel to PDF locally — two steps, every sheet in order
先说最容易踩的那格:Excel 里看到的"表格",在文件里其实是三类东西的叠加——单元格的值、公式、以及格式(列宽、颜色、合并、条件格式)。这条链能带走第一类,第二类带的是缓存结果而不是活公式,第三类基本带不走。所以产物是一张干净、可打印、可复制文字的表格文档,而不是"你那张带底纹的报表"。知道边界之后再决定用它还是用 Excel 自己导出。Start with the trap, because it is the one people hit: the "table" you see in Excel is three things stacked — cell values, formulas, and formatting (column widths, colours, merges, conditional rules). This chain carries the first, carries the second as its cached result rather than as a live formula, and carries almost none of the third. So the output is a clean, printable, copyable table document, not *your* shaded report. Knowing that boundary is what makes the choice between this and Excel’s own export an informed one.
这条链路怎么走How the route runs
Excel (.xlsx)Excel (.xlsx) HTMLHTML PDFPDF
共 2 步,由扩展的路径搜索自动选出,中间产物不落盘。2 steps, chosen by the extension's own path search; intermediate results never touch the disk.
会保留什么What carries over
- 每个工作表一张表格;多于一个 sheet 时,每张前面带上它的名字作为标题,PDF 里就是 `<h2>` 一级的分节One table per worksheet; when the workbook holds more than one sheet, each is preceded by its own name as a section heading
- 单元格值按显示文本写入:日期单元格在阅读阶段就被显式标记并按统一格式渲染,不会变成 45296.33 这样的序列号Cell values are written as display text: date cells are flagged while the workbook is read and rendered under one agreed format, so 45296.33 never appears where a date belongs
- 文本、数字与布尔的原样字符——这条链默认以"值保真"为目标,不替你四舍五入Text, numbers and booleans keep their own characters — this chain aims at value fidelity and does not round on your behalf
- 文字进 PDF 是真的文字层,可选中、可复制、可搜索(这与"表格截图"不同)Text in the PDF is a real text layer: selectable, copyable and searchable, unlike a screenshot of a spreadsheet
- 中间那份 HTML 只在内存里,你的下载目录只多出一个 .pdfThe intermediate HTML exists only in memory, so your downloads gain one .pdf and nothing else
如实说明的限制What it does not do
- 格式不进产物:字体、颜色、底纹、列宽行高、边框样式、条件格式、数字自定义格式都不参与,PDF 里是统一的表格样式Formatting does not travel: fonts, colours, shading, column widths and row heights, border styles, conditional rules and custom number formats are all absent, and the PDF shows one shared table style
- 合并单元格不还原成跨行跨列,只是把值放在左上那一格Merged cells are not reproduced as spans — the value sits in the top-left cell
- 公式不求值:格子里是文件上次保存时算好的值;从没保存过或依赖外部数据时可能为空Formulas are not evaluated: each cell holds whatever the file last cached when it was saved, which can be blank for unsaved or externally-fed workbooks
- 图表、数据透视表、切片器、批注、宏、图片与形状都不提取Charts, pivot tables, slicers, comments, macros, embedded pictures and shapes are not extracted
- 分页位置由内容高度决定(A4 竖版按高度切),不能指定纸张、方向、缩放或打印区域;超宽表格会被排到下一页而不是缩小塞进一页Page breaks follow content height (portrait A4, sliced by height); paper size, orientation, scaling and print areas cannot be set, so a very wide table spills to the next page rather than shrinking to fit
- 只读 .xlsx(zip 包),旧版 .xls / .et 等格式不在识别范围内Only the zipped .xlsx package is read; legacy .xls and similar spreadsheets are outside detection
实操提示Working with it
- 同一份 .xlsx 还能转 CSV、JSON、Markdown、HTML 与 PNG:前四种保留值、丢格式,PNG 则是整页像素The same .xlsx can also go to CSV, JSON, Markdown, HTML and PNG: the first four keep values and drop formatting, while PNG is page-by-page pixels
- 多 sheet 的 CSV 会输出 ZIP(一个 sheet 一个文件),而这条 PDF 路径是把所有 sheet 串进同一份文档——两种形态各有用处A multi-sheet workbook becomes a ZIP for CSV, one file per sheet, whereas this PDF route strings every sheet into one document — the two shapes serve different jobs
- 单个上限 100 MB,一批最多 200 个文件;链路较长,超大工作表建议先只留必要列再转100 MB per file and up to 200 files per batch; it is a long chain, so trim a very large worksheet to its needed columns first
常见问题Questions people actually ask
为什么 PDF 里的表格没有我原来的底色?Why did my shading not make it into the PDF?
因为这条链取的是单元格的值,样式层在 HTML 那一步就没有参与。要带底纹的报表,用 Excel 自己导出 PDF;这里的定位是"把数据变成可分发、可复制文字的文档"。Because the chain reads cell values, and the style layer never takes part once the content is in HTML. For a shaded report, let Excel export the PDF; this route’s job is turning data into a distributable document whose text is selectable.
日期那一列变成了 45296 怎么办?What if the date column turns into 45296?
这条路径不会:日期单元格在读取时被显式标记,并按统一的文本格式渲染,所以到 PDF 里仍然是日期文本。真看到序列号,通常说明那格在源文件里本来就是数字而不是日期格式——回到 Excel 里把该列设成日期格式再转一次。It does not here: date cells are flagged during the read and rendered through one agreed text format, so the PDF still says a date. If a serial number does appear, that cell was most likely a plain number rather than a formatted date in the source — set the column to a date format in Excel and convert again.
宽表格被切到第二页,能强制一页放下吗?A wide table spilled on to a second page — can I force it on to one?
不能,这条没有纸张、方向、缩放或"适应页面"的参数。可行的办法是在源文件里删到必要列、或改走 Excel → HTML 自己控制宽度,再 HTML → PDF。No — there is no paper, orientation, scaling or fit-to-page parameter on this route. What works is dropping to the columns you need, or taking Excel to HTML and controlling width there before going HTML to PDF.
不需要账号,也不需要联网:装好扩展后点图标,在新标签页里打开工作台,文件从磁盘直接选。No account and no network: install the extension, click its icon, and the workbench opens in a new tab reading straight off your disk.
从 Chrome 应用商店安装Install from the Chrome Web Store 安装步骤Install steps GitHub 源码Source on GitHub