Keeping an Excel visible to update the status - But no Excel application installed

Help Studio
, ,
1

Hi Team,

Thanks in Advance…!

Here I am facing an challenge with excel and I need some ideas,

I have an shared folder, In that input excel is placed. I want to update the completion status in one STATUS column. The challenge I am facing is there is no Microsoft excel or any application to open and view that.

Here my requirement is to update the STATUS by keeping the excel open or visible to update it by bot.

Note:- I have tried using Excel Application Scope and Workbook activities. But no results as I expected.

Please find the below screen shot for your reference.

image

Thanks & Regards,
Anbumani S

2

@Anbumani

Try Invoke code or vba macros to update the status in excel
Hope it helps

3

Hi @Anbumani

Check out this thread

Regards

4

@Anbumani

Please have a look and try:

1.When using Workbook activities, such as Read Range, Write Range, etc., you can set the Visible property to True. This property specifies whether the Excel window is visible during execution.
2. Setting the Visible property to True ensures that the Excel window is opened and visible while the automation is running, even if Microsoft Excel is not installed.
3. This allows the bot to interact with the Excel file as if it were open, updating the completion status in the STATUS column.

5

Hi @naveen.s,

Could you please share me the screen shot for this. Because I am not able to find the Visible property.

Thanks…!

6

@Anbumani
image

Please refer that

7

Hi @rlgandu,

Could you please share me the sample code or examples for better understanding.

Thanks…!

8

@naveen.s Thanks for response. We need this in Workbook activity not in Excel Application Scope. Since we don’t have any excel application in the system to open or view it.

If you have any ideas please suggest.

Thanks…!