Append to excel question

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 :robot:

Happy Automation :slight_smile::slight_smile::slight_smile::slight_smile:

Thank you very much.

1 Like

Did it solved ur query @berkaykor

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 ?

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”}

It doesnt add the date, it writes dd.MM.yyyy to the column

used:
System.DateTime.Now.ToString("dd-mm-yyyy hh:mm:ss") working

Date I mean is in different format of dd.MM.yyyy

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.