@mcp-z/mcp-sheets
Preparing search index...
mcp
toolFactories
cellsFormat
Function cellsFormat
cellsFormat
()
:
{
config
:
{
description
:
"Apply formatting (colors, borders, fonts, alignment, number formats) to cell ranges without modifying data. Supports batch operations for efficiency. Colors use 0-1 RGB format. Best for creating professional, visually organized spreadsheets."
;
inputSchema
:
ZodObject
<
{
gid
:
ZodCoercedString
<
unknown
>
;
id
:
ZodString
;
requests
:
ZodArray
<
ZodObject
<
{
backgroundColor
:
ZodOptional
<
ZodObject
<
{
blue
:
ZodNumber
;
green
:
ZodNumber
;
red
:
ZodNumber
}
,
$strip
,
>
,
>
;
bold
:
ZodOptional
<
ZodBoolean
>
;
borders
:
ZodOptional
<
ZodObject
<
{
color
:
ZodObject
<
(...)
,
(...)
>
;
style
:
ZodEnum
<
(...)
>
}
,
$strip
,
>
,
>
;
fontSize
:
ZodOptional
<
ZodNumber
>
;
horizontalAlignment
:
ZodOptional
<
ZodEnum
<
{
CENTER
:
"CENTER"
;
LEFT
:
"LEFT"
;
RIGHT
:
"RIGHT"
}
>
,
>
;
numberFormat
:
ZodOptional
<
ZodObject
<
{
pattern
:
ZodOptional
<
(...)
>
;
type
:
ZodEnum
<
(...)
>
}
,
$strip
,
>
,
>
;
range
:
ZodString
;
textColor
:
ZodOptional
<
ZodObject
<
{
blue
:
ZodNumber
;
green
:
ZodNumber
;
red
:
ZodNumber
}
,
$strip
,
>
,
>
;
}
,
$strip
,
>
,
>
;
}
,
$strip
,
>
;
outputSchema
:
ZodObject
<
{
result
:
ZodDiscriminatedUnion
<
[
ZodObject
<
{
failedRanges
:
ZodOptional
<
ZodArray
<
ZodObject
<
(...)
,
(...)
>
>
>
;
gid
:
ZodString
;
id
:
ZodString
;
sheetTitle
:
ZodString
;
sheetUrl
:
ZodString
;
successCount
:
ZodNumber
;
type
:
ZodLiteral
<
"success"
>
;
}
,
$strip
,
>
,
ZodObject
<
{}
,
$strip
>
,
]
,
"type"
,
>
;
}
,
$strip
,
>
;
}
;
handler
:
(
__namedParameters
:
{
gid
:
string
;
id
:
string
;
requests
:
{
backgroundColor
?:
{
blue
:
number
;
green
:
number
;
red
:
number
}
;
bold
?:
boolean
;
borders
?:
{
color
:
{
blue
:
number
;
green
:
number
;
red
:
number
}
;
style
:
"SOLID"
|
"DASHED"
|
"DOTTED"
;
}
;
fontSize
?:
number
;
horizontalAlignment
?:
"LEFT"
|
"CENTER"
|
"RIGHT"
;
numberFormat
?:
{
pattern
?:
string
;
type
:
"TEXT"
|
"NUMBER"
|
"PERCENT"
|
"CURRENCY"
|
"DATE"
|
"TIME"
;
}
;
range
:
string
;
textColor
?:
{
blue
:
number
;
green
:
number
;
red
:
number
}
;
}
[]
;
}
,
extra
:
EnrichedExtra
,
)
=>
Promise
<
{
[
key
:
string
]:
unknown
}
>
;
name
:
string
;
}
Returns
{
config
:
{
description
:
"Apply formatting (colors, borders, fonts, alignment, number formats) to cell ranges without modifying data. Supports batch operations for efficiency. Colors use 0-1 RGB format. Best for creating professional, visually organized spreadsheets."
;
inputSchema
:
ZodObject
<
{
gid
:
ZodCoercedString
<
unknown
>
;
id
:
ZodString
;
requests
:
ZodArray
<
ZodObject
<
{
backgroundColor
:
ZodOptional
<
ZodObject
<
{
blue
:
ZodNumber
;
green
:
ZodNumber
;
red
:
ZodNumber
}
,
$strip
,
>
,
>
;
bold
:
ZodOptional
<
ZodBoolean
>
;
borders
:
ZodOptional
<
ZodObject
<
{
color
:
ZodObject
<
(...)
,
(...)
>
;
style
:
ZodEnum
<
(...)
>
}
,
$strip
,
>
,
>
;
fontSize
:
ZodOptional
<
ZodNumber
>
;
horizontalAlignment
:
ZodOptional
<
ZodEnum
<
{
CENTER
:
"CENTER"
;
LEFT
:
"LEFT"
;
RIGHT
:
"RIGHT"
}
>
,
>
;
numberFormat
:
ZodOptional
<
ZodObject
<
{
pattern
:
ZodOptional
<
(...)
>
;
type
:
ZodEnum
<
(...)
>
}
,
$strip
,
>
,
>
;
range
:
ZodString
;
textColor
:
ZodOptional
<
ZodObject
<
{
blue
:
ZodNumber
;
green
:
ZodNumber
;
red
:
ZodNumber
}
,
$strip
,
>
,
>
;
}
,
$strip
,
>
,
>
;
}
,
$strip
,
>
;
outputSchema
:
ZodObject
<
{
result
:
ZodDiscriminatedUnion
<
[
ZodObject
<
{
failedRanges
:
ZodOptional
<
ZodArray
<
ZodObject
<
(...)
,
(...)
>
>
>
;
gid
:
ZodString
;
id
:
ZodString
;
sheetTitle
:
ZodString
;
sheetUrl
:
ZodString
;
successCount
:
ZodNumber
;
type
:
ZodLiteral
<
"success"
>
;
}
,
$strip
,
>
,
ZodObject
<
{}
,
$strip
>
,
]
,
"type"
,
>
;
}
,
$strip
,
>
;
}
;
handler
:
(
__namedParameters
:
{
gid
:
string
;
id
:
string
;
requests
:
{
backgroundColor
?:
{
blue
:
number
;
green
:
number
;
red
:
number
}
;
bold
?:
boolean
;
borders
?:
{
color
:
{
blue
:
number
;
green
:
number
;
red
:
number
}
;
style
:
"SOLID"
|
"DASHED"
|
"DOTTED"
;
}
;
fontSize
?:
number
;
horizontalAlignment
?:
"LEFT"
|
"CENTER"
|
"RIGHT"
;
numberFormat
?:
{
pattern
?:
string
;
type
:
"TEXT"
|
"NUMBER"
|
"PERCENT"
|
"CURRENCY"
|
"DATE"
|
"TIME"
;
}
;
range
:
string
;
textColor
?:
{
blue
:
number
;
green
:
number
;
red
:
number
}
;
}
[]
;
}
,
extra
:
EnrichedExtra
,
)
=>
Promise
<
{
[
key
:
string
]:
unknown
}
>
;
name
:
string
;
}
Settings
Member Visibility
Protected
Inherited
Theme
OS
Light
Dark
@mcp-z/mcp-sheets
Loading...