# -*- coding: utf-8 -*-
# This file is auto-generated, don't edit it. Thanks.
import os
import sys
import json
from typing import List
from alibabacloud_dingtalk.doc_1_0.client import Client as dingtalkdoc_1_0Client
from alibabacloud_tea_openapi import models as open_api_models
from alibabacloud_dingtalk.doc_1_0 import models as dingtalkdoc__1__0_models
from alibabacloud_tea_util import models as util_models
from alibabacloud_tea_util.client import Client as UtilClient
class Sample:
def __init__(self):
pass
@staticmethod
def create_client() -> dingtalkdoc_1_0Client:
"""
Initialize the account Client using Token
@return: Client
@throws Exception
"""
config = open_api_models.Config()
config.protocol = 'https'
config.region_id = 'central'
return dingtalkdoc_1_0Client(config)
@staticmethod
def main(
args: List[str],
) -> None:
client = Sample.create_client()
create_conditional_formatting_rule_headers = dingtalkdoc__1__0_models.CreateConditionalFormattingRuleHeaders()
create_conditional_formatting_rule_headers.x_acs_dingtalk_access_token = '<your access token>'
cell_style = dingtalkdoc__1__0_models.CreateConditionalFormattingRuleRequestCellStyle(
background_color='#ff0000',
font_color='#ff0000'
)
number_condition = dingtalkdoc__1__0_models.CreateConditionalFormattingRuleRequestNumberCondition(
operator='between',
value_1=10,
value_2=50
)
duplicate_condition = dingtalkdoc__1__0_models.CreateConditionalFormattingRuleRequestDuplicateCondition(
operator='duplicate'
)
create_conditional_formatting_rule_request = dingtalkdoc__1__0_models.CreateConditionalFormattingRuleRequest(
operator_id='ppgAxxx',
ranges=[
'A1:B2'
],
duplicate_condition=duplicate_condition,
number_condition=number_condition,
cell_style=cell_style
)
try:
client.create_conditional_formatting_rule_with_options('e54Lq3xxx', 'Sheet1', create_conditional_formatting_rule_request, create_conditional_formatting_rule_headers, util_models.RuntimeOptions())
except Exception as err:
if not UtilClient.empty(err.code) and not UtilClient.empty(err.message):
# The err contains code and message attributes, which help developers locate the issue.
pass
@staticmethod
async def main_async(
args: List[str],
) -> None:
client = Sample.create_client()
create_conditional_formatting_rule_headers = dingtalkdoc__1__0_models.CreateConditionalFormattingRuleHeaders()
create_conditional_formatting_rule_headers.x_acs_dingtalk_access_token = '<your access token>'
cell_style = dingtalkdoc__1__0_models.CreateConditionalFormattingRuleRequestCellStyle(
background_color='#ff0000',
font_color='#ff0000'
)
number_condition = dingtalkdoc__1__0_models.CreateConditionalFormattingRuleRequestNumberCondition(
operator='between',
value_1=10,
value_2=50
)
duplicate_condition = dingtalkdoc__1__0_models.CreateConditionalFormattingRuleRequestDuplicateCondition(
operator='duplicate'
)
create_conditional_formatting_rule_request = dingtalkdoc__1__0_models.CreateConditionalFormattingRuleRequest(
operator_id='ppgAxxx',
ranges=[
'A1:B2'
],
duplicate_condition=duplicate_condition,
number_condition=number_condition,
cell_style=cell_style
)
try:
await client.create_conditional_formatting_rule_with_options_async('e54Lq3xxx', 'Sheet1', create_conditional_formatting_rule_request, create_conditional_formatting_rule_headers, util_models.RuntimeOptions())
except Exception as err:
if not UtilClient.empty(err.code) and not UtilClient.empty(err.message):
# The err contains code and message attributes, which help developers locate the issue.
pass
if __name__ == '__main__':
Sample.main(sys.argv[1:])
