akshaysaundane's avatar
akshaysaundane
Copper Contributor
Sep 01, 2022
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