Suddenly Bot is not able to read the excel file

Help Activities
, , ,
#1

Hi All

We have an excel file in a D drive folder which is a status file containing all the records processed.
Suddenly Bot is not able to read the file and creating multiple copies of the same file without any records.

File is blank without any column itself.

image

Forum Engagement Daily Reports
#2

@Palaniyappan @lakshman

#3

HI @kkpatel

Check if file exist return true when you check whether the file is in the location or not

Regards
Sudharsan

#4

Yes file is in location. Looks like bot is not able to read the file.

But how come it is creating new files ?

#5

Hi @kkpatel ,

Can you show a glimpse of code so that we can check.

Cheers

#6

Could you please share a screenshot of the error message?

Thanks!

#7

Its just using Excel Application Scope and reading the file and writing the file.

#8

Actually that’s where we did a mistake. Instead of exception.message we just printed some custom message in the Catch section.

#9

May be Bot is finding any Temp file so it starts creating another file. In that case you can check in a control of no Temp file availability.

#10

@kkpatel

Can you print the Exception.Message in catch section and share it here. So that we can check and help you to resolve the issue.

#11

In the server the folder and files were made read only. Hence Bot was not able to read the file.

Thanks All…

#12

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