CopyFile error

Good afternoon.
I have a workflow that copies an entire excel and pastes it into another folder. What is happening is that the excel it pastes into the other folder comes empty. Can anyone explain why? To copy I have the activity “Copy File”.
in_TemplatePath+“Name_Excel_Template.xlsx”
to
in_Folder (Folder Path to paste file)

Hi

I hope that is not something to be dealt with copy file activity
Because even if the path provided is wrong it will throw error in that note only

But here it is something with the data which rely on the sheet which is actually copied

Make sure the file which you are copying is written with data or is with data before been copied

Before to this copy file activity Use a read range activity and read that excel sheet and get the output as a DATATABLE dt

Now use a writeline and mention as dt.Rows.Count.ToString

If it is more than zero then it’s fine and you will get to see the records in the file at destination folder

Else we need to check where it is missing to write the data

Cheers @dcmf

1 Like