添加行 Excel 在 Power Automate： JSON 到 Excel 和 PDF4me

PDF4me Excel - 添加行 是一个 Power Automate 插入操作 JSON 对象或数组作为新行添加到 Excel 工作簿，既可以采用基于表格的模式（自动匹配表头），也可以采用基于坐标的模式（精确定位单元格）。可用于写入数据库查询结果、表单提交内容，或 API 直接回复 Excel 报告。

此操作的作用

PDF4me Excel - 添加行 写 JSON 将行数据插入现有工作簿，如果设置了表名，则属性与表头匹配；如果表名留空，则插入到精确的坐标位置。“转换数值和日期”、“日期格式模式”、“数值格式模式”和“区域性名称”控制插入值的输入和格式。

我如何验证我的身份 Power Automate 流动？

每一个 PDF4me 行动 Power Automate 需要有效的连接。创建或选择一个包含您数据的连接。 PDF4me API 关键在于流程能够进行身份验证 Excel 安全地执行行插入请求。

Get your API Key

您不容错过的重要事实

表名是模式开关

如果“表名”非空，则会启用基于表格的插入操作，并匹配表头和 Excel 行号作为插入位置。如果将其留空，则会启用基于坐标的插入操作，使用“从行插入”和“从列插入”功能。在一次调用中混合使用这两种参数集会返回错误。

数据字段已标记 JSON 行数据

接受单个 JSON 对象用于插入一行数据，对象数组用于一次调用插入多行数据。属性名称用于在表格模式下进行表头匹配。

类型转换需要启用该开关

日期格式模式、数字格式模式和区域性名称仅在启用“转换数字和日期”时生效。如果禁用此选项，所有值都将以纯文本形式写入。

参数

必需的： 必须始终提供文件内容、文件名和 JSON 行数据。表名和 Excel 行号仅适用于基于表的插入操作。“从行插入”和“从列插入”仅适用于基于坐标的插入操作，如果同时设置了表名，则这些选项将被拒绝。

范围	必需的	它的作用	例子
File Content	Required	Base64 content of the source Excel workbook, mapped from SharePoint, OneDrive, or another prior action.	`[File Content from Get File]`
File Name	Required	Excel filename including extension (.xlsx or .xls), used for processing and output identification.	`data.xlsx`
JSON Row Data	Required	JSON object or array of objects to insert. Each object becomes one row, property names match table headers in table mode.	`[{"Name":"John","Age":30}]`
Worksheet Name	Optional	Name of the worksheet to insert into. Defaults to Sheet1 if left blank.	`Sheet1`
Table Name	Optional	Name of an Excel table for table-based insertion. Leave empty to use coordinate-based insertion instead.	`SalesTable`
Excel Row Number	Conditional	1-based position within the table, table mode only. Ignored in coordinate mode.	`5`
Insert From Row	Conditional	1-based worksheet row where insertion starts, coordinate mode only. Errors if Table Name is also set.	`10`
Insert From Column	Conditional	1-based worksheet column where insertion starts, coordinate mode only. Errors if Table Name is also set.	`3`
Convert Numeric And Date	Optional	Enables automatic conversion of JSON numbers to Excel numeric values and date-like strings to Excel dates. Default true.	`true`
Date Format Pattern	Optional	Excel date format applied when Convert Numeric And Date is enabled. Default yyyy-MM-dd.	`MM/dd/yyyy`
Numeric Format Pattern	Optional	Excel numeric format applied when Convert Numeric And Date is enabled. Default N2.	`#,##0.00`
Ignore Null Values	Optional	Skips inserting a value for any JSON property that is null when enabled. Default false, which inserts nulls as empty cells.	`false`
Ignore Attribute Titles	Optional	Makes JSON property name matching case-insensitive against table headers when enabled. Default false.	`true`
Culture Name	Optional	Culture code used to parse incoming date and number strings before conversion. Default en-US.	`en-US`

输出字段

场地	类型	它包含什么
`document`	Base64	The Excel workbook with the new rows inserted.
`Success`	Boolean	true if insertion completed, false if the action failed.
`ErrorMessage`	String	Error description, null when Success is true.
`Errors`	Array	Detailed error objects with Code and Message, empty when Success is true.

常见错误信息是什么意思？

错误信息	原因	解决方案
JSON input is required	JSON Row Data is null or empty.	Provide a valid JSON object or array.
Invalid JSON structure	Malformed JSON syntax.	Fix the JSON formatting before mapping it in.
Worksheet not found	The named worksheet does not exist in the workbook.	Use an existing worksheet name or leave it blank for the first sheet.
Table not found	The named table does not exist, table mode only.	Use an existing Excel table name.
ExcelRowNumber must be greater than 0	Excel Row Number is less than 1 in table mode.	Set Excel Row Number to 1 or higher.
InsertFromRow and InsertFromColumn are ignored when TableName is specified	Coordinate parameters were set alongside Table Name.	Clear Table Name for coordinate mode, or clear the coordinate fields for table mode.
No valid data found in JSON input	JSON Row Data was an empty array or had no parseable objects.	Provide at least one valid object in the JSON payload.

如何在设置中添加行 Power Automate？

添加 PDF4me → Excel - 添加行 致你 Power Automate 流动。
地图 文件内容 和 文件名 来自之前的操作（SharePoint， OneDrive（或数据库连接器）。
放 JSON 行数据 添加到您的对象或对象数组中。
放表名对于基于表格的插入，或者留空并设置 从行插入 / 从列插入 用于基于坐标的插入。
扩张 高级参数 以便能够 转换数值和日期 并设置格式。运行流程后，更新后的工作簿将返回如下内容文档。

典型配置

工作流程示例Common Power Automate flow patterns using Add Rows.

每日销售数据导入（表格模式）

计划触发器会运行 SQL 查询来获取当天的销售记录。
结果被转换为与销售表列标题相匹配的 JSON 数组。
Get File 工具检索表名为“DailySales”的销售报告模板。
添加行操作会插入一个数组，并启用“转换数值和日期”功能，同时为货币设置数值格式模式。
更新后的报告将通过电子邮件发送给销售经理。

表单响应日志记录（坐标模式）

提交 Microsoft Forms 表单会触发该流程。
该场景会根据提交的答案构建一个 JSON 对象。
获取文件功能检索响应日志工作簿。
使用“从行插入”和“从列插入”在下一个空行插入行，表名留空。
更新后的日志已保存。 SharePoint。

CRM商机导出

每周触发一次查询，以寻找新的机会。 CRM 连接器。
记录被转换为具有灵活字段名称的 JSON 数组。
添加行插入到“商机”表中，并启用“忽略属性标题”功能，以实现不区分大小写的标题匹配。
生成报告后，将分发给销售团队。

实用技巧

Never set Table Name and Insert From Row together

The two parameter sets belong to different insertion modes. Setting both returns an error, clear one set before running.

JSON Row Data accepts a single object or an array

A bare object inserts one row, an array inserts one row per object. Choose the shape that matches how many rows you are writing.

Excel Row Number is 1-based within the table

Row 1 in table mode is the first data row after the header, not the header itself. Set it accordingly when targeting a specific position.

Culture Name affects parsing, not just display

Set Culture Name to match how your source data formats dates and decimals (for example de-DE for comma decimals), otherwise conversion can misread values.

Ignore Attribute Titles solves case-mismatch headaches

If your JSON property names differ in case from the Excel table headers, enable Ignore Attribute Titles instead of renaming every header or every JSON key.

速查表

场地	价值
Action	`Excel - Add Rows`
Mode switch	`Table Name set = table mode, empty = coordinate mode`
JSON Row Data shape	`Single object or array of objects`
Default worksheet	`Sheet1`
Type conversion toggle	`Convert Numeric And Date = true (default)`
Default date/numeric format	`yyyy-MM-dd / N2`
Default culture	`en-US`
Output	`document (Base64 workbook) + Success + ErrorMessage + Errors`

常见问题

How do I insert JSON data into Excel in Power Automate?+

Add the PDF4me Excel - Add Rows action, map File Content and File Name from a prior action, set JSON Row Data to your JSON payload, then choose Table Name for table-based insertion or Insert From Row and Insert From Column for coordinate-based insertion.

What is the difference between table-based and coordinate-based insertion?+

Table-based insertion is used when Table Name is provided, JSON property names are matched to the Excel table headers and Excel Row Number sets the position within the table. Coordinate-based insertion is used when Table Name is empty, Insert From Row and Insert From Column set the exact worksheet cell where insertion starts, with no header matching.

Can I insert more than one row at once?+

Yes. Pass a JSON array of objects in JSON Row Data and every object becomes its own inserted row. A single JSON object inserts exactly one row.

What happens if I mix table-based and coordinate-based parameters?+

Setting Insert From Row or Insert From Column while Table Name is also set returns an error, since the two parameter sets belong to different insertion modes. Use one mode's parameters at a time.

How does automatic type conversion work?+

With Convert Numeric And Date enabled, JSON numbers become Excel numeric values formatted with Numeric Format Pattern, and date-like strings become Excel DateTime values formatted with Date Format Pattern. Culture Name controls how the incoming values are parsed before conversion. See <a href="https://learn.microsoft.com/en-us/dotnet/standard/base-types/standard-numeric-format-strings" target="_blank" rel="noopener noreferrer">Microsoft's numeric format string reference</a> and <a href="https://learn.microsoft.com/en-us/connectors/pdf4meconnect/" target="_blank" rel="noopener noreferrer">the PDF4me Power Automate connector reference</a> for details.