Issue in activity

Help Activities
,
1

Hi All,

i am coping file(i.e excel file) using copy file activity and copying the file in destination folder and after using it i am deleting that file in that folder(Temp Folder), but when BOT is trying to use the same file(original file) which is available in another folder which was used to read the file earlier, then BOT throws error. stating sheet in available, because i have implemented code like if there is data then delete it.
And when i am opening that file it , really it has no sheet with that name.
i need is i want to just copy the file and after use want to delete the file in Temp folder.

2

@RAKESH_KUMAR_Tiwari

Once reading excel it will store in Datable, so you can reuse?
Check that you have the data in datatable even after you delete the file to use

Hope this may help you

Thanks,
Srini

3

Hi @Srini84

no, there is no data at all, and no sheetname as well, it basically deleting my main file.

one doubt. i am taking the copy of file and renaming it in Temp folder and deleting it there

image
image
since i am deleting this in Temp folder, it should not delete my main file right?
it is not deleting the file, inside file Sheetname and data has been deleting.

4

@RAKESH_KUMAR_Tiwari

Can you check what is the value you are getting in newfilename and path_var
If you can show me in Immediate Pane that would help

Thanks,
Srini

5

it was reading wrong file from config file.

hence it is resolved