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.


3 posters

    Results getting prepended instead of appending to the excel file

    avatar
    amaheshwary


    Posts : 14
    Points : 1867
    Join date : 2019-11-01

    Results getting prepended instead of appending to the excel file Empty Results getting prepended instead of appending to the excel file

    Post by amaheshwary Thu Nov 07, 2019 4:37 am

    The new rows data is getting added to line #1 and pushing other results down. How can fix this behaviour?

    From the context menu, I select: Modify | Insert | Rows | Last. A dialog box pops up. Accept Number of Rows: 1 by clicking on [OK].
    avatar
    EmmaC


    Posts : 3
    Points : 2434
    Join date : 2018-03-23

    Results getting prepended instead of appending to the excel file Empty Re: Results getting prepended instead of appending to the excel file

    Post by EmmaC Tue Dec 10, 2019 4:53 pm

    Hi, the excel variable you are writing to must be a global variable.  Otherwise the next time it loops it has not held on to the previous data and sees the first line as an empty line.
    Hope this makes sense.  If you need anything else, please let me know Smile
    avatar
    ivan.gordeyev


    Posts : 16
    Points : 1959
    Join date : 2019-07-25

    Results getting prepended instead of appending to the excel file Empty Re: Results getting prepended instead of appending to the excel file

    Post by ivan.gordeyev Tue Dec 10, 2019 5:14 pm

    Also, please check that you are not writing into a cell using static reference.
    E.g. Always insert a row after cell A1, instead of inserting a row based on what active cell/found cell is.
    avatar
    amaheshwary


    Posts : 14
    Points : 1867
    Join date : 2019-11-01

    Results getting prepended instead of appending to the excel file Empty Re: Results getting prepended instead of appending to the excel file

    Post by amaheshwary Wed Dec 11, 2019 10:29 pm

    Thanks Emma/Ivan. 

    This was resolved. Had to make it global variable.

    Sponsored content


    Results getting prepended instead of appending to the excel file Empty Re: Results getting prepended instead of appending to the excel file

    Post by Sponsored content


      Current date/time is Fri Nov 15, 2024 1:50 pm