Forum Discussion
tarunkamboj
Microsoft
Jun 20, 2023How to remove data from excel workbook?
Hello everyone,
Problem statement: We want to remove data from excel workbook and save customized workbook to Dataverse table.
Scenario: We are storing excel workbook in Dataverse table in body binary field. User can visit our app, download the excel workbook in local disk. This excel has a connection with PowerBI dataset.
When user open the excel, data got populated using the connection. User can do customization and save them.
Requirement: Our requirement is to save the customized workbook back to Dataverse table but without the data.
Can anyone please suggest how can we remove data from excel workbook?
No RepliesBe the first to reply