＃！＃！ ＃！ ＃！ ＃！＃！＃！＃！＃！＃！" xlsx_protect_sheet_password "" xlsx_protect_sheet_permissions """ defline_attrs="true" exposable_attrs="fme_fill_color string(50) fme_secondary_axis number(width,xlsx_col_props) fme_geometry string(50) xlsx_row_id number(width,xlsx_col_props) fme_primary_axis number(width,xlsx_col_props) fme_text_size number(width,xlsx_col_props) xlsx_raster_height number(width,xlsx_col_props) xlsx_row_formatting string(width,xlsx_col_props) fme_db_operation string(width,xlsx_col_props) fme_type string(50) xlsx_raster_width number(width,xlsx_col_props) xlsx_col_id number(width,xlsx_col_props) fme_sweep_angle number(width,xlsx_col_props) fme_color string(50) fme_rotation number(width,xlsx_col_props) fme_start_angle number(width,xlsx_col_props) fme_basename string(50) fme_text_string string(50) fme_feature_type string(50) xlsx_raster_scale_factor number(width,xlsx_col_props) fme_dataset 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 Sheet Settings" "" "GUI OPTIONAL DISCLOSUREGROUP xlsx_truncate_group xlsx_row_id%xlsx_drop_sheet%xlsx_trunc_sheet Drop/Truncate" "" "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 SelectOnlyPermissions,PROT_DEFAULT,xlsx_protect_sheet_permissions%ViewOnlyPermissions,PROT_ALL,xlsx_protect_sheet_permissions%SpecificPermissions Protection Level:" "GUI OPTIONAL LOOKUP_LISTBOX xlsx_protect_sheet_permissions Selectlockedcells,PROT_SEL_LOCKED_CELLS%Selectunlockedcells,PROT_SEL_UNLOCKED_CELLS%Formatcells,PROT_FORMAT_CELLS%Formatcolumns,PROT_FORMAT_COLUMNS%Formatrows,PROT_FORMAT_ROWS%Insertcolumns,PROT_INSERT_COLUMNS%Insertrows,PROT_INSERT_ROWS%Addhyperlinkstounlockedcells,PROT_INSERT_HYPERLINKS%Deleteunlockedcolumns,PROT_DELETE_COLUMNS%Deleteunlockedrows,PROT_DELETE_ROWS%Sortunlockedcells/rows/columns\,PROT_SORT%UseAutofilteronunlockedcells,PROT_AUTOFILTER%UsePivotTable&PivotChartonunlockedcells,PROT_PIVOTTABLES%Editunlockedobjects,PROT_OBJECTS%Editunprotectedscenarios,PROT_SCENARIOS Specific Permissions:" "GUI ACTIVECHOICE xlsx_table_writer_mode Insert,+xlsx_row_id_column+%Update,+xlsx_row_id_column+xlsx_row_id%Delete,+xlsx_row_id_column+xlsx_row_id Writer Mode:" Insert "GUI OPTIONAL ATTR xlsx_row_id_column ALLOW_NEW Row Number Attribute:" "" " attr_index_types="" attr_name_invalid_chars="\\"*{}$" supports_feature_type_fanout="true" enabled="true" dynamic_feature_types_list_on_merge="true" dataset_type="FILE" generate_fme_build_num="19199" coordsys="" fanout_expression="" fanout_group="NO"> ＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！ ＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！ ＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！ ＃！ ＃！＃！＃！＃！＃！＃！＃！＃！＃！ ＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！ ＃！＃！＃！＃！＃！＃！＃！＃！＃！ ＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！ ＃！＃！＃！＃！＃！＃！＃！＃！＃！ ＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！ ＃！＃！＃！＃！＃！＃！＃！＃！＃！ ＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！ ＃！ ＃！＃！＃！ ＃！＃！＃！＃！ ＃！＃！＃！＃！ ＃！

remove <space> from connection string

" POSITION="3415.6591565915655 -616.63015630156292" TOP_LEFT="3415.6591565915655 -616.63015630156292" BOTTOM_RIGHT="3937.6841568415689 -759.13128131281303" BOUNDING_RECT="3415.6591565915655 -616.63015630156292 522.02500025000336 142.50112501125011" ORDER="500000000000058" FOLLOW_ANCHOR="true" INFO_NODE="false" COLOUR="1,1,0.95686274509803926,0.78431372549019607" SIZE_POLICY="10" ANCHORED_NODE="0">＃！＃！ ＃！＃！ ＃！＃！ ＃！ ＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！atValueopenparenreader_parameter_namecloseparenCONTAINSDATASET_TYPECASE_INSENSITIVE_TESTatValueopenparenreader_parameter_valuecloseparenCONTAINSDATABASE",database">＃！＃！＃！＃！ ＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！Valuereader_type object SET_TO Valuefme_feature_type connection_name SET_TO Valuesource_dataset workspace SET_TO Valuefme_basename">＃！＃！＃！＃！＃！＃！＃！＃！＃！ ＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！atValueopenparentransformer_typecloseparenCONTAINSSQLCreatorCASE_INSENSITIVE_TESTatValueopenparentransformer_typecloseparenCONTAINSSQLExecutorCASE_INSENSITIVE_TESTatValueopenparentransformer_typecloseparenCONTAINSDatabaseJoinerCASE_INSENSITIVE_TESTatValueopenparentransformer_typecloseparen=JoinerCASE_INSENSITIVE_TESTatValueopenparentransformer_typecloseparenCONTAINSFeatureReaderCASE_INSENSITIVE_TESTatValueopenparentransformer_typecloseparenCONTAINSFeatureWriter",database">＃！＃！＃！＃！ ＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！atValueopenparentransformer_parameter_namecloseparenCONTAINSDATASET",database,"BOOL_OP,OR,COMPOSITE_TEST,""""""1"""""",TEST_CLAUSE,CASE_INSENSITIVE_TESTatValueopenparentransformer_parameter_namecloseparen=FORMAT",format">＃！＃！＃！＃！ ＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！Valuetransformer_type workspace SET_TO Valuefme_basename">＃！＃！＃！＃！＃！＃！＃！＃！＃！ ＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！Valuetransformer_parameter_value">＃！＃！＃！＃！＃！＃！＃！＃！＃！ ＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！Valuetransformer_parameter_value">＃！＃！＃！＃！＃！＃！＃！＃！＃！ ＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！ ＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！ ＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！atValueopenparenwriter_parameter_namecloseparenCONTAINSDATASET_TYPECASE_INSENSITIVE_TESTatValueopenparenwriter_parameter_valuecloseparenCONTAINSDATABASE",database">＃！＃！＃！＃！ ＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！Valuewriter_type object SET_TO Valuefme_feature_type connection_name SET_TO Valuedestination_dataset workspace SET_TO Valuefme_basename">＃！＃！＃！＃！＃！＃！＃！＃！＃！ ＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！ ＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！ ＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！ ＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！＃！ ＃！＃！ ＃！＃！ ＃！＃！ ＃！＃！FME_PYTHON_VERSION 37 GUI忽略SourceDataset_FMW_1 FMW_IN_NETWORK_AUTHENTICATION_FMW_1、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 SourceDataset_FMW \ \ fs2 \ pserv \ AT&T移动\ SupportWebinars \ \项目研讨会2019.01 FME基金基本FME基础\ \:π- 1. oraclereader。逐步GUI多文件SourceDataset_FMW FME_Workspace_Files (* .fmw) | * .fmw | Zipped_Workspace_Files (* .fmwt) | * .fmwt | Compressed_Files (* bz2; * . gz) | * bz2; * . gz | Archive_Files(*解压;* .7zip; * . rar; * .rvz; * . tar; * .tar.bz2; * gz; * . tgz; * . zip; * .zipx) | *解压;* .7zip; * . rar; * .rvz; * . tar; * .tar.bz2; * gz; * . tgz; * . zip; * .zipx | All_files (*) | * FME工作区(逐步)文件来源::DEFAULT_MACRO DestDataset_XLSXW $ (FME_MF_DIR) DatabaseConnectionFiles.xlsx GUI文件名DestDataset_XLSXW Excel_Files (* .xlsx; * .xlsm; * xls) | * .xlsx; * .xlsm; * xls | All_files(*) | *目的地Microsoft Excel文件:包括(如果{{$ (SourceDataset_FMW )} == {}} { puts_real{参数“SourceDataset_FMW”必须有一个值。};退出1;};INCLUDE [if {{$(DestDataset_XLSXW)} == {}} {puts_real {Parameter 'DestDataset_XLSXW'必须指定一个值};退出1;};) # ! START_HEADER #! START_WB_HEADER READER_TYPE MULTI_READER MULTI_READER_TYPE{0} FMW MULTI_READER_KEYWORD{0} FMW_1 MULTI_READER_GEN_DIRECTIVES{0} _MERGE_SCHEMAS,YES 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 #! START_WB_HEADER MACRO WB_KEYWORD "FMW_1" #! END_WB_HEADER #! START_SOURCE_HEADER FMW FMW_1 # ===================================================================== # The following GUI line prompts for a file to be used as the source # FMW file. The user input is stored in a macro, which is then # used to define the dataset to be read. # The dataset this mapping file was generated from was: #! END_SOURCE_HEADER #! START_WB_HEADER DEFAULT_MACRO SourceDataset INCLUDE [ if {{$(SourceDataset)} != ""} { \ puts {DEFAULT_MACRO SourceDataset_FMW_1 $(SourceDataset)} \ } ] #! END_WB_HEADER #! START_SOURCE_HEADER FMW FMW_1 DEFAULT_MACRO SourceDataset_FMW_1 $(SourceDataset_FMW) GUI MULTIFILE SourceDataset_FMW_1 FME_Workspace_Files(*.fmw)|*.fmw|Zipped_Workspace_Files(*.fmwt)|*.fmwt|All_files(*)|* Source FME Workspace (FMW) File : DEFAULT_MACRO _USE_UNIQUE_IDS_FMW_1 yes FMW_1_USE_UNIQUE_IDS $(_USE_UNIQUE_IDS_FMW_1) DEFAULT_MACRO FMW_IN_USE_UNIQUE_IDS_FMW_1 yes FMW_1_USE_UNIQUE_IDS "$(FMW_IN_USE_UNIQUE_IDS_FMW_1)" # =========================================================================== DEFAULT_MACRO FMW_IN_NETWORK_AUTHENTICATION_FMW_1 FMW_1_NETWORK_AUTHENTICATION "$(FMW_IN_NETWORK_AUTHENTICATION_FMW_1)" GUI OPTIONAL AUTHENTICATOR FMW_IN_NETWORK_AUTHENTICATION_FMW_1 CONTAINER%GROUP%CONTAINER_TITLE%"Network Authentication"%PROMPT_TYPE%NETWORK Network Authentication # ============================================================================ DEFAULT_MACRO FMW_IN_ATTRIBUTE_READING_FMW_1 ALL FMW_1_ATTRIBUTE_READING "$(FMW_IN_ATTRIBUTE_READING_FMW_1)" # ============================================================================ FMW_1_GENERATE_FME_BUILD_NUM 19199 FMW_1_DATASET "$(SourceDataset_FMW_1)" #! END_SOURCE_HEADER #! START_WB_HEADER MACRO WB_KEYWORD "XLSXW_1" #! END_WB_HEADER #! START_DEST_HEADER XLSXW XLSXW_1 # ============================================================================ # First get the dataset for the database. For Excel, it's the file name. # For now we'll use whatever they had when they generated this mapping file, # and not reprompt #! END_DEST_HEADER #! START_WB_HEADER DEFAULT_MACRO DestDataset INCLUDE [ if {"$(DestDataset)" != ""} { \ puts {DEFAULT_MACRO DestDataset_XLSXW_1 $(DestDataset)} \ } ] #! END_WB_HEADER #! START_DEST_HEADER XLSXW XLSXW_1 DEFAULT_MACRO DestDataset_XLSXW_1 $(DestDataset_XLSXW) GUI FILENAME DestDataset_XLSXW_1 Excel_Files(*.xlsx;*.xlsm;*.xls)|*.xlsx;*.xlsm;*.xls|All_files(*)|* Destination Microsoft Excel File: # ============================================================================ DEFAULT_MACRO XLSXW_OUT_FME_GROUP_NAMED1_XLSXW_1 FME_DISCLOSURE_OPEN 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 Yes 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+ 覆盖现有文件：＃模板文件选项DEFAULT_MACRO XLSXW_OUT_TEMPLATEFILE_XLSXW_1 XLSXW_1_TEMPLATEFILE “$（XLSXW_OUT_TEMPLATEFILE_XLSXW_1）” GUI可选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（*）| *模板文件：gui查找xlsxw_out_templatefile_xlsxw_1 ，DEFAULT_MACRO XLSXW_OUT_TEMPLATE_SHEET_XLSXW_1 XLSXW_1_TEMPLATE_SHEET “$（XLSXW_OUT_TEMPLATE_SHEET_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，是模板表：GUI LOOKUP XLSXW_OUT_TEMPLATE_SHEET_XLSXW_1 , # ============================================================================ # 参数的值将会牵扯到功能类型,但不会像作家级别设置# #保持默认不放的功能类型第一DEFAULT_MACRO XLSXW_OUT_DROP_TABLE_XLSXW_1没有XLSXW_1_DROP_TABLE " $ (XLSXW_OUT_DROP_TABLE_XLSXW_1) "#默认不截断特性类型(removeallcelldata,retainformatting/headers等)DEFAULT_MACRO XLSXW_OUT_TRUNCATE_TABLE_XLSXW_1 No XLSXW_1_TRUNCATE_TABLE "$(XLSXW_OUT_TRUNCATE_TABLE_XLSXW_1)"#保持与宽松的attrName的兼容性。XLSXW_OUT_STRICT_SCHEMA_ADDITIONAL_ATTRIBUTE_MATCHING_XLSXW_1 yes xlsxw_1_strict_schema_additional_attribute_matching_xlsxw_1 "$(XLSXW_OUT_STRICT_SCHEMA_ADDITIONAL_ATTRIBUTE_MATCHING_XLSXW_1)"#默认输出字段名DEFAULT_MACRO XLSXW_OUT_FIELD_NAMES_OUT_XLSXW_1 Yes XLSXW_1_FIELD_NAMES_OUT "$(XLSXW_OUT_FIELD_NAMES_OUT_XLSXW_1)"#默认写入模式DEFAULT_MACRO XLSXW_OUT_WRITER_MODE_XLSXW_1插入XLSXW_1_WRITER_MODE "$(XLSXW_OUT_WRITER_MODE_XLSXW_1)"#默认光栅写入类型DEFAULT_MACRO XLSXW_OUT_RASTER_FORMAT_XLSXW_1 PNG XLSXW_1_RASTER_FORMAT "$(XLSXW_OUT_RASTER_FORMAT_XLSXW_1)"# ============================================================================ # 没有选择excel文件保护模式DEFAULT_MACRO XLSXW_OUT_PROTECT_SHEET_XLSXW_1 XLSXW_1_PROTECT_SHEET " $ (XLSXW_OUT_PROTECT_SHEET_XLSXW_1) "#是否启用表密码保护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）” ＃============================================================================＃在目标数据集中型VS格式类型验证DEFAULT_MACRO XLSXW_OUT_DESTINATION_DATASETTYPE_VALIDATION_XLSXW_1是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 19199 XLSXW_1_DATASET“$（DestDataset_XLSXW_1）“＃！END_DEST_HEADER # !start_wb_header＃！END_WB_HEADER # !END_HEADER LOG_FILENAME “$（FME_MF_DIR）DatabaseConnectionNames.log” LOG_APPEND NO LOG_FILTER_MASK -1 LOG_MAX_FEATURES 200个LOG_MAX_RECORDED_FEATURES 200 FME_REPROJECTION_ENGINE FME FME_IMPLICIT_CSMAP_REPROJECTION_MODE自动FME_GEOMETRY_HANDLING增强FME_STROKE_MAX_DEVIATION 0 DEFAULT_MACRO DATASET_KEYWORD_FMW_1 FMW_1 DEFAULT_MACRO DATASET_KEYWORD_XLSXW_1 XLSXW_1＃------------------------------------------------------------------------- FMW_1_READER_META_ATTRIBUTES fme_feature_type fme_basename fme_dataset＃------------------------------------------------------------------------- MULTI_READER_CONTINUE_ON_READER_FAILURE无＃------------------------------------------------------------------------- MACRO WORKSPACE_NAME DatabaseConnectionNames MACRO FME_VIEWER_APP fmedatainspector＃------------------------------------------------------------------------- FACTORY_DEF * RoutingFactory FACTORY_NAME“路由器和意外输入卸妆” COMMAND_PARM_EVALUATION SINGLE_PASS MULTI_READER_KEYWORD $(DATASET_KEYWORD_FMW_1) INPUT FEATURE_TYPE * ROUTE FMW FMW_1::WriterParameters multi_reader_keyword,$(DATASET_KEYWORD_FMW_1) TO FME_GENERIC ::WriterParameters ALIAS_GEOMETRY ROUTE FMW FMW_1::Readers multi_reader_keyword,$(DATASET_KEYWORD_FMW_1) TO FME_GENERIC ::Readers ALIAS_GEOMETRY ROUTE FMW FMW_1::TransformerParameters multi_reader_keyword,$(DATASET_KEYWORD_FMW_1) TO FME_GENERIC ::TransformerParameters ALIAS_GEOMETRY ROUTE FMW FMW_1::Writers multi_reader_keyword,$(DATASET_KEYWORD_FMW_1) TO FME_GENERIC ::Writers ALIAS_GEOMETRY ROUTE FMW FMW_1::Transformers multi_reader_keyword,$(DATASET_KEYWORD_FMW_1) TO FME_GENERIC ::Transformers ALIAS_GEOMETRY ROUTE FMW FMW_1::PublishedParameters multi_reader_keyword,$(DATASET_KEYWORD_FMW_1) TO FME_GENERIC ::PublishedParameters ALIAS_GEOMETRY ROUTE FMW FMW_1::ReaderParameters multi_reader_keyword,$(DATASET_KEYWORD_FMW_1) TO FME_GENERIC ::ReaderParameters ALIAS_GEOMETRY MERGE_INPUT Yes OUTPUT ROUTED FEATURE_TYPE * FMW_1_MERGE_DEF FMW_1::WriterParameters EXACT WriterParameters FMW_1_MERGE_DEF FMW_1::Readers EXACT Readers FMW_1_MERGE_DEF FMW_1::TransformerParameters EXACT TransformerParameters FMW_1_MERGE_DEF FMW_1::Writers EXACT Writers FMW_1_MERGE_DEF FMW_1::Transformers EXACT Transformers FMW_1_MERGE_DEF FMW_1::PublishedParameters EXACT PublishedParameters FMW_1_MERGE_DEF FMW_1::ReaderParameters EXACT ReaderParameters # ------------------------------------------------------------------------- FACTORY_DEF * TeeFactory FACTORY_NAME "PublishedParameters (FMW_1) Splitter" INPUT FEATURE_TYPE PublishedParameters # ------------------------------------------------------------------------- FACTORY_DEF * TeeFactory FACTORY_NAME "Readers (FMW_1) Splitter" INPUT FEATURE_TYPE Readers OUTPUT FEATURE_TYPE Readers_FMW_1 # ------------------------------------------------------------------------- FACTORY_DEF * TeeFactory FACTORY_NAME "ReaderParameters (FMW_1) Splitter" INPUT FEATURE_TYPE ReaderParameters OUTPUT FEATURE_TYPE ReaderParameters_FMW_1 # ------------------------------------------------------------------------- FACTORY_DEF * TeeFactory FACTORY_NAME "Writers (FMW_1) Splitter" INPUT FEATURE_TYPE Writers OUTPUT FEATURE_TYPE Writers_FMW_1 # ------------------------------------------------------------------------- FACTORY_DEF * TeeFactory FACTORY_NAME "WriterParameters (FMW_1) Splitter" INPUT FEATURE_TYPE WriterParameters OUTPUT FEATURE_TYPE WriterParameters_FMW_1 # ------------------------------------------------------------------------- FACTORY_DEF * TeeFactory FACTORY_NAME "Transformers (FMW_1) Splitter" INPUT FEATURE_TYPE Transformers OUTPUT FEATURE_TYPE Transformers_FMW_1 # ------------------------------------------------------------------------- FACTORY_DEF * TeeFactory FACTORY_NAME "TransformerParameters (FMW_1) Splitter" INPUT FEATURE_TYPE TransformerParameters OUTPUT FEATURE_TYPE TransformerParameters_FMW_1 DEFAULT_MACRO WB_CURRENT_CONTEXT # ------------------------------------------------------------------------- FACTORY_DEF * TeeFactory FACTORY_NAME TestFilter_3 INPUT FEATURE_TYPE TransformerParameters_FMW_1 OUTPUT FEATURE_TYPE TestFilter_3_TESTFILTERINPUTLINE_0 FACTORY_DEF * TestFactory FACTORY_NAME TestFilter_3_Condition_1 INPUT FEATURE_TYPE TestFilter_3_TESTFILTERINPUTLINE_0 CASE_INSENSITIVE_TEST @EvaluateExpression(FDIV,STRING_ENCODED, 价值 Transformer_Parameter_Name. ，TestFilter_3）包含DATASET ENCODED BOOLEAN_OPERATOR OR COMPOSITE_TEST_EXPR “1” OUTPUT PASSED FEATURE_TYPE TestFilter_3_database OUTPUT FAILED FEATURE_TYPE TestFilter_3_TESTFILTERINPUTLINE_1 FACTORY_DEF * TestFactory中FACTORY_NAME TestFilter_3_Condition_2 INPUT FEATURE_TYPE TestFilter_3_TESTFILTERINPUTLINE_1 CASE_INSENSITIVE_TEST @EvaluateExpression（FDIV，STRING_ENCODED， 价值 Transformer_Parameter_Name. ，testfilter_3）=格式编码boolean_operator或composite_test_expr“1”输出传递feature_type testfilter_3_format输出失败feature_type testfilter_3_testfilterinputline_2 factory_def * teefactory factory_name testfilter_3_ unf 输入feature_type testfilter_3_testfilterInputLine_2输出Feature_type testfilter_3_ unf factory_def * teefactory factory_name“testfilter_3 unf 变压器输出Nuker" INPUT FEATURE_TYPE TestFilter_3_ unf ＃---------------------------------------------------------------------------------------------设置” ” 价值 Transformer_Parameter_Value. “}输出输出Feature_type attributecreator_5_output＃------------------------------------------------------------ Factory_def {*} attrsetfactor_4 command_parm_evalization single_past _dent_parm_evalization single_past _ttepe testfilter_3_database multi_feature_mode no_opatts_create_directives _propagate_missing_fdiv att_action {“”connection_name“”set_to“” 价值 Transformer_Parameter_Value. “}输出输出FEATURE_TYPE AttributeCreator_4_OUTPUT＃------------------------------------------------------------------------- FACTORY_DEF {*} FeatureJoinerFactory FACTORY_NAME FeatureJoiner_2 INPUT LEFT FEATURE_TYPE AttributeCreator_4_OUTPUT INPUT RIGHT FEATURE_TYPE AttributeCreator_5_OUTPUT JOIN_MODE内JOIN_KEYS transformer_id transformer_idAUTO workspace_id workspace_id AUTO ATTR_CONFLICT_RES输出JOINED FEATURE_TYPE FeatureJoiner_2_JOINED输出USE_LEFT GEOMETRY_HANDLING USE_LEFT feature_type featurejoiner_2_ default_macro _wb_bypass_termination no factory_def * teefactory factory_name featurejoiner_2_ 输入feature_type featurejoiner_2_ 输出失败FEATURE_TYPE * @Abort(ENCODED, FeatureJoiner_2 输出 一种 拒绝了 特征。 到 继续 翻译 什么时候 特征 是 拒绝了 改变 工作空间 参数 翻译 拒绝了 特征 处理 到 继续 翻译 ) # ------------------------------------------------------------------------- FACTORY_DEF * tefactory FACTORY_NAME TestFilter_2 INPUT FEATURE_TYPE Transformers_FMW_1 OUTPUT FEATURE_TYPE TestFilter_2_TESTFILTERINPUTLINE_0 FACTORY_DEF * TestFactory FACTORY_NAME TestFilter_2_TESTFILTERINPUTLINE_0CASE_INSENSITIVE_TEST @EvaluateExpression (FDIV STRING_ENCODED, 价值 Transformer_type. ，TestFilter_2）包含SQLCreator ENCODED CASE_INSENSITIVE_TEST @EvaluateExpression（FDIV，STRING_ENCODED， 价值 Transformer_type. ，TestFilter_2）包含SQLExecutor ENCODED CASE_INSENSITIVE_TEST @EvaluateExpression（FDIV，STRING_ENCODED， 价值 Transformer_type. ，testfilter_2）包含databasejoiner编码的case_insive_test @evaluateExpression（FDIV，String_Encoded， 价值 Transformer_type. ，TestFilter_2）=木ENCODED CASE_INSENSITIVE_TEST @EvaluateExpression（FDIV，STRING_ENCODED， 价值 Transformer_type. TestFilter_2) CONTAINS featuereader ENCODED CASE_INSENSITIVE_TEST @EvaluateExpression(FDIV,STRING_ENCODED， 价值 Transformer_type. ，testfilter_2）包含featherwriter编码的boolean_operator或composite_test_expr“1或2或3或4或6”输出传递Feature_type testfilter_2_database输出失败Feature_type testfilter_2_testfilterInputLine_1 factory_def * teefactory factory_name testfilter_2_ unf 输入feature_type testfilter_2_testfilterInputLine_1输出功能_type testfilter_2_ unf factory_def * teefactory factory_name“testfilter_2 unf 变压器输出NUKER“输入FEATURE_TYPE TESTFILTER_2_ unf # ------------------------------------------------------------------------- FACTORY_DEF {*} AttrSetFactory FACTORY_NAME AttributeCreator_3 COMMAND_PARM_EVALUATION SINGLE_PASS输入FEATURE_TYPE TestFilter_2_database MULTI_FEATURE_MODE没有NULL_ATTR_MODE NO_OP ATTRSET_CREATE_DIRECTIVES _PROPAGATE_MISSING_FDIV ATTR_ACTION{”“对象”“SET_TO”“ 价值 Transformer_type. “} ATTR_ACTION { ”“ ”工作区“， ”SET_TO“” 价值 fme_basename. “}输出输出Feature_type attributecreator_3_output＃------------------------------------------------------------ Factory_def {*} featurejoinerfactory factory_name featurejoiner输入leffee_type attributecreator_3_output输入leftome_type featurejoer_2_joined join_mode leving joce_keys transformer_id transformer_idAuto Workspace_id Workspace_ID自动attr_conflict_res use_left geometry_handling use_left输出加入Feature_type featurejoiner_joined输出 feature_type featurejoiner_ default_macro _wb_bypass_termination no factory_def * teefactory factory_name featurejoiner_ INPUT FEATURE_TYPE FeatureJoiner_ 输出失败feature_type * @abort（编码，featurejoiner 输出 一种 拒绝了 特征。 到 继续 翻译 什么时候 特征 是 拒绝了 改变 工作空间 参数 翻译 拒绝了 特征 处理 到 继续 翻译 ）＃----------------------------------------------------------------------string_encoded， 价值 writer_parameter_name. ，testfilter_4）包含DataSet_type Encoded Case_Insive_test @EvaluateExpression（FDIV，String_Encoded， 价值 writer_parameter_value , TestFilter_4)包含数据库编码BOOLEAN_OPERATOR和COMPOSITE_TEST_EXPR“1和2”输出通过FEATURE_TYPE TestFilter_4_database输出失败FEATURE_TYPE TestFilter_4_TESTFILTERINPUTLINE_1 FACTORY_DEF * TeeFactory FACTORY_NAME TestFilter_4_ unf 输入feature_type testfilter_4_testfilterInputLine_1输出功能_type testfilter_4_ unf factory_def * teefactory factory_name“testfilter_4 unf 变压器输出Nuker“输入Feature_type TestFilter_4_ unf ＃------------------------------------------------------------------------- FACTORY_DEF {*} AttrSetFactory FACTORY_NAME AttributeCreator_6 COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE Writers_FMW_1 MULTI_FEATURE_MODE NO NULL_ATTR_MODE NO_OP ATTRSET_CREATE_DIRECTIVES _PROPAGATE_MISSING_FDIV ATTR_ACTION { “” “格式”，“设置” ” 价值 Writer_type. “} attr_action {”“”对象“”set_to“” 价值 fme_feature_type. “} attr_action {”connection_name“”set_to“” 价值 destination_dataset “} ATTR_ACTION { ”“ ”工作区“， ”SET_TO“” 价值 fme_basename. “}输出输出Feature_type attributeCreator_6_output＃----------------------------------------------------------- Factory_def {*} featurejoinerfactory factory_name featurejoiner_4输入left feature_type attributecreator_6_output输入light feature_type testfilter_4_database join_mode inner join_keys writer_id writer_idAuto Workspace_id Workspace_ID自动attr_conflict_res uder_left geometry_handling use_left输出加入Feature_type featurejoiner_4_joined输出 FEATURE_TYPE FeatureJoiner_4_ default_macro _wb_bypass_termination no factory_def * teefactory factory_name featurejoiner_4_ INPUT FEATURE_TYPE FeatureJoiner_4_ 输出失败feature_type * @abort（编码，featurejoiner_4 输出 一种 拒绝了 特征。 到 继续 翻译 什么时候 特征 是 拒绝了 改变 工作空间 参数 翻译 拒绝了 特征 处理 到 继续 翻译 ）＃-----------------------------------------------------------------------string_encoded， 价值 reader_parameter_name ，TestFilter）包含DATASET_TYPE ENCODED CASE_INSENSITIVE_TEST @EvaluateExpression（FDIV，STRING_ENCODED， 价值 reader_parameter_value. ，testfilter）包含数据库编码的boolean_operator和composite_test_expr“1和2”输出传递Feature_type testfilter_database输出失败Feature_type testfilter_testfilterInputLine_1 factory_def * teefactory factory_name testfilter_ unf 输入feature_type testfilter_testfilterInputLine_1输出功能_type testfilter_ unf FACTORY_DEF * TeeFactory FACTORY_NAME“TestFilter unf 变压器输出Nuker" INPUT FEATURE_TYPE TestFilter_ unf ＃--------------------------------------------------------------------------设置” ” 价值 reader_type. “} attr_action {”“”对象“”set_to“” 价值 fme_feature_type. “} attr_action {”connection_name“”set_to“” 价值 source_dataset “} ATTR_ACTION { ”“ ”工作区“， ”SET_TO“” 价值 fme_basename. “}输出输出FEATURE_TYPE AttributeCreator_2_OUTPUT＃------------------------------------------------------------------------- FACTORY_DEF {*} FeatureJoinerFactory FACTORY_NAME FeatureJoiner_3 INPUT LEFT FEATURE_TYPE AttributeCreator_2_OUTPUT INPUT RIGHT FEATURE_TYPE TestFilter_database JOIN_MODE内JOIN_KEYS reader_id reader_idAUTO workspace_id workspace_id AUTO ATTR_CONFLICT_RES输出JOINED FEATURE_TYPE FeatureJoiner_3_JOINED输出USE_LEFT GEOMETRY_HANDLING USE_LEFT feature_type featurejoiner_3_ default_macro _wb_bypass_termination no factory_def * teefactory factory_name featurejoiner_3_ INPUT FEATURE_TYPE FeatureJoiner_3_ 输出失败feature_type * @abort（编码，featurejoiner_3 输出 一种 拒绝了 特征。 到 继续 翻译 什么时候 特征 是 拒绝了 改变 工作空间 参数 翻译 拒绝了 特征 处理 到 继续 翻译 ）＃---------------------------------------------------------------------宏Casemac包括[如果{{否} == {no}} {puts {宏Casemac -Nocase}}]tcl2 proc stringreplacer_28340aa9_b252_4a17_b19c_97429606858a2_replacer {findtext replayext invalidvalue} {set attrs [split \“connection_name \”{，}];set sendvalue [fme_decodeText $ findtext];set replacevalue [fme_decodeText $ replaceText];foreachtrat $ attrs {set attrval [fme_getattribute $ attr];设置nom暂停真的;if {{否} == {是}} {set newattrval [fme_replaceregex $（casemac）$ findvalue $ atterval $ replacevalue];} else {set newattrval [string映射$（casemac）[list $ $ findvalue $ replacevalue] $ atterval];}; if { $newAttrVal ne $attrVal } { set noMatch false; FME_SetAttribute $attr $newAttrVal; }; if {$noMatch} { if { $invalidValue == {FME_NULL_VALUE} } { FME_SetAttributeNull $attr; } elseif { $invalidValue != {_FME_NO_OP_} } { FME_SetAttribute $attr [FME_DecodeText $invalidValue]; }; }; }; } FACTORY_DEF * TeeFactory FACTORY_NAME StringReplacer INPUT FEATURE_TYPE FeatureJoiner_JOINED INPUT FEATURE_TYPE FeatureJoiner_3_JOINED INPUT FEATURE_TYPE FeatureJoiner_4_JOINED OUTPUT FEATURE_TYPE StringReplacer_OUTPUT @Tcl2("StringReplacer_28340aa9_b252_4a17_b19c_97429606858a2_replacer { 空间 } { } {_FME_NO_OP_}“）＃------------------------------------------------------------------------- FACTORY_DEF * RoutingFactory FACTORY_NAME “目的地功能类型的路由相关器” COMMAND_PARM_EVALUATION SINGLE_PASS输入FEATURE_TYPE * ROUTE FME_GENERIC StringReplacer_OUTPUT TOXLSXW __GO_TO_FINAL_OUTPUT_ROUTER__ multi_writer_id，0， 供应 编码 __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 Insert xlsx_row_id_column "" xlsx_protect_sheet NO xlsx_protect_sheet_level xlsx_protect_sheet_password xlsx_protect_sheet_permissions 格式化自动（20，版本 1 number_format_string. 字体 字体颜色 背景颜色 pattern_color. pattern_style CELL_BORDER_FORMATTING 不 CELL_BORDER_COLOR cell_border_style. text_alignment 不 水平对齐 vertical_alignment 缩进 text_orientation. text_control cell_protection 不 hide_cells. lock_cells. 汽车(20日版本)对象 1 number_format_string. 字体 字体颜色 背景颜色 pattern_color. pattern_style CELL_BORDER_FORMATTING 不 CELL_BORDER_COLOR cell_border_style. text_alignment 不 水平对齐 vertical_alignment 缩进 text_orientation. text_control cell_protection 不 hide_cells. lock_cells. ）connection_name auto（20，版本 1 number_format_string. 字体 字体颜色 背景颜色 pattern_color. pattern_style CELL_BORDER_FORMATTING 不 CELL_BORDER_COLOR cell_border_style. text_alignment 不 水平对齐 vertical_alignment 缩进 text_orientation. text_control cell_protection 不 hide_cells. lock_cells. ）工作空间自动（20，版本 1 number_format_string. 字体 字体颜色 背景颜色 pattern_color. pattern_style CELL_BORDER_FORMATTING 不 CELL_BORDER_COLOR cell_border_style. text_alignment 不 水平对齐 vertical_alignment 缩进 text_orientation. text_control cell_protection 不 hide_cells. lock_cells. ）