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
