Excel Loop Vaues Populate issue

mundarinti.veeresh · April 29, 2021, 3:08pm

Hi Team,

while using excel loop activity, the excel values not visible at excel sheet drop down.
PFA screen shot for reference.

Thanks & Regards
Veeresh M

amit_anand15 · April 30, 2021, 3:39am

Hi,

Excel sheet shows the sheets available in excel work book.

Ensure the sheets are not locked

Regards,
Amit

mundarinti.veeresh · April 30, 2021, 4:21am

Hi Amit,

My sheets are not locked and still it is not showing the sheet names.

Thanks & Regards
Veeresh M

amit_anand15 · May 3, 2021, 12:53pm

Hi,

Is it happening for only 1 excel or any excel on your machine. Which excel version is installed on your machine

Regards,
Amit

mundarinti.veeresh · May 3, 2021, 2:20pm

Hi Amith,

It is happening any excel on my machine. currently using ms excel version 16 and 64 bit.

Thanks & Regards
Veeresh M

amit_anand15 · May 4, 2021, 4:27am

Hi,

it appears to be machine specific issue. Can you please share studion logs when this is happening

Regards,
Amit

mundarinti.veeresh · May 4, 2021, 7:24am

Hi Amit,

PFA log file.AssistEdge_Studio.log (4.2 KB)
here machine name,user id and ip addrees I have removed for security reasons.

Thanks & Regards
Veeresh M

amit_anand15 · May 5, 2021, 3:53am

Hi,

Appears to be permission related issue on your system:

goto Controlpanel → Administrative tools–>Component Services -->computers → myComputer -->DCOM Config → Microsoft Excel Application.

right click to get properties dialog. Goto Security tab and customize permissions accordingly.

Regards,
Amit