berkaykor
(David Lopez)
1
Hey everyone,
I have process where i need to append certain columns some values like todays date to date column, number etc.
to A column I need to write date, to B sender.toString(the mail senders address), to C some hardcodded string.
Example.
A----------------B-------------C
11.11.2011------asdas@mail----“not sent”
(this is what the excel consists, I want to add (append) to next row)
A----------------B-------------C
11.11.2011------asdas@mail----“not sent”
15.3.2020------somethinelse@mail----“sent”
any ideas?
Hi @berkaykor
Read the datatable and store in dt1 variable
Use add datarow to add the data to the dt1 variable in array format or in datarow format
Hope it helps you
Mark it as solution if you got it
Regards
Nived N
Happy Automation
Did it solved ur query @berkaykor
berkaykor
(David Lopez)
5
yes I used array to add to dt.
Is there I way I can use Now() to send date to excel?
array will be like
{now(),sender.tostring,“success”}
Hi @berkaykor
U mean to add date to a column ?
berkaykor
(David Lopez)
7
yes I edited the last respons like that
Yes
But since u want date in format dd.MM.yyyy
u can add now like this
{Now.ToString(“dd.MM.yyyy”), sender.ToString, “success”}
berkaykor
(David Lopez)
9
It doesnt add the date, it writes dd.MM.yyyy to the column
berkaykor
(David Lopez)
10
used:
System.DateTime.Now.ToString("dd-mm-yyyy hh:mm:ss")
working
Date I mean is in different format of dd.MM.yyyy
system
(system)
Closed
12
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.