删除行 Excel 使用 Zapier

删除行 是一个 Zapier 采取行动 PDF4me 从指定列表中删除单行、范围或混合组合。 Excel 工作表使用类似“1-5,10,15-20”这样的范围语法。行会自动从下往上处理，这样可以防止因删除行的顺序错误而导致的索引偏移错误，从而避免公式出错。

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

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

Get your API Key

PDF4me Excel 删除行 Zapier 配置 - 文件、文件名、工作表名称 Sheet5、行范围 1-20 — 配置 Excel 删除行操作、文件输入、工作表目标和行范围指定。

您不容错过的重要事实

文件名是可选的，并非必填项。

屏幕截图证实，文件、工作表名称和行范围都带有星号。 Zapier UI但文件名并非如此。它用于输出命名，而不是用于定位文件。

行从 1 开始，从下往上处理。

第 1 行是第一行，与你在……中看到的内容一致 Excel删除操作会自动从范围底部向上执行，因此以任何顺序指定行都不会导致索引移动错误。

每次运行一个工作表名称

每次操作调用都只针对一个工作表，且必须通过区分大小写的精确名称进行匹配。要清理多个工作表，请串联执行多个“删除行”步骤。

参数

删除行操作的完整参数列表。参数名称与……匹配 Zapier 配置 UI。

必需 Zapier UI： 文件名、工作表名称和行范围。文件名是可选的。

范围	必需的	它的作用	例子
File	Required	Excel file content, mapped from a previous step using full file content.	`[2. File from Step 2]`
File Name	Conditional	Filename with .xlsx or .xls extension, used for output naming.	`add_header_sample_file.xlsx`
Worksheet Name	Required	Exact, case-sensitive name of the worksheet to delete rows from.	`Sheet5`
Row Ranges	Required	Comma-separated row numbers and ranges. 1-based indexing, processed bottom-to-top automatically.	`1-20`

行范围语法示例

单行： “5,10,15”删除第5行、第10行和第15行。

范围： “1-20”删除第1行到第20行。

混合： “1-3,25”删除第 1 行到第 3 行以及第 25 行，例如内部注释和计算行。

输出结果包含哪些字段？

该操作返回修改后的结果。 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.
`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.
`Doc Text`	String	Extracted text, typically empty for Excel row-deletion output.

典型配置

工作流程示例Common Zapier workflow patterns using Delete Rows.

在向客户发送报告之前，删除内部笔记。

每周生成报告的步骤会完成并从 Google 云端硬盘检索完整的内部报告。
删除行操作将工作表名称设置为“报表”，行范围设置为 1-3,25，删除标题/内部注释行和计算行。
清理后的报告会上传到面向客户的云端硬盘文件夹，而原始报告则会保留在内部存档中。

对事务日志强制执行数据保留策略

每月定期触发的事件会从以下位置检索交易日志： SharePoint。
先前的步骤确定哪些行号包含超过保留窗口的数据，然后“删除行”操作将工作表名称设置为“事务”，并从该范围动态构建行范围。
更新后的日志已上传回。 SharePoint 合规性摘要将通过电子邮件发送给数据保留负责人。

从分布式模板中删除示例行

在内容管理工具中，模板被标记为可分发，并检索其主版本。
删除行操作将工作表名称设置为 Sheet1，行范围设置为 2-10，删除示例数据，同时保留标题行和公式。
清理后的模板已上传至共享模板库。

实用技巧

Map full file content, not a reference

If File shows "Exists but not shown", pick the mapping option that provides full file content, or the action returns a File Is Empty error.

Row Ranges order does not matter

Because deletion happens bottom-to-top internally, you can list ranges in any order, such as 15-20,1-5, without causing index-shifting mistakes.

Worksheet Name is case-sensitive

A typo or wrong case, like "sheet5" instead of "Sheet5", will not match and the action errors instead of silently doing nothing.

One worksheet per action call

To delete rows from multiple sheets, chain a second Delete Rows step and feed the first step's output file into it.

Preserve the header row deliberately

Since row 1 is included in 1-based numbering, double-check your Row Ranges does not accidentally include row 1 when you want to keep column headers.

速查表

场地	价值
Action	`Delete Rows`
File	`[mapped from previous step, full content]`
File Name	`add_header_sample_file.xlsx`
Worksheet Name	`Sheet5`
Row Ranges	`1-20`

常见问题解答

How do I delete rows from an Excel file automatically in Zapier?+

Add the PDF4me Delete Rows action to a Zap, map File with full file content, set Worksheet Name to the exact sheet name, set Row Ranges to the rows you want removed such as 1-20, and run the Zap. See Microsoft's discussion on deleting rows by content for background on manual row-deletion approaches this action replaces.

How does Row Ranges syntax work for single rows and ranges?+

Row Ranges accepts single row numbers, ranges, or a mix, separated by commas. 5,10,15 deletes exactly those three rows, 1-20 deletes rows 1 through 20 inclusive, and 1-5,10,15-20 combines both styles.

Why does the action delete rows bottom to top?+

If rows were deleted top to bottom, removing an earlier row would shift every later row number up by one, causing the wrong rows to be deleted. Processing bottom to top avoids this index-shifting error automatically.

Are row numbers 1-based or 0-based?+

Row numbers are 1-based, matching what you see in Excel itself. Row 1 is the first row of the worksheet, including the header row if there is one.

Can I delete rows from more than one worksheet in a single run?+

No, one action call targets exactly one Worksheet Name. To clean multiple sheets, chain a second Delete Rows step for each additional worksheet, feeding the previous step's output file forward.