在Logic App中将HTML表转换为Excel文件并作为附件发送 [英] Convert HTML Table to Excel file in Logic App and send it as attachment

问题描述

你好

我想通过电子邮件发送日志分析查询结果，但我也希望将结果作为excel电子表格(而不是CSV)附加.我试图在运行查询并显示结果"之后添加一个操作.以某种方式附加输出 变量，然后从该变量创建excel文件，但无法设法做到这一点.

解决方案

您可以使用plumsail连接器从Json Array创建XLSX文件.

https://plumsail.com/docs/documents/v1 .x/document-generation/xlsx/demos.html#tables

https://plumsail.com /docs/documents/v1.x/flow/how-tos/documents/create-xlsx-from-template.html {

connections":{ 值":{ "office365":{ "connectionId":"/subscriptions/< SubscriptionId>/resourceGroups/< ResourceGroup>/providers/Microsoft.Web/connections/office365"， " connectionName":"office365"， "id":"/subscriptions/< SubscriptionId>/providers/Microsoft.Web/locations/southeastasia/managedApis/office365" }， "plumsail":{ "connectionId":"/subscriptions/< SubscriptionId>/resourceGroups/< ResourceGroup>/providers/Microsoft.Web/connections/plumsail"， "connectionName":"plumsail"， "id":"/subscriptions/< SubscriptionId>/提供者/Microsoft.Web/locations/southeastasia/managedApis/plumsail" }， "sharepointonline":{ "connectionId":"/subscriptions/< SubscriptionId>/resourceGroups/< ResourceGroup>/providers/Microsoft.Web/connections/sharepointonline"， "connectionName":"sharepointonline"， "id":"/subscriptions/< SubscriptionId>/提供者/Microsoft.Web/locations/southeastasia/managedApis/sharepointonline" } } }， 定义":{ "

schema":"https://schema.management.azure.com/providers/Microsoft.Logic/schemas/2016-06-01/workflowdefinition.json#" ， 操作":{ " Create_XLSX_document_from_template" ;: { 输入":{ 身体":{ 数据":"@ body('HTTP')"， " documentContent" ;:" @body('Get_file_content')" }， 主机":{ 连接":{ "名称" ;:" @parameters('

Hello,

I would like to send log analytics query results through an email, but I also want the results to be attached as an excel spreadsheet (not CSV). I tried to add an actions after the "Run query and visualize results" to somehow append the output to the variable and create the excel file out of that variable, but couldn't manage to figure out the way to do so. Is it actually possible? 

解决方案

You can use plumsail connector to create a XLSX file from Json Array.

https://plumsail.com/docs/documents/v1.x/document-generation/xlsx/demos.html#tables

https://plumsail.com/docs/documents/v1.x/flow/how-tos/documents/create-xlsx-from-template.html

Below is the code view of my sample:

{
    "

connections": { "value": { "office365": { "connectionId": "/subscriptions/<SubscriptionId>/resourceGroups/<ResourceGroup>/providers/Microsoft.Web/connections/office365", "connectionName": "office365", "id": "/subscriptions/<SubscriptionId>/providers/Microsoft.Web/locations/southeastasia/managedApis/office365" }, "plumsail": { "connectionId": "/subscriptions/<SubscriptionId>/resourceGroups/<ResourceGroup>/providers/Microsoft.Web/connections/plumsail", "connectionName": "plumsail", "id": "/subscriptions/<SubscriptionId>/providers/Microsoft.Web/locations/southeastasia/managedApis/plumsail" }, "sharepointonline": { "connectionId": "/subscriptions/<SubscriptionId>/resourceGroups/<ResourceGroup>/providers/Microsoft.Web/connections/sharepointonline", "connectionName": "sharepointonline", "id": "/subscriptions/<SubscriptionId>/providers/Microsoft.Web/locations/southeastasia/managedApis/sharepointonline" } } }, "definition": { "

schema": "https://schema.management.azure.com/providers/Microsoft.Logic/schemas/2016-06-01/workflowdefinition.json#", "actions": { "Create_XLSX_document_from_template": { "inputs": { "body": { "data": "@body('HTTP')", "documentContent": "@body('Get_file_content')" }, "host": { "connection": { "name": "@parameters('

这篇关于在Logic App中将HTML表转换为Excel文件并作为附件发送的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！