# ! # ! # ! # ! “xlsx_protect_sheet_password” “xlsx_protect_sheet_permissions” “” #!DEFLINE_ATTRS = “真” #!EXPOSABLE_ATTRS =“fme_feature_type串(50)fme_rotation号(宽度,xlsx_col_props)fme_type串(50)fme_text_string串(50)fme_basename串(50)fme_db_operation串(宽度,xlsx_col_props)fme_text_size号(宽度,xlsx_col_props)xlsx_row_formatting串(宽度,xlsx_col_props) xlsx_raster_height number(width,xlsx_col_props) fme_sweep_angle number(width,xlsx_col_props) xlsx_raster_width number(width,xlsx_col_props) xlsx_row_id number(width,xlsx_col_props) fme_secondary_axis number(width,xlsx_col_props) fme_fill_color string(50) fme_geometry string(50) fme_dataset string(50) xlsx_raster_scale_factor number(width,xlsx_col_props) fme_primary_axis number(width,xlsx_col_props) xlsx_col_id number(width,xlsx_col_props) fme_start_angle number(width,xlsx_col_props) fme_color string(50)" #!DEFLINE_PARMS = “” GUI OPTIONAL NAMEDGROUP xlsx_layer_group xlsx_table_writer_mode%xlsx_field_names_out%xlsx_names_are_positions%xlsx_row_id_column%xlsx_truncate_group%xlsx_table_group%xlsx_rowcolumn_group%xlsx_protect_sheet%xlsx_advanced_group装订设置 “ ”“ ”GUI OPTIONAL DISCLOSUREGROUP xlsx_truncate_group xlsx_row_id%xlsx_drop_sheet%xlsx_trunc_sheet掉落/截断“ ”“” GUI OPTIONAL DISCLOSUREGROUP xlsx_rowcolumn_group xlsx_start_col%xlsx_start_row%xlsx_offset_col%xlsx_offset_row Start Position" "" "GUI ACTIVEDISCLOSUREGROUP xlsx_protect_sheet xlsx_protect_sheet_password%xlsx_protect_sheet_level%xlsx_protect_sheet_permissions Protect Sheet" NO "GUI OPTIONAL DISCLOSUREGROUP xlsx_advanced_group xlsx_sheet_order%xlsx_freeze_end_row%xlsx_raster_type Advanced" "" "GUI CHOICE xlsx_drop_sheet Yes%No Drop Existing Sheet/Named Range:" No "GUI CHOICE xlsx_trunc_sheet Yes%No Truncate Existing Sheet/Named Range:" No "GUI OPTIONAL RANGE_SLIDER xlsx_sheet_order 1%MAX Sheet Order (1 - n):" "" "GUI OPTIONAL RANGE_SLIDER xlsx_freeze_end_row 1%MAX Freeze First Row(s) (1 - n):" "" "GUI CHOICE xlsx_field_names_out Yes%No Output Field Names:" Yes "GUI CHOICE xlsx_names_are_positions Yes%No Use Attribute Names As Column Positions:" No "GUI OPTIONAL TEXT xlsx_start_col Named Range Start Column:" "" "GUI OPTIONAL INTEGER xlsx_start_row Named Range Start Row:" "" "GUI OPTIONAL TEXT xlsx_offset_col Start Column:" "" "GUI OPTIONAL INTEGER xlsx_offset_row Start Row:" "" "GUI CHOICE xlsx_raster_type BMP%JPEG%PNG Raster Format:" PNG "GUI OPTIONAL PASSWORD_ENCODED xlsx_protect_sheet_password Password:" “GUI ACTIVECHOICE_LOOKUP xlsx_protect_sheet_level选择 只有 权限、PROT_DEFAULT xlsx_protect_sheet_permissions %的观点 只有 权限、PROT_ALL xlsx_protect_sheet_permissions %具体 权限保护水平:“ GUI可选的LOOKUP_LISTBOX xlsx_protect_sheet_permissions选择 锁着的 细胞,PROT_SEL_LOCKED_CELLS %选择 解锁 细胞,PROT_SEL_UNLOCKED_CELLS %格式 细胞,PROT_FORMAT_CELLS %格式 列,PROT_FORMAT_COLUMNS %格式 行,PROT_FORMAT_ROWS %插入 列,PROT_INSERT_COLUMNS %插入 行,PROT_INSERT_ROWS %添加 超链接 解锁 细胞,PROT_INSERT_HYPERLINKS %删除 解锁 列,PROT_DELETE_COLUMNS %删除 解锁 行,PROT_DELETE_ROWS % 解锁 细胞/行/列\ PROT_SORT %使用 自动筛选 解锁 细胞,PROT_AUTOFILTER %使用 数据透视表 & PivotChart 解锁 细胞,PROT_PIVOTTABLES %编辑 解锁 对象,PROT_OBJECTS %编辑 无保护的 场景,PROT_SCENARIOS特定权限:“ "GUI ACTIVECHOICE xlsx_table_writer_mode Insert,+xlsx_row_id_column+%Update,+xlsx_row_id_column+xlsx_row_id Writer Mode:" Insert "GUI可选的ATTR xlsx_row_id_column ALLOW_NEW行号属性:" "" " #! "ATTR_INDEX_TYPES = " " # !ATTR_NAME_INVALID_CHARS="\\"*{}$" #!SUPPORTS_FEATURE_TYPE_FANOUT = " true " # !启用= " true " # !DYNAMIC_FEATURE_TYPES_LIST_ON_MERGE = " true " # !DATASET_TYPE = "文件" # !GENERATE_FME_BUILD_NUM = " 19246 " # !COORDSYS = " " # !FANOUT_EXPRESSION = " " # !FANOUT_GROUP = "不" # !> # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # !

首轮

" # !POSITION="1110.0053000530004 -351.50435004350044" #! TOP_LEFT="1110.0053000530004 -351.50435004350044" #! BOTTOM_RIGHT="1564.0053000530004 -352.50435004350044" #! BOUNDING_RECT="1110.0053000530004 -351.50435004350044 454 1" #! ORDER="500000000000003" #! FOLLOW_ANCHOR="true" #! INFO_NODE="false" #! CUSTOM_USER_COLOR="false" #! COLOUR="1,1,0.95686274509803926,0.78431372549019607" #! SIZE_POLICY="10" #! ANCHORED_NODE="3" #! /> #!

第二次运行

“#!位置=” 1110.0053000530004 -649.00682506825035" #!TOP_LEFT = “1110.0053000530004 -649.00682506825035” #!BOTTOM_RIGHT = “1564.0053000530004 -650.00682506825035” #!BOUNDING_RECT = “1110.0053000530004 -649.00682506825035 454 1” #!ORDER = “500000000000004” #!FOLLOW_ANCHOR =“真” #!INFO_NODE = “假” #!CUSTOM_USER_COLOR = “假” #!COLOR = “1,1,0.95686274509803926,0.78431372549019607” #!SIZE_POLICY = “10” #!ANCHORED_NODE = “5” #!/>#!
# ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # !
FME_PYTHON_VERSION 37 GUI忽略DestDataset_XLSXW_1 XLSXW_OUT_FME_GROUP_NAMED1_XLSXW_1、XLSXW_OUT_OVERWRITE_FILE_XLSXW_1 XLSXW_OUT_TEMPLATEFILE_XLSXW_1, XLSXW_OUT_TEMPLATE_SHEET_XLSXW_1 DEFAULT_MACRO DestDataset_XLSXW美元(FME_MF_DIR) excelOutput.xlsx GUI文件名DestDataset_XLSXW Excel_Files (* .xlsx; * .xlsm; * xls) | * .xlsx; * .xlsm; * xls | All_files(*) | *目的地Microsoft Excel文件:包括(如果{{$ (DestDataset_XLSXW)} = = {}} {puts_real{参数“DestDataset_XLSXW”必须有一个值。};退出1;};)# !START_HEADER # !MULTI_WRITER_TYPE MULTI_READER WRITER_TYPE MULTI_WRITER MULTI_WRITER_DATASET_ORDER BY_ID MULTI_WRITER_FIRST_WRITER_ID 0 MULTI_WRITER_TYPE{0} XLSXW MULTI_WRITER_KEYWORD{0} XLSXW_1 #!END_WB_HEADER # !宏WB_KEYWORD“XLSXW_1”#!END_WB_HEADER # !START_DEST_HEADER XLSXW XLSXW_1 # = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = #首先获得数据库的数据集。对于Excel,它是文件名。现在,我们将使用他们在生成这个映射文件时所拥有的一切,而不是reprompt #!END_DEST_HEADER # !START_WB_HEADER DEFAULT_MACRO DestDataset包含[if {"$(DestDataset)"] != ""} { \ puts {DEFAULT_MACRO DestDataset_XLSXW_1 $(DestDataset)} \ } ] #!END_WB_HEADER # !*.xlsm;* .xlsm;* .xlsm;*.xls# ============================================================================ DEFAULT_MACRO XLSXW_OUT_FME_GROUP_NAMED1_XLSXW_1 GUI OPTIONAL DISCLOSUREGROUP XLSXW_OUT_FME_GROUP_NAMED1_XLSXW_1 XLSXW_OUT_OVERWRITE_FILE_XLSXW_1%XLSXW_OUT_TEMPLATEFILE_XLSXW_1%XLSXW_OUT_TEMPLATE_SHEET_XLSXW_1 Writer Parameters # Whether or not to overwrite the file DEFAULT_MACRO XLSXW_OUT_OVERWRITE_FILE_XLSXW_1 No XLSXW_1_OVERWRITE_FILE "$(XLSXW_OUT_OVERWRITE_FILE_XLSXW_1)" GUI ACTIVECHOICE XLSXW_OUT_OVERWRITE_FILE_XLSXW_1 Yes%No,XLSXW_OUT_TEMPLATEFILE_XLSXW_1,XLSXW_OUT_TEMPLATE_SHEET_XLSXW_1,XLSXW_OUT_+TEMPLATEFILE+ 覆盖现有文件:# Template File option DEFAULT_MACRO XLSXW_OUT_TEMPLATEFILE_XLSXW_1 GUI OPTIONAL FILENAME_MUSTEXIST XLSXW_OUT_TEMPLATEFILE_XLSXW_1 Excel_Files(*.xlsx;*.xlsm;*.xls)|*.xlsx;*.xlsm;*.xls|Excel_Workbook_2007(*.xlsx)|*.xlsx|Excel_Macro_Workbook(*.xlsm)|*.xlsm|Excel_Workbook_Pre_2007(*.xls)|*.xls|All_files(*)|* Template File: GUI LOOKUP XLSXW_OUT_TEMPLATEFILE_XLSXW_1 , DEFAULT_MACRO XLSXW_OUT_TEMPLATE_SHEET_XLSXW_1 xlsxw_1” GUI OPTIONAL DYNAMIC_SINGLE_SELECT XLSXW_OUT_TEMPLATE_SHEET_XLSXW_1 $[XLSXW_OUT_TEMPLATEFILE_XLSXW_1],_FORMAT_OVERRIDE_,XLSXR,RETRIEVE_ALL_TABLE_NAMES,Yes,IGNORE_ALL_NAMED_RANGES,Yes Template Sheet: GUI LOOKUP XLSXW_OUT_TEMPLATE_SHEET_XLSXW_1 ,#============================================================================ # Parameters whose values will be percolated to the feature types, but will not # remain as writer level settings # Default to not drop feature type first DEFAULT_MACRO XLSXW_OUT_DROP_TABLE_XLSXW_1 No XLSXW_1_DROP_TABLE "$(XLSXW_OUT_DROP_TABLE_XLSXW_1)" # Default to not truncate feature type first (removeallcelldata,retainformatting/headers,etc.) DEFAULT_MACRO XLSXW_OUT_TRUNCATE_TABLE_XLSXW_1 No XLSXW_1_TRUNCATE_TABLE "$(XLSXW_OUT_TRUNCATE_TABLE_XLSXW_1)" # Maintain compatibility with lenient attrName.* matching DEFAULT_MACRO XLSXW_OUT_STRICT_SCHEMA_ADDITIONAL_ATTRIBUTE_MATCHING_XLSXW_1 yes XLSXW_1_STRICT_SCHEMA_ADDITIONAL_ATTRIBUTE_MATCHING "$(XLSXW_OUT_STRICT_SCHEMA_ADDITIONAL_ATTRIBUTE_MATCHING_XLSXW_1)" # Default to write out the field names DEFAULT_MACRO XLSXW_OUT_FIELD_NAMES_OUT_XLSXW_1 Yes XLSXW_1_FIELD_NAMES_OUT "$(XLSXW_OUT_FIELD_NAMES_OUT_XLSXW_1)" # Default writer mode DEFAULT_MACRO XLSXW_OUT_WRITER_MODE_XLSXW_1 Insert XLSXW_1_WRITER_MODE "$(XLSXW_OUT_WRITER_MODE_XLSXW_1)" # Default raster writing type DEFAULT_MACRO XLSXW_OUT_RASTER_FORMAT_XLSXW_1 PNG XLSXW_1_RASTER_FORMAT "$(XLSXW_OUT_RASTER_FORMAT_XLSXW_1)" # ============================================================================ # Choose excel file protection mode DEFAULT_MACRO XLSXW_OUT_PROTECT_SHEET_XLSXW_1 NO XLSXW_1_PROTECT_SHEET "$(XLSXW_OUT_PROTECT_SHEET_XLSXW_1)" # Whether or not to enable sheet password protection DEFAULT_MACRO XLSXW_OUT_PROTECT_SHEET_PASSWORD_XLSXW_1 XLSXW_1_PROTECT_SHEET_PASSWORD “$(XLSXW_OUT_PROTECT_SHEET_PASSWORD_XLSXW_1)” #哪一种保护级别DEFAULT_MACRO XLSXW_OUT_PROTECT_SHEET_LEVEL_XLSXW_1 XLSXW_1_PROTECT_SHEET_LEVEL“$(XLSXW_OUT_PROTECT_SHEET_LEVEL_XLSXW_1)”#哪种特定的权限将被启用DEFAULT_MACRO XLSXW_OUT_PROTECT_SHEET_PERMISSIONS_XLSXW_1 XLSXW_1_PROTECT_SHEET_PERMISSIONS " $ (XLSXW_OUT_PROTECT_SHEET_PERMISSIONS_XLSXW_1) " # ============================================================================ # Opt in for destination dataset type vs format type validation DEFAULT_MACRO XLSXW_OUT_DESTINATION_DATASETTYPE_VALIDATION_XLSXW_1 Yes XLSXW_1_DESTINATION_DATASETTYPE_VALIDATION "$(XLSXW_OUT_DESTINATION_DATASETTYPE_VALIDATION_XLSXW_1)" DEFAULT_MACRO XLSXW_OUT_COORDINATE_SYSTEM_GRANULARITY_XLSXW_1 FEATURE XLSXW_1_COORDINATE_SYSTEM_GRANULARITY "$(XLSXW_OUT_COORDINATE_SYSTEM_GRANULARITY_XLSXW_1)" # ============================================================================ XLSXW_1_GENERATE_FME_BUILD_NUM 19246 XLSXW_1_DATASET "$(DestDataset_XLSXW_1)" #!END_DEST_HEADER # !START_WB_HEADER # !END_WB_HEADER # !END_HEADER LOG_FILENAME”(FME_MF_DIR) ExcelUpdates美元。log" LOG_APPEND NO LOG_TIMINGS YES LOG_FILTER_MASK -1 LOG_MAX_FEATURES 200 LOG_MAX_RECORDED_FEATURES 200 FME_REPROJECTION_ENGINE FME FME_IMPLICIT_CSMAP_REPROJECTION_MODE Auto FME_GEOMETRY_HANDLING Enhanced FME_STROKE_MAX_DEVIATION 0 DEFAULT_MACRO DATASET_KEYWORD_XLSXW_1 XLSXW_1 # ------------------------------------------------------------------------- MULTI_READER_CONTINUE_ON_READER_FAILURE No # ------------------------------------------------------------------------- MACRO WORKSPACE_NAME ExcelUpdates MACRO FME_VIEWER_APP fmedatainspector DEFAULT_MACRO WB_CURRENT_CONTEXT # ------------------------------------------------------------------------- Tcl2 proc Creator_CoordSysRemover {} { global FME_CoordSys;设置FME_CoordSys {};宏创建器_classic NOT_ACTIVATED宏创建器_2d3d 2D_GEOMETRY宏创建器_coords {{几何对象}=={几何对象}}{放置{宏Creator_XML *}}}{宏Creator_CLASSIC *}}包括[if{{几何对象}== {3D坐标列表}}{宏Creator_2D3D 3D_GEOMETRY};{set comment {We need to turn the COORDS which are minX minY maxX maxY into a full polygon list of coordinates} {{Geometry Object} == {2D Min/Max Box}} {set comment {We need to turn the COORDS which are minX minY maxX maxY into a full polygon list of coordinates};设置splitcods [split]字符串修剪{ }]];如果{[llength $ splitcods] > 4} {set trimmedCoords {};如果{$item != {}} {lappend trimmedCoords $item}};设置splitCoords trimmedCoords美元;};如果{[llength $splitCoords] != 4} {error {Creator: Coordinate list is expected to be a space delimited list of four numbers as 'minx miny maxx maxy' - ' 的是无效的};};设置minX [lindex $splitCoords 0];set minY [lindex $splitCoords 1];设置maxX [lindex $splitCoords 2];设置maxY [lindex $splitCoords 3];放“宏创建器_coords $minX $minY $minX $maxY $maxX $maxY $maxX $minY $minX $minY”;放置{宏Creator_2D3D 2D_GEOMETRY};Creator_XML_Creator CREATE_AT_END无输出 xml ? version = 1.0 编码= US_ASCII 独立的= 没有 吗? 几何 尺寸= 2 几何 )FACTORY_DEF $ (Creator_CLASSIC) CreationFactory FACTORY_NAME Creator_CLASSIC_Creator (Creator_2D3D) (Creator_COORDS) CREATE_AT_END没有美元输出FEATURE_TYPE _____CREATED______ FACTORY_DEF * TeeFactory FACTORY_NAME Creator_Cloner输入FEATURE_TYPE _____CREATED______ @Tcl2 (Creator_CoordSysRemover) @CoordSys () NUMBER_OF_COPIES 1 COPY_NUMBER_ATTRIBUTE“_creation_instance”输出FEATURE_TYPE Creator_CREATED fme_feature_type创造者FACTORY_DEF * TeeFactory FACTORY_NAME“造物主创造了分流”输入FEATURE_TYPE Creator_CREATED输出FEATURE_TYPE Creator_CREATED_0_GJAgmIF9G6c =输出FEATURE_TYPE Creator_CREATED_1_Exx7idfjvCA = FACTORY_DEF * BranchingFactory FACTORY_NAME“Creator_CREATED_0_GJAgmIF9G6c =布兰凯尔1 4”输入FEATURE_TYPE Creator_CREATED_0_GJAgmIF9G6c = TARGET_FACTORY " $ (WB_CURRENT_CONTEXT) _CREATOR_BRANCH_TARGET“MAXIMUM_COUNT没有输出通过FEATURE_TYPE * FACTORY_DEF * BranchingFactory FACTORY_NAME输入FEATURE_TYPE Creator_CREATED_1_Exx7idfjvCA =布兰凯尔1 6Creator_CREATED_1_Exx7idfjvCA= TARGET_FACTORY "$(WB_CURRENT_CONTEXT)_CREATOR_BRANCH_TARGET" MAXIMUM_COUNT None OUTPUT PASSED FEATURE_TYPE * # ------------------------------------------------------------------------- FACTORY_DEF * TeeFactory FACTORY_NAME "$(WB_CURRENT_CONTEXT)_CREATOR_BRANCH_TARGET" INPUT FEATURE_TYPE * OUTPUT FEATURE_TYPE * # ------------------------------------------------------------------------- FACTORY_DEF * TeeFactory FACTORY_NAME "AttributeCreator_2 (Disabled) Nuker" INPUT FEATURE_TYPE Creator_CREATED_1_Exx7idfjvCA= # ------------------------------------------------------------------------- FACTORY_DEF {*} AttrSetFactory FACTORY_NAME AttributeCreator COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE Creator_CREATED_0_GJAgmIF9G6c= MULTI_FEATURE_MODE NO NULL_ATTR_MODE NO_OP ATTRSET_CREATE_DIRECTIVES _PROPAGATE_MISSING_FDIV ATTR_ACTION { "" "ID" "SET_TO" "GW01" } ATTR_ACTION { "" "Rural" "SET_TO" "2093" } ATTR_ACTION { "" "Urban" "SET_TO" "200" } ATTR_ACTION { "" "Water" "SET_TO" "98" } OUTPUT OUTPUT FEATURE_TYPE AttributeCreator_OUTPUT # ------------------------------------------------------------------------- FACTORY_DEF * RoutingFactory FACTORY_NAME "Destination Feature Type Routing Correlator" COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE * ROUTE FME_GENERIC AttributeCreator_OUTPUT TO XLSXW __GO_TO_FINAL_OUTPUT_ROUTER__ multi_writer_id,0, SupplyAttributes 编码 __wb_out_feat_type__ 集水 将FME_GENERIC AttributeCreator_2_OUTPUT路由到XLSXW的_go_to_final_output_router__ multi_writer_id,0, SupplyAttributes 编码 __wb_out_feat_type__ 集水 几何FEATURE_TYPE_ATTRIBUTE __wb_out_feat_type__输出路由FEATURE_TYPE *输出NOT_ROUTED FEATURE_TYPE __nuke_me__ @Tcl2 (“FME_StatMessage 818059 [FME_GetAttribute fme_template_feature_type) 818060 818061 fme_warn”) # - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - FACTORY_DEF * TeeFactory FACTORY_NAME“最终输出核武器”输入FEATURE_TYPE __nuke_me__ # - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - XLSXW_1_DEF排水xlsx_drop_sheet没有xlsx_trunc_sheet xlsx_sheet_order”“xlsx_freeze_end_row”“xlsx_names_are_positions不xlsx_field_names_out是的xlsx_start_col”“xlsx_start_row”“xlsx_offset_col”“xlsx_offset_row”“xlsx_raster_type PNG xlsx_table_writer_mode插入xlsx_row_id_column”“xlsx_protect_sheet xlsx_protect_sheet_level xlsx_protect_sheet_password xlsx_protect_sheet_permissions ID字符串(20日版本 1 number_format_string 字体 font_color background_color pattern_color pattern_style CELL_BORDER_FORMATTING 没有 CELL_BORDER_COLOR CELL_BORDER_STYLE text_alignment 没有 horizontal_alignment vertical_alignment 缩进 text_orientation text_control cell_protection 没有 hide_cells lock_cells )农村数量(20日版本 1 number_format_string 字体 font_color background_color pattern_color pattern_style CELL_BORDER_FORMATTING 没有 CELL_BORDER_COLOR CELL_BORDER_STYLE text_alignment 没有 horizontal_alignment vertical_alignment 缩进 text_orientation text_control cell_protection 没有 hide_cells lock_cells )城市编号(20,版本 1 number_format_string 字体 font_color background_color pattern_color pattern_style CELL_BORDER_FORMATTING 没有 CELL_BORDER_COLOR CELL_BORDER_STYLE text_alignment 没有 horizontal_alignment vertical_alignment 缩进 text_orientation text_control cell_protection 没有 hide_cells lock_cells )水号(20,版本 1 number_format_string 字体 font_color background_color pattern_color pattern_style CELL_BORDER_FORMATTING 没有 CELL_BORDER_COLOR CELL_BORDER_STYLE text_alignment 没有 horizontal_alignment vertical_alignment 缩进 text_orientation text_control cell_protection 没有 hide_cells lock_cells )