How to retrieve sheet data with formatting with Google Sheets Api V4

Question

I want to retrieve only sheet's data from a spreadsheet with formatting.

How to achieve the same with Sheets Api?

Sam Berlin · Accepted Answer · 2018-03-03 19:19:06Z

17

It isn't clear from your question just what kind of data you want to get. Do you want to retrieve the values as they're formatted in the Google Sheets UI? If so, then use the spreadsheets.values.get API. The parameter valueRenderOption controls how the values are formatted. By default, the value is FORMATTED_VALUE, which will return the data as it's formatted in the Sheets UI. Other values are listed on the ValueRenderOption reference page. See the Basic Reading sample for more information.

If you want to retrieve the information about the format itself, use the spreadsheets.get API. Format information is in the response's CellData (at sheets.data.rowData.values), in both the userEnteredFormat and effectiveFormat fields.

edited Mar 3, 2018 at 19:19

answered Dec 27, 2016 at 16:23

Sam Berlin

3,80316 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Shyamal Parikh Over a year ago

I want to get things like cell border, color, etc with the data in those cells

Sam Berlin Over a year ago

The latter part of my answer is what you're looking for then, using spreadsheets.get and the userEnteredFormat or effectiveFormat of the CellData.

Collectives™ on Stack Overflow

How to retrieve sheet data with formatting with Google Sheets Api V4

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related