怎么调整HTML里的datatable格式

大家好,
发邮件时我需要把一个table数据贴到邮件body里,于是我做了一个HTML,但是邮件发出来后是这样的,格式不太对,请问一下这个怎么调整呢,谢谢!

@yt.yutao 可以截下这个activity吗

Hi @yt.yutao

In Read Range workbook please remove the Add Headers Option and pass the datatable variable in Create HTML Content.


Removing Add Headers option will give you a table with headers
image

image

Regards

@yt.yutao

Use create Html Content activity and pass the datatable

image

Click on Open editor and then click add data value
and click Map data Value and then select Table Pass the Datatable

Hi @jack.chan

下列是生成datatable和生成HTML的截图

image

邮件发出来是这样的

Hi @yt.yutao

Read Range Filtered datatable by removing Add Headers option and pass that output datatable variable to Create HTML Content. You will get an table with headers.

Regards

@yt.yutao read range activity 里面要勾选 “add headers”

@jack.chan
我选了

@jack.chan

其实我就要这样的格式就可以

可以这样写, 用以下assign activity覆盖 create html content activity

assign → HTML_POBody

"Dear Meng Yan<br><br>请给下列Rework订单CNF, 信息<br><br>" + String.Join(environment.newline, POTable.asEnumerable.Select(function(x) x(0).toString).ToList) + "<br><br>With best regards"

@jack.chan

抱歉没跟您说清楚,我这body里还有个图片,所以不能只用语句。但我是不是可以把您的语句写在{{Value}}里 ?

可以 @yt.yutao
将这个语句写在 {{value}} 里
String.Join(environment.newline, POTable.asEnumerable.Select(function(x) x(0).toString).ToList)

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.