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 ?
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.
The Column Name value is said to invalid ,So give the Column name in double Quotes " " because column name is a string data type
You don’t pass any value to the variable please pass the Column name in double quotes
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
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 ?
Use Read range workbook to read the excel file
Use lookUp activity
Use “Read Csv” You are using csv file right
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
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