Hi Thanks for the video, is there a solution if in my table i don't have PK ? Thanks a lot
@tylerkolota Жыл бұрын
Are you just trying to delete an entire table? If so, other solutions may be better. (stackoverflow.com/questions/63250671/how-to-delete-all-rows-in-a-table-using-office-scripts) If you need to only delete sub-sets of your table data, then you will want to create a primary key for your table if you want to batch delete here.
@tylerkolota Жыл бұрын
See the related Excel Batch Upsert template video here: kzbin.info/www/bejne/fpqohmZqft1onaM