Write Excel Data in Outlook Email Body in UiPath

Help Studio
, , , , ,
1

Hello
I want to Write excel data in Outlook Email Body in UiPath.
I made process following

this Youtube and it works well.

However, I met some problems…

  1. extract Date from excel.
    Even though excel only have yyyyMMdd, it write hours,minutes,seconds(00:00:00)
    I want to extract only yyyyMMdd. How could it be possible?

  2. txt data overlapped
    image
    When it saved excel data to txt, it overlapped. So previous data leaves on txt and write new data on that txt.
    I don’t need old data.
    How could I delete old text and make new text file or overwritten text file?

Thank you

2

Hi @111153

  1. extract Date from excel.
    Even though excel only have yyyyMMdd, it write hours,minutes,seconds(00:00:00)
    I want to extract only yyyyMMdd. How could it be possible? Try preserve format in read range activity.

  2. Before for each row use a write text file activity and pass text as “” .so it will write a empty text on the text file.

You can also try this package for convert excel range to html table,

Thanks

3

Hello
first problem solved by using preserve format!

But second one is,
If process runs, it make text file.
But I don’t want to make this text file permanently. I just need this text file temporary for that running.
Is it possible to make text file temporary?

4

@111153

You can use an activity called delete file which is used to delete a file,

after your process done at the end use a delet file activity and give the text file path.

at the run time we created the file and deleted the file so it is temporary.

Thanks