KAPOW

Would you like to react to this message? Create an account in a few clicks or log in to continue.
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.


2 posters

    Error on step View as Excel.

    avatar
    pisaraviriyakul


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

    Error on step View as Excel.  Empty Error on step View as Excel.

    Post by pisaraviriyakul 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
    jking
    jking


    Posts : 103
    Points : 3851
    Join date : 2014-03-01
    Location : USA

    Error on step View as Excel.  Empty Re: Error on step View as Excel.

    Post by jking 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?
    avatar
    pisaraviriyakul


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

    Error on step View as Excel.  Empty Re: Error on step View as Excel.

    Post by pisaraviriyakul 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.
    jking
    jking


    Posts : 103
    Points : 3851
    Join date : 2014-03-01
    Location : USA

    Error on step View as Excel.  Empty Re: Error on step View as Excel.

    Post by jking 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.
    avatar
    pisaraviriyakul


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

    Error on step View as Excel.  Empty Re: Error on step View as Excel.

    Post by pisaraviriyakul 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


    Error on step View as Excel.  Empty Re: Error on step View as Excel.

    Post by Sponsored content


      Current date/time is Sat Apr 27, 2024 4:23 pm