How to extract email from email table and then write to excel

[xxGoRpa]

I dont wan

Name of School	xx
Name of FP	yy
Type of Query	aa
Date In
Query Question	bb
Query Solution	cc

i only wan xx, yy, aa, , bb, cc with my preset excel with the header in an row

[AMAN_GUPTA]

Hello,

Save body content as html file and open html file in a web browser.
Then open html file in web browser and extract table.

Regards,
Aman

[lrtetala (Lakshman Reddy)]

@xxGoRpa

i only wan xx, yy, aa, , bb, cc with my preset excel with the header in an row

Hi @xxGoRpa

Can you try below

String.Join(", ", DT.AsEnumerable().Select(Function(r) r.Field(Of String)(1).Trim()))

Input:

Cheers!!

[Anil_G (Anil Gorthi)]

@xxGoRpa

Then delete the columns you dont need

If you want the column to be transposed then let me know accordingly we can transposse

Cheers