KAPOW

Welcome to the Kapow forum. Here you can get help, use your skills to help others and enjoy hanging out in the company of other Kapow Robot Developers.


Error on step View as Excel.

Share

pisaraviriyakul

Posts : 18
Points : 225
Join date : 2018-05-08

Error on step View as Excel.

Post by pisaraviriyakul on Sat Nov 03, 2018 8:38 pm

I execute robot on DS everything is work fine, but when I execute on MC I got this message "Error on step View as Excel. This step works on a preview"

Anyone knows cause of this?

Thank you
avatar
jking

Posts : 54
Points : 1793
Join date : 2014-03-01
Location : USA

Re: Error on step View as Excel.

Post by jking on Sat Nov 03, 2018 9:54 pm

Have you tried Open Excel?  Without knowing the previous steps or how you are working with excel it is difficult to give much help, but viewing excel and open excel are not the same steps.

Can  you elaborate on your process further?

pisaraviriyakul

Posts : 18
Points : 225
Join date : 2018-05-08

Re: Error on step View as Excel.

Post by pisaraviriyakul on Sun Nov 04, 2018 5:35 pm

My steps.

Load Page (Excel File path) --> View as Excel (Work fine on DS, Error On MC)

Then I tried

Load Page (Excel File Path) --> Extract to Variable --> Open Excel Variable  (Work fine on DS, Error On MC)

I'm not sure what I missing.
avatar
jking

Posts : 54
Points : 1793
Join date : 2014-03-01
Location : USA

Re: Error on step View as Excel.

Post by jking on Mon Nov 05, 2018 11:36 pm

Check permissions and the path\filename.  If you "browsed" for the path\filename, it will load in DS, but not in MC.  You need to enter the path in the File Name of the Load File step
(example \\xxxxx\xxxxx\Kapow\Reporting\FolderName\SpreasdheetName.xlsx).

Also, check permissions.  If the file is on your local machine, MC may not be able to reach it.  The file needs to be in a location mapped to MC.

pisaraviriyakul

Posts : 18
Points : 225
Join date : 2018-05-08

Re: Error on step View as Excel.

Post by pisaraviriyakul on Tue Nov 06, 2018 8:27 am

I found cause of this problem. MC cannot access map drive, so it cannot load file.

Thank you for your reply.

Sponsored content

Re: Error on step View as Excel.

Post by Sponsored content


    Current date/time is Thu Nov 15, 2018 12:05 pm