How to update multiple rows at once


Does the update_rows() function allow for multiple rows to be referenced? I am working on creating a sheet that needs to have the most up-to-date data which comes from a database. If data in the database changes, I would like to be able to make the necessary updates to all the rows affected. I'm working with large amounts of data so I was wondering if this function would be able to make the updates for me at once.


  • BKing
    BKing ✭✭✭

    We tend to maintain a (sorry c#):

    List<rows> rowsToUpdate as a set of change values.

    So, run round our update loop and change all the required cells on every row that needs to be changed.

    And then call UpdateRows:

            IList<Row> updatedRow = smartsheet.SheetResources.RowResources.UpdateRows(

             sheetId, rowsToUpdate);

  • Sandhiya07

    Hi Bking,

    I'm having 1000 rows which needs to be updated and some rows to be added via smartsheet API method in UiPath. It's taking time, Could you please suggest fastest method and I'm having unique ID as well.


    Sandhiya P