Hello everybody,
For each different email I would like to create a file.
It’s possible ?
Thank !
Excel file (.xlsx)
sorry
i mean how do you name each file?
name of file = email
so its
test1.xlsx? …
yes if is possible is perfect
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
@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
it works but the created files are empty. And is it possible to put the corresponding data ?
You are the best. Thank !
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.