CODEWITHSUNDEEP
google-sheets-api
GhostKU
GhostKU

Reputation: 2108

How to AutoFit column width with Google Sheets API?

Is there any way to AutoFit Column width in Google Sheets using Google Sheets API? I can find only DimensionProperties but it needs exact value n pixels.

Upvotes: 12

Views: 9066

Answers (1)

Tanaike
Tanaike

Reputation: 201358

You can achieve it using autoResizeDimensions of Sheets API. You can see the detail information at below links.

Endpoint

POST https://sheets.googleapis.com/v4/spreadsheets/### fileId ###:batchUpdate

Request body :

{
  "requests": [
    {
      "autoResizeDimensions": {
        "dimensions": {
          "sheetId": sheetId,
          "dimension": "COLUMNS",
          "startIndex": 0,
          "endIndex": 3
        }
      }
    }
  ]
}

References :

If I misunderstand your question, I'm sorry.

Upvotes: 24

Related Questions