How to fetch the regex output and write into excel file

[chaithanya_kumar_M]

Hi Everyone,

Am able to retrieve the data from the regular expression builder but now I wanted to write into excel since the output is innumerable how to change to the data table and write into the excel file

Regards,
Chaithanya

[prasath_S]

Hi @chaithanya_kumar_M

Please try this

Build datatable output is dtTable1
Matches output is matchColl

in add data row activity give Arrayrow as {item.ToString} and Datatable as dtTable1

and in write range give datatable as dtTable1

Thanks

[chaithanya_kumar_M]

Hi @prasath_S

Perfect it works as expected thanks!!

Regards,
Chaithanya