Lookup data doesnt work when Excel file is closed

Its working when i open the excel file before lunch the bot but if the excel file is closed before, it doesnt work, how can i solve this ?

@Soudios

Ensure that the “Visible” property in the Excel Application Scope activity is set to “False”. This way, the Excel application will run in the background without interfering with user interactions.
Implement error handling using try/catch blocks to handle potential issues with Excel interactions.

it still doesnt work

@Soudios

The Column Name value is said to invalid ,So give the Column name in double Quotes " " because column name is a string data type

its already a string data

@Soudios

You don’t pass any value to the variable please pass the Column name in double quotes

there is a value on the variable :

The issue is when the excel file is closed it doesnt work, but when the excel file is open its working

The excel file is a csv file

@Soudios

Then Use workbook activities and then use vlook in datatable, Using workbook activities you dont face the problem while running

Hope its Help you

Can you show me how i need to do ?

@Soudios

Use Read range workbook to read the excel file
Use lookUp activity

csv file is not supported

@Soudios

Use “Read Csv” You are using csv file right

There no choice for csv or xlsx file

@Soudios

image

@Soudios

If you are able to send your file ,So i able to understand and give you a result and i want a breif explanation what you want

i found the solution, i changed the delimiter

image

Is the column name a variable or the specific name? If it’s the specific name then you have to put it in double quotes.

its a specific name, the issue comes from the csv file, the quote are already done.

I have an other problem is that the excel file open every time it write a new line on the file, how can i do to write all the result on one time