Excel Application Scope forget to remove Excel tmp file many times

excel
studio

#1

Hi all
I made a project generating excel files.
This project simply create xlsx file via Excel Application Scope within For Each loop.
But I have an issue.
This project doesn’t remove a few tmp files.
Why?
UiPath_tmp_Files
Each run is different result.
UiPath_tmp_Files2


#2

Hello @tango,

are you able to open the xlsx file manually with out any issue / popup? This usually happens if excel is not closed properly.

Regards,
Balram


#3

hi @tango

Use dictionary

Dictionary dict=new Dictionary();
dict.GetFiles(“Path of the file”)
if .tmp exist use path exists
use Delete file option

Thanks
Ashwin S


#4

Thanks @balramrv and @AshwinS2
This file was made from Microsoft Excel 2016 standard template.
And I can open without any issue.
I created a brand new file from blank book and tried again.
It works fine.


#5

Unfortunately the tmp files are left behind again.

I created a brand new file from blank book and tried again.
It works fine.

This is not solution. :cold_sweat:


#6

Hello there,
I thinks its due to abruptly closing and creating new excel file.
give some delay after excel scope application this give sufficient time to save and close first excel and then create second and so on.(uncheck visible property (not sure this makes sense but i feel like :slight_smile: ) )

If issue persist try this.


#7

Hi @ddpadil
I investigated again and found what cause it.
When AutoSave option is checked, tmp is created and sometimes remain.


#8

Me and a collegue have a similar issue with word files…