For each row create file

[mateo.drouillard]

Hello everybody,

For each different email I would like to create a file.

It’s possible ?

Thank !

[jack.chan]

whats the file format @mateo.drouillard

[mateo.drouillard]

Excel file (.xlsx)

sorry

[jack.chan]

i mean how do you name each file?

[mateo.drouillard]

name of file = email

[jack.chan]

so its

test1.xlsx? …

[mateo.drouillard]

yes if is possible is perfect

[THIRU_NANI (NaNi)]

Hi!

Read the excel using read range, Output as DtOut.

Take one for each row in data table activity

take one assign activity Create one string variable File=CurrentRow(3).ToString.Trim
take one more assign Activity\

Assign FileName = System.Text.RegularExpressions.Regex.match(File,".*(?=@)").ToString

Take one write range in the file pass FileName+“.xlsx”

DataTable as DtOut

Regards,
NaNi

[jack.chan]

@mateo.drouillard
just do this

in excel application scope set filename = system.Text.RegularExpressions.Regex.Match(CurrentRow("Émettur DA").ToString, "(.*?)\@").Groups(1).Value+".xlsx"

make sure create if not exist is ticked

[mateo.drouillard]

it works but the created files are empty. And is it possible to put the corresponding data ?

[jack.chan]

yes, where you want the data? give an example… @mateo.drouillard

[mateo.drouillard]

for exemple in test1.xlsx the file contains all rows where Émetteur DA = test1@safrangroup.com

[jack.chan]

can you upload this excel

[mateo.drouillard]

TEST PUR05.xlsx (8.9 KB)

Thank !

[jack.chan]

here

TEST.xaml (11.8 KB)
@mateo.drouillard

[mateo.drouillard]

You are the best. Thank !