Lark icon

Lark

Consume Lark API

Actions118

表格 → 设置单元格样式

AI-generated

Summary

Set formatting for a specified cell range in a Lark spreadsheet. Choose the spreadsheet and sheet, enter a range such as !A1:B2, then configure the style properties to apply.

Inputs

  • Authentication — Select Tenant Access Token or User Access Token authentication.
  • Spreadsheet ID (required) — Select a spreadsheet from the list or enter its ID.
  • Sheet ID (required) — Select a sheet from the chosen spreadsheet or enter its ID.
  • Cell range (required) — Range to style, in start:end form, for example !A1:B2.
  • Style — Optional formatting: background and font colors, border color and type, font size, bold, italic or clear font formatting, horizontal and vertical alignment, number format, and text decoration (underline or strikethrough).

Output shape

A list of items

The operation sends a style update to the Lark Sheets API for each input item and returns the API response data as JSON. Exact response fields are not shown in the supplied source.

Examples

Example 1: Highlight and bold a range

Set Cell range to !A1:B2, then configure the desired background color and bold font style.

Links

Discussion