topic Examples of 'json payload' to format cells with the Microsoft 365 - Excel object in Product Forum

Examples of 'json payload' to format cells with the Microsoft 365 - Excel object

JeremyRTDean — Wed, 20 Nov 2024 04:33:19 GMT

Hi,

I'm using the Microsoft 365 - Excel object and working around all the limitations of Microsoft's limited end points.

The Microsoft 365 – Excel VBO User Guide for the Format Fill action and 'Body' Parameter advises to enter: "The JSON payload with formatting properties"

Does anyone have examples of what these payloads could be? I'm no JSON expert.

I'm looking for formatting like: Bold Text, and fill with a certain colour etc.

Re: Examples of 'json payload' to format cells with the Microsoft 365 - Excel object

naveed_raza — Tue, 02 Dec 2025 11:49:35 GMT

in body you have to pass this JSON String

{ "bold": true, "color": "#4B180E" }

Re: Examples of 'json payload' to format cells with the Microsoft 365 - Excel object

naveed_raza — Tue, 02 Dec 2025 11:55:00 GMT

in you Body you have to pass this value for format fill

{ "color": "#4B180E" }

if you use Format font then you have to use this

{ "bold": true }