akshaysaundane
Sep 01, 2022Copper Contributor
Status:
New
Append Row in Worksheet(Not in table) Excel using API
Hi Team,
We needs to create row at bottom in Excel worksheet through API.
Currently we using Update Range method for Update. But using Excel Graph API it take 10-30 second to reflect data in Excel and In GetUsedRange API call. so we unable to find exact last row.
Is there anything possible if we provide range and if value exists in provided range then through API it directly append to last Row
In Google Sheet they have this feature we need same for Excel.
https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/append
No CommentsBe the first to comment