Skip to main content
auroraj5980
auroraj5980
November 2, 2023
Question

Update Excel

  • November 2, 2023
  • 3 replies
  • 0 views

Hello everyone,
I need to delete some records from an excel in SharePoint and update some fields in others.
I have thought about downloading, saving to DB and doing it there and then generating Excel again and uploading it to SharePoint, but do you know of any way to do it directly, without having to save to DB?
thanks greetings

    3 replies

    D
    dineshd0003
    November 2, 2023

    AFAIK we don't have any plugins in place to directly manipulate or work with the excel data without brining it into database. 

    V
    vijayalakshmig0072
    November 2, 2023

    Hi ,

    First thing is do you want to keep track of deleted records ? In this case DB approach is the best way. Because from the DB table  we can able to identify what are the records are deleted in SharePoint.

    karumurua531442
    karumurua531442
    November 16, 2023

    Hi [mention:804ee5973d3440a1911980e60e176fef:e9ed411860ed4f2ba0265705b8793d05]  I think we don't have any direct method to do it. As you said you need to download the document and temporarily store it in appian. Use some staging table to modify the data when upload the file again, make the changes edit/delete the records and save into DB. Always have a copy of deleted records, because the records which are deleted might also be deleted in sharepoint.

    Terms & ConditionsAccessibility statement