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
Discussion posts and replies are publicly visible
AFAIK we don't have any plugins in place to directly manipulate or work with the excel data without brining it into database.
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.
Hi auroraj5980 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.