移除页眉页脚 Excel 使用 Zapier

移除页眉页脚 Excel 是一个 Zapier 采取行动 PDF4me 清除页眉和页脚内容 Excel 工作表，逐节进行设置。可独立地将目标位置设置为左、中或右，适用于页眉和页脚，可应用于单个工作表或整个工作簿，并可用于在重新分发之前去除过时的品牌标识或草稿标记。

我如何验证我的身份 API 要求？

要访问 PDF4me 网站 API 通过 Zapier每个请求都必须包含正确的身份验证凭据。身份验证可确保通信安全，并验证您作为授权用户的身份，从而实现与您的系统之间的无缝集成。 Zapier 工作流程和 PDF4me强大的 Excel 格式化服务。

Get your API Key

PDF4me Excel 删除页眉页脚 Zapier 配置 - 文件、文件名、删除左/中/右页眉/页脚、工作表名称、工作表索引、区域设置名称 — 配置“删除页眉页脚”操作、文件输入、要删除的部分以及工作表目标。

您不容错过的重要事实

仅需提交文件即可。

截图证实，文件是唯一带有星号的文件。 Zapier UI.所有“删除页眉/页脚”开关、文件名、工作表名称、工作表索引和区域性名称都是可选的。

六个独立的真/假开关

“移除页眉左侧/中间/右侧”和“移除页脚左侧/中间/右侧”都是独立的切换开关，因此您可以清除一个部分（例如中间的“草稿”印章），同时保持页脚右侧的页码不变。

工作表定向采用的是选择加入机制，而不是选择退出机制。

将工作表名称和工作表索引留空，即可处理所有工作表。如果指定了工作表名称，则任何未命名的工作表都将保留其原始的页眉和页脚。

参数

“移除页眉页脚”操作的完整参数列表。参数名称与以下内容匹配： Zapier 配置 UI。

必需 Zapier UI： 仅文件。文件名、六个页眉/页脚切换选项、工作表目标和文化名称均为可选。

范围	必需的	它的作用	例子
File	Required	Excel file content, mapped from a previous step using full file content (not an "Exists but not shown" reference).	`[5. File Url]`
File Name	Conditional	Filename with .xlsx or .xls extension, used for output naming.	`add_header_sample_file.xlsx`
Remove Header Left	Conditional	Removes the left section of the header.	`True`
Remove Header Center	Conditional	Removes the center section of the header.	`False`
Remove Header Right	Conditional	Removes the right section of the header.	`False`
Remove Footer Left	Conditional	Removes the left section of the footer.	`False`
Remove Footer Center	Conditional	Removes the center section of the footer.	`False`
Remove Footer Right	Conditional	Removes the right section of the footer.	`False`
Worksheet Names	Conditional	Comma-separated sheet names to target. Sheets left out keep their headers/footers. Empty targets every sheet.	`Sheet3, Sheet1`
Worksheet Indexes	Conditional	Sheet positions to target instead of names. Empty targets every sheet.	`[1.0]`
Culture Name	Conditional	Locale code used during processing.	`en-US`

输出结果包含哪些字段？

该操作返回修改后的结果。 Excel 文件加上跟踪元数据。这种输出格式在所有文件中都很常见。 PDF4me Excel 行动 Zapier。

场地	类型	它包含什么
`Job Id`	String	Unique identifier for the Zapier job execution.
`File Url`	URL	API endpoint to download the processed Excel file. Map this to the next step, Drive, Dropbox, or another PDF4me Excel action.
`Alternate File Url`	URL	Alternate download URL with the filename in the path, for apps that expect a human-readable filename.
`File Name`	String	Base filename without extension.
`File Extension`	String	File extension of the output, .xlsx or .xls.
`Full File Name`	String	Complete filename including extension.
`Document Id`	String	Unique identifier for the processed document.
`File Size`	Number	Size of the output file in bytes.

典型配置

工作流程示例Common Zapier workflow patterns using Remove Header Footer.

品牌重塑过程中去除旧品牌标识

Google 云端硬盘步骤会检索每个 Excel 通过循环应用程序，一次从模板库中选择一个模板。
PDF4me “删除页眉/页脚”运行时，所有六个“删除页眉/页脚”开关都设置为“真”，并且工作表名称/索引留空，以便清理每个工作表。
清理后的文件将上传到品牌重塑暂存文件夹，以便应用新的页眉/页脚。

移除“草稿”印章，保留页码

模板管理步骤检索带有中心标题“DRAFT”印章的主模板。
“移除页眉页脚”功能在“移除页眉中心”设置为“真”且其他所有切换开关都设置为“假”的情况下运行，因此页脚页码保持不变。
工作表名称设置为向外部分发的特定工作表。

在交付给客户之前，对内部工作簿进行清理。

当项目管理工具中将交付成果标记为最终版本时，就会触发工作流程。
删除页眉页脚会清除页眉左侧和页脚中心（内部审阅者姓名和草稿通知），同时保持页脚右侧（面向客户的内容）不变，其范围仅限于客户可见的工作表。
清理后的工作簿已上传至客户门户。

实用技巧

Map full file content, not a reference

If File shows "Exists but not shown", pick the mapping option that provides the full file content instead, or the action errors on that input.

Six toggles, six independent choices

Set only the sections you actually want cleared. Leaving Remove Footer Right false, for example, is how you preserve page numbers while clearing everything else.

Worksheet targeting is opt-in

Leave Worksheet Names and Worksheet Indexes empty to guarantee every sheet is processed. Naming a subset skips every sheet not named.

Worksheet Names is comma-separated

List sheet names exactly as they appear in the workbook, such as Sheet3, Sheet1. Typos in a sheet name silently skip that sheet.

Culture Name rarely needs to change

Leave Culture Name blank unless a downstream locale-specific formatting issue appears. It affects processing locale, not which sections get removed.

速查表

场地	价值
Action	`Remove Header Footer`
File	`[mapped from previous step, full content]`
File Name	`add_header_sample_file.xlsx`
Remove Header Left	`True`
Remove Header Center	`False`
Remove Header Right	`False`
Remove Footer Left	`False`
Remove Footer Center	`False`
Remove Footer Right	`False`
Worksheet Names	`Sheet3, Sheet1`

常见问题解答

How do I remove headers and footers from an Excel file automatically?+

Add the PDF4me Remove Header Footer action to a Zap, map File with full file content from a previous step, set the Remove Header/Footer Left, Center, and Right toggles to True for the sections you want cleared, and run the Zap. See Microsoft's headers and footers overview for background on how these sections are structured in Excel.

Can I remove just one section, like the center header, and leave the rest?+

Yes. Each of the six sections, Header Left, Header Center, Header Right, Footer Left, Footer Center, and Footer Right, has its own True/False toggle, so you can clear one section while leaving the others untouched.

Does this work across multiple worksheets in one run?+

Yes. Set Worksheet Names to a comma-separated list of sheet names or Worksheet Indexes to their positions, and the removal applies to all of them in a single action call. Leaving both empty processes every worksheet in the workbook.

Why do my headers or footers still show up after I remove them?+

The most common cause is that Worksheet Names or Worksheet Indexes only listed some sheets. Any worksheet not named in either field keeps its original header and footer. Leave both fields empty to guarantee every sheet is processed.

Can I remove headers and footers from specific worksheets only?+

Yes. Set Worksheet Names or Worksheet Indexes to only the sheets you want cleaned. Sheets left out of both lists are not touched, which is useful when you need to keep page numbers or branding on some tabs. See Microsoft's guide to worksheet headers and footers for how per-sheet settings work natively in Excel.