Folders to search:
Use the Select Multiple Folders/Files Browser
edit the excel catalogue to remove any duplicate workspace, versions etc.
" POSITION="2296.8979689796893 -678.13178131781331" TOP_LEFT="2296.8979689796893 -678.13178131781331" BOTTOM_RIGHT="3046.8979689796893 -728.13178131781331" BOUNDING_RECT="2296.8979689796893 -678.13178131781331 750 50" ORDER="500000000000009" FOLLOW_ANCHOR="true" INFO_NODE="false" COLOUR="1,1,0.78431372549019607,0.19607843137254902" SIZE_POLICY="10" ANCHORED_NODE="0">Add an 'id' for files with the same name but different source folder
" POSITION="714.37684376843754 -1612.0030313603133" TOP_LEFT="714.37684376843754 -1612.0030313603133" BOTTOM_RIGHT="1180.3923439234386 -1842.0050313803135" BOUNDING_RECT="714.37684376843754 -1612.0030313603133 466.01550015500106 230.0020000200002" ORDER="500000000000016" FOLLOW_ANCHOR="true" INFO_NODE="false" COLOUR="1,1,0.78431372549019607,0.19607843137254902" SIZE_POLICY="10" ANCHORED_NODE="24">fmeworkspace全部的 WRITER_TYPE MULTI_WRITER MULTI_WRITER_DATASET_ORDER BY_ID MULTI_WRITER_TYPE{0}文件拷贝MULTI_WRITER_关键字{0}文件拷贝_1multi_WRITER_TYPE{1}XLSXW MULTI_WRITER_关键字{1}XLSXW_2#！END_WB#HEADER#！START_WB#HEADER宏"路径“#！结束WB头#！开始源头路径路径路径路径路径路径1#========================================================================================================================================================================================================================全局模式中的默认宏路径路径路径路径路径1”***． fmw fmwt fmx PATH#U 1#U GLOB#U PATTERN“$（PATH#U IN#U GLOB#U PATH#U 1）”GUI可选文本#U编码路径#U GLOB#U PATH#U 1路径过滤器：#====================================================================================================================================================================================================================================================================================================================================================================================================================================GUI选择路径\u在\u类型\u路径\u 1任何%目录%文件允许的路径类型：#======================================================================================================================================================默认宏路径\u在\u文件中检索\u属性\u路径\u 1是路径\u在\u文件中检索\u属性GUI选择路径在检索文件属性中1是%否检索文件属性：#==========================================================================================================================================================================================================================================以下GUI行提示从中读取此映射文件生成的数据集是：！结束源头！START_WB_HEADER DEFAULT_MACRO SourceDataset INCLUDE[if{{{$（SourceDataset）}！=“”}{\put{DEFAULT_MACRO SourceDataset_PATH_1$（SourceDataset）}\}]#！结束(WB)(u头#)!！启动\u源\u头路径路径\u 1默认\u宏源数据集\u路径\u 1$（源数据集\u路径）GUI多目录源数据集\u路径\u 1源文件夹和文件路径名文件夹：#=======================================================================================================================================================================================================================================================================================================================================================================================================================================================================================$（路径\在\网络\身份验证\路径\ 1）“GUI可选身份验证程序路径\在\网络\身份验证\路径\ 1容器%组%容器\标题%“网络身份验证”%提示类型%NETWORK NETWORK Authentication=======================================================================================================================================================================================默认的U属性中的U宏路径读取U路径中的U 1所有路径读取U属性中的U路径读取“$（U属性中的路径读取U路径U路径U路径U路径U路径U 1）”路径读取U数据集“$（源U路径U）路径1生成FME生成NUM 16716！结束源头！开始WB头宏WB关键字“XLSXR1”#！结束#WB#头#！开始#源#头XLSXR XLSXR 1#==============================================================================================================================================================================首先获取数据库的数据集。对于Excel，它是文件名。现在，无论何时生成此映射，我们都将使用它from was:#！END_SOURCE_HEADER#！START_WB_HEADER DEFAULT_宏源数据集包括[if{{$（SourceDataset）}=“}{\put{DEFAULT_MACRO SourceDataset_XLSXR_1$（SourceDataset）}]#！END_WB_HEADER#！START_SOURCE_HEADER XLSXR XLSXR XLSXR 1 DEFAULT_宏源数据集$（SourceCatalog）}GUI多文件Excel数据集文件（*.xlsx；*.xlsm；*.xls）*.xlsx；*.xlsm；*.xls | Excel | u工作簿2007（*.xlsx）*.xlsx | Excel |宏|工作簿（*.xlsm）*.xlsm Excel |工作簿2007年之前（*.xls）*.xls |所有|文件（*）源Microsoft Excel文件：#GUI组TABLELIST约束#TABLELIST不显示在GUI中，但基础结构需要#不显示表格列表弹出窗口默认(配置中的宏XLSXR_数据集中的XLSXR_1 D:/MarksFMEWork/FME Workspace_Statistics/results/FMEWorkspaceList.xlsx XLSXR_1(配置中的sxr_数据集)#标记从col#u 1、col#u 2等的旧命名方案切换到a、b等#为了更好地匹配Excel文件默认的(Excel中的宏XLSXR_)col_名称(uxlsxr(u1)YES XLSXR 1(u1)Excel中的XLSXR u1(col XLSXR xlu1)u1)默认的(宏日期(u1)日期(u1)时间)默认宏XLSXR\u在多个文件中XLSXR\u在多个文件中XLSXR\u在多个文件中XLSXR\u在多个模式中使用其他文件多个文件参数默认宏XLSXR\u在多个文件参数中使用模式中使用其他文件不使用模式中使用其他文件1.SXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXLSXR_1）”GUI可选复选框XLSXR_IN_SCAN_SCHEMA_IF_DYNAMIC_XLSXR_1 Yes%No扫描模式IN_READ_BLANK_AS_XLSXR_1缺少XLSXR_1_READ_BLANK_作为“$（XLSXR_IN_READ_BLANK_AS_XLSXR_1）”GUI选项XLSXR_IN_READ_BLANK_AS_XLSXR_1缺少%Null读取空白单元格AS:DEFAULT_宏XLSXR_IN_EXPAND_MERGED_cells_XLSXR_1 Yes XLSXR_1_EXPAND_MERGED_cells“$（XLSXR IN_EXPAND_MERGED_cells_XLSXR 1）”GUI可选复选框XLSXR\u IN_EXPAND\u MERGED\u CELLS\u XLSXR\u 1 Yes%No EXPAND MERGED CELLS:DEFAULT\u MACRO XLSXR\u IN_EXPOSE\u ATTRS\u GROUP\u XLSXR\u 1\u EXPOSE\u ATTRS\u GROUP\u XLSXR\u 1“$（XLSXR EXPOSE\u ATTRS\u GROUP\u XLSXR\u XLSXR 1中的XLSXR\u）“DEFAULT\u MACRO XLSXR XLSXR\u IN\u IN\u查询功能类型\u用于合并过滤器\u是查询类型”$（XLSXR_IN_QUERY_FEATURE_TYPES_FOR_MERGE_FILTERS_XLSXR_1）“默认亚搏在线_宏XLSXR_IN_区分大小写_FEATURE_TYPES_XLSXR_1区分大小写_FEATURE_TYPES_是XLSXR_1_区分大小写_FEATURE_”$(XLSXR_IN_CASE_SENSITIVE_FEATURE_TYPES_XLSXR_1)" DEFAULT_MACRO XLSXR_IN_ALLOW_DOLLAR_SIGNS_XLSXR_1 YES XLSXR_1_ALLOW_DOLLAR_SIGNS "$(XLSXR_IN_ALLOW_DOLLAR_SIGNS_XLSXR_1)" # =========================================================================== DEFAULT_MACRO XLSXR_IN_NETWORK_AUTHENTICATION_XLSXR_1 XLSXR_1_NETWORK_AUTHENTICATION "$(XLSXR_IN_NETWORK_AUTHENTICATION_XLSXR_1)" GUI OPTIONAL AUTHENTICATOR XLSXR_IN_NETWORK_AUTHENTICATION_XLSXR_1 CONTAINER%GROUP%CONTAINER_TITLE%"Network Authentication"%PROMPT_TYPE%NETWORK Network Authentication # ============================================================================ DEFAULT_MACRO XLSXR_IN_ATTRIBUTE_READING_XLSXR_1 DEFLINE XLSXR_1_ATTRIBUTE_READING "$(XLSXR_IN_ATTRIBUTE_READING_XLSXR_1)" # ============================================================================ XLSXR_1_GENERATE_FME_BUILD_NUM 18510 XLSXR_1_DATASET "$(SourceDataset_XLSXR_1)" #! END_SOURCE_HEADER #! START_WB_HEADER MACRO WB_KEYWORD "FILECOPY_1" #! END_WB_HEADER #! START_DEST_HEADER FILECOPY FILECOPY_1 #! END_DEST_HEADER #! START_WB_HEADER DEFAULT_MACRO DestDataset INCLUDE [ if {"$(DestDataset)" != ""} { \ puts {DEFAULT_MACRO DestDataset_FILECOPY_1 $(DestDataset)} \ } ] #! END_WB_HEADER #! START_DEST_HEADER FILECOPY FILECOPY_1 DEFAULT_MACRO DestDataset_FILECOPY_1 $(DestDataset_FILECOPY) GUI DIRNAME DestDataset_FILECOPY_1 Destination File Copy Folder: # ===================================================================== # The following GUI line prompts for the overwrite flag. # The default is YES. # Possible values are YES or NO. # Any value other than NO or no is interpreted as YES. DEFAULT_MACRO FILECOPY_OUT_FILE_OPERATION_FILECOPY_1 COPY FILECOPY_1_FILE_OPERATION "$(FILECOPY_OUT_FILE_OPERATION_FILECOPY_1)" GUI CHOICE FILECOPY_OUT_FILE_OPERATION_FILECOPY_1 COPY%MOVE File Operation: # ===================================================================== # The following GUI line prompts for the overwrite flag. # The default is YES. # Possible values are YES or NO. # Any value other than NO or no is interpreted as YES. DEFAULT_MACRO FILECOPY_OUT_OVERWRITE_FILE_FILECOPY_1 YES FILECOPY_1_OVERWRITE_FILE "$(FILECOPY_OUT_OVERWRITE_FILE_FILECOPY_1)" GUI CHOICE FILECOPY_OUT_OVERWRITE_FILE_FILECOPY_1 YES%NO Overwrite Existing File: # ===================================================================== # The following GUI line prompts for the copy source folder flag. # The default is YES. # Possible values are YES or NO. # Any value other than NO or no is interpreted as YES. DEFAULT_MACRO FILECOPY_OUT_COPY_SOURCE_DIRECTORY_FILECOPY_1 NO FILECOPY_1_COPY_SOURCE_DIRECTORY "$(FILECOPY_OUT_COPY_SOURCE_DIRECTORY_FILECOPY_1)" GUI CHOICE FILECOPY_OUT_COPY_SOURCE_DIRECTORY_FILECOPY_1 YES%NO Copy Source Folder: # ===================================================================== # The following GUI line prompts for the copy subfolders flag. # The default is YES. # Possible values are YES or NO. # Any value other than NO or no is interpreted as YES. DEFAULT_MACRO FILECOPY_OUT_COPY_SUBDIRECTORIES_FILECOPY_1 NO FILECOPY_1_COPY_SUBDIRECTORIES "$(FILECOPY_OUT_COPY_SUBDIRECTORIES_FILECOPY_1)" GUI CHOICE FILECOPY_OUT_COPY_SUBDIRECTORIES_FILECOPY_1 YES%NO Copy Subfolders: # ===================================================================== # The following GUI line prompts for the error on non-existent source flag. # The default is NO. # Possible values are YES or NO. # Any value other than NO or no is interpreted as YES. DEFAULT_MACRO FILECOPY_OUT_FAIL_NONEXISTENT_SOURCE_FILECOPY_1 NO FILECOPY_1_FAIL_NONEXISTENT_SOURCE "$(FILECOPY_OUT_FAIL_NONEXISTENT_SOURCE_FILECOPY_1)" GUI CHOICE FILECOPY_OUT_FAIL_NONEXISTENT_SOURCE_FILECOPY_1 YES%NO Error on Non-Existent Source: # ===================================================================== # Set the mime type. Note -- it is actually only used inside of workspaces # as a FORMAT_PARAMETER which even then is parsed only by the FME Server # Repository Manager # The list of mime types below is far from complete but was determined from # http://en.wikipedia.org/wiki/Internet_media_type as the common types. DEFAULT_MACRO FILECOPY_OUT_MIME_TYPE_FILECOPY_1 text/plain FILECOPY_1_MIME_TYPE "$(FILECOPY_OUT_MIME_TYPE_FILECOPY_1)" GUI OPTIONAL STRING_OR_CHOICE FILECOPY_OUT_MIME_TYPE_FILECOPY_1 application/json%application/pdf%application/x-dvi%application/x-shockwave-flash%application/x-rar-compressed%application/x-tar%application/zip%audio/mpeg%audio/vnd.rn-realaudio%audio/x-ms-wma%audio/x-wav%image/gif%image/jpeg%image/png%image/svg+xml%image/tiff%text/css%text/csv%text/html%text/plain%text/xml%video/mp4%video/mpeg%video/quicktime%video/x-ms-wmv MIME Type: # ============================================================================ # Opt in for destination dataset type vs format type validation DEFAULT_MACRO FILECOPY_OUT_DESTINATION_DATASETTYPE_VALIDATION_FILECOPY_1 Yes FILECOPY_1_DESTINATION_DATASETTYPE_VALIDATION "$(FILECOPY_OUT_DESTINATION_DATASETTYPE_VALIDATION_FILECOPY_1)" FILECOPY_1_DATASET "$(DestDataset_FILECOPY_1)" FILECOPY_1_GENERATE_FME_BUILD_NUM 16716 #! END_DEST_HEADER #! START_WB_HEADER MACRO WB_KEYWORD "XLSXW_2" #! END_WB_HEADER #! START_DEST_HEADER XLSXW XLSXW_2 # ============================================================================ # 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_2 $(DestDataset)} \ } ] #! END_WB_HEADER #! START_DEST_HEADER XLSXW XLSXW_2 DEFAULT_MACRO DestDataset_XLSXW_2 $(TargetCatalog_XLSXW) GUI FILENAME DestDataset_XLSXW_2 Excel_Files(*.xlsx;*.xlsm;*.xls)|*.xlsx;*.xlsm;*.xls|All_files(*)|* Destination Microsoft Excel File: # ============================================================================ DEFAULT_MACRO XLSXW_OUT_FME_GROUP_NAMED1_XLSXW_2 FME_DISCLOSURE_OPEN GUI OPTIONAL DISCLOSUREGROUP XLSXW_OUT_FME_GROUP_NAMED1_XLSXW_2 XLSXW_OUT_OVERWRITE_FILE_XLSXW_2%XLSXW_OUT_TEMPLATEFILE_XLSXW_2%XLSXW_OUT_TEMPLATE_SHEET_XLSXW_2 Writer Parameters # Whether or not to overwrite the file DEFAULT_MACRO XLSXW_OUT_OVERWRITE_FILE_XLSXW_2 Yes XLSXW_2_OVERWRITE_FILE "$(XLSXW_OUT_OVERWRITE_FILE_XLSXW_2)" GUI ACTIVECHOICE XLSXW_OUT_OVERWRITE_FILE_XLSXW_2 Yes%No,XLSXW_OUT_TEMPLATEFILE_XLSXW_2,XLSXW_OUT_TEMPLATE_SHEET_XLSXW_2,XLSXW_OUT_+TEMPLATEFILE+ 覆盖现有文件：#模板文件选项默认_宏XLSXW_OUT_模板文件_XLSXW_2 XLSXW_2_模板文件“$（XLSXW_OUT_模板文件_XLSXW_2）”GUI可选文件名_必须存在XLSXW_OUT_模板文件_XLSXW_2 Excel文件（*.xlsx；*.xlsm*.xls）*.xlsx；*.xlsx；*。xlsm；*。xls | Excel_工作簿_2007（*.xlsx）|*.xlsx | Excel_宏_工作簿（*.xlsm）|*.xlsm | Excel_工作簿_Pre_2007（*.xls）|*.xls |所有_文件（*）|*模板文件：GUI查找XLSXW |模板文件xlusxw 2 ，默认\u宏XLSXW\u输出\u模板\u工作表\u XLSXW\u 2\u模板\u工作表“$（XLSXW\u输出\u模板\u工作表\u XLSXW\u 2）”GUI可选动态\u单个\u选择XLSXW\u输出\u模板\u工作表\u XLSXW\u 2$[XLSXW\u输出\u模板文件\u XLSXW\u 2]，检索\u所有\u表\u名称，是，忽略\u所有\u命名\u范围，是，\u格式\u覆盖\u，XLSXW模板工作表：GUI查找XLSXW\u输出\u模板工作表\u XLSXW\u 2 , # ============================================================================ # 参数的值将会牵扯到功能类型,但不会像作家级别设置# #保持默认不放的功能类型第一DEFAULT_MACRO XLSXW_OUT_DROP_TABLE_XLSXW_2没有XLSXW_2_DROP_TABLE " $ (XLSXW_OUT_DROP_TABLE_XLSXW_2) "#默认不截断特性类型(removeallcelldata,retainformatting/headers等)DEFAULT_MACRO XLSXW_OUT_TRUNCATE_TABLE_XLSXW_2 No xlsxw_2truncate_table "$(XLSXW_OUT_TRUNCATE_TABLE_XLSXW_2)"#保持与宽松的attrName的兼容性。XLSXW_OUT_STRICT_SCHEMA_ADDITIONAL_ATTRIBUTE_MATCHING_XLSXW_2 yes xlsxw_2 _strict_schema_additional_attribute_matching_xlsxw_2 yes xlsxw_2 _strict_schema_additional_attribute_matching_xlsxw_2#默认输出字段名DEFAULT_MACRO XLSXW_OUT_FIELD_NAMES_OUT_XLSXW_2 Yes XLSXW_2_FIELD_NAMES_OUT "$(XLSXW_OUT_FIELD_NAMES_OUT_XLSXW_2)"#默认写入模式DEFAULT_MACRO XLSXW_OUT_WRITER_MODE_XLSXW_2插入XLSXW_2_WRITER_MODE "$(XLSXW_OUT_WRITER_MODE_XLSXW_2)"#默认光栅写入类型DEFAULT_MACRO XLSXW_OUT_RASTER_FORMAT_XLSXW_2 PNG XLSXW_2_RASTER_FORMAT "$(XLSXW_OUT_RASTER_FORMAT_XLSXW_2)"# ============================================================================ # 没有选择excel文件保护模式DEFAULT_MACRO XLSXW_OUT_PROTECT_SHEET_XLSXW_2 XLSXW_2_PROTECT_SHEET " $ (XLSXW_OUT_PROTECT_SHEET_XLSXW_2) "DEFAULT_MACRO XLSXW_OUT_PROTECT_SHEET_PASSWORD_XLSXW_2 . #是否启用表密码保护 XLSXW_2_PROTECT_SHEET_PASSWORD“$（XLSXW_OUT_PROTECT_SHEET_PASSWORD_XLSXW_2）”#哪种保护级别默认_宏XLSXW_OUT_PROTECT_SHEET_level_XLSXW_2 XLSXW_2_PROTECT_SHEET_LEVEL " $ (XLSXW_OUT_PROTECT_SHEET_LEVEL_XLSXW_2) "DEFAULT_MACRO XLSXW_OUT_PROTECT_SHEET_PERMISSIONS_XLSXW_2将启用哪些特定的权限 XLSXW_2_PROTECT_SHEET_PERMISSIONS " $ (XLSXW_OUT_PROTECT_SHEET_PERMISSIONS_XLSXW_2) "# ============================================================================ # 选择的目标数据类型和格式类型验证DEFAULT_MACRO XLSXW_OUT_DESTINATION_DATASETTYPE_VALIDATION_XLSXW_2是的XLSXW_2_DESTINATION_DATASETTYPE_VALIDATION " $ (XLSXW_OUT_DESTINATION_DATASETTYPE_VALIDATION_XLSXW_2) "Default_macro xlsxw_out_coordinate_system_granularity_xlsxw_2 feature xlsxw_2coordinate_system_granularity "$(xlsxw_out_coordinate_system_granularity_xlsxw_2)"# ============================================================================ 18301年XLSXW_2_GENERATE_FME_BUILD_NUM XLSXW_2_DATASET " $ (DestDataset_XLSXW_2) "# !END_DEST_HEADER # !START_WB_HEADER # !END_WB_HEADER # !END_HEADER LOG_FILENAME " $ (FME_MF_DIR) FileCopyWorkspace v01.log”LOG_APPEND没有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 LOG_FILTER_MASK 1 DEFAULT_MACRO DATASET_KEYWORD_PATH_1 PATH_1 DEFAULT_MACRODATASET_KEYWORD_XLSXR_1 XLSXR_1 DEFAULT_MACRO DATASET_KEYWORD_FILECOPY_1 FILECOPY_1 DEFAULT_MACRO DATASET_KEYWORD_XLSXW_2 XLSXW_2 # ------------------------------------------------------------------------- PATH_1_READER_META_ATTRIBUTES fme_feature_type # ------------------------------------------------------------------------- XLSXR_1_READER_META_ATTRIBUTES fme_feature_type # ------------------------------------------------------------------------- MULTI_READER_CONTINUE_ON_READER_FAILURE No # ------------------------------------------------------------------------- MACRO WORKSPACE_NAME FileCopyWorkspace v01 MACRO FME_VIEWER_APP fmedatainspector # ------------------------------------------------------------------------- FACTORY_DEF * RoutingFactory FACTORY_NAME "Router and Unexpected Input Remover" COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE * ROUTE XLSXR XLSXR_1::FMEWorkspaceCatalog multi_reader_keyword,$(DATASET_KEYWORD_XLSXR_1) TO FME_GENERIC ::FMEWorkspaceCatalog ALIAS_GEOMETRY MERGE_INPUT Yes OUTPUT ROUTED FEATURE_TYPE * PATH_1_MERGE_DEF PATH_1::PATH EXACT PATH XLSXR_1_MERGE_DEF XLSXR_1::FMEWorkspaceCatalog EXACT FMEWorkspaceCatalog DEFLINE xlsx_start_row,,xlsx_end_row,,fme_attribute_reading,defined,workspaceFilename,char 81 、LastModified datetime、扩展字符 5 ，目录，字符 184 ，工作空间路径，字符 216 #----------------------------------------------------------------------------------------FACTORY\u DEF*TeeFactory\u NAME“路径（路径）拆分器”输入功能\u类型路径输出功能\u类型路径\u路径\u 1----------------------------------------------------------------------------------------FACTORY\u DEF*TeeFactory\u NAME“FMEWorkspaceCatalog（XLSXR\u 1）拆分器”输入功能\u类型FMEWorkspaceCatalog输出功能\u类型FMEWorkspaceCatalog\u XLSXR\u 1默认值\u宏WB\u当前\u上下文\#-------------------------------------------------------------工厂\u定义{*}DuplicateRemoveFactory\u NAME DuplicateFilter命令\u PARM\u EVALUATION SINGLE\u PASS支持\u功能\u表输入功能\u类型FMEWorkspaceCatalog\u XLSXR\u 1键\u属性{workspaceFilename}输入\u有序无输出重复功能\u类型重复筛选器\u重复输出唯一功能\u类型重复筛选器\u唯一性\u-----------------------------------------------------------------------------------------创建此转换器将使用的域名因为@Count本身将计算表达式以计算#域，所以我们不需要在Tcl中对每个功能执行任何操作，包括[set domainPrefix{}；if{{Global}=={Local}{set domainPrefix[FME_EncodeText{Counter}]}；put“宏计数器{FULL_domain${domainPrefix}@EvaluateExpression（FDIV，STRING)ENCODED，”， 价值 workspaceFilename 计数器)”;[FACTORY_DEF * ExecuteFunctionFactory FACTORY_NAME Counter_Rejector INPUT FEATURE_TYPE DuplicateFilter_DUPLICATE FUNCTION_DEFINITION @Count(REJECTABLE_WITH_FLAG,fme_encoded，$(Counter_FULL_DOMAIN)，"1") RESULT_ATTRIBUTE "_fileID" OUTPUT COMPLETE FEATURE_TYPE Counter_OUTPUT OUTPUT REJECTED FEATURE_TYPE counter FACTORY_DEF * tefactory FACTORY_NAME "计数器 变压器输出Nuker" INPUT FEATURE_TYPE Counter_ #--------------------------------------------------------------------------------------工厂属性工厂名称属性创建器输入功能类型计数器输出多功能模式无空属性模式无操作属性集创建指令传播缺少属性操作{“workspaceFilename”设置为 价值 workspaceFilename 价值 _文件ID ． 价值 扩展 ”}输出输出FEATURE_TYPE AttributeCreator_OUTPUT # ------------------------------------------------------------------------- FACTORY_DEF {*} AttrSetFactory FACTORY_NAME AttributeCreator_2输入FEATURE_TYPE DuplicateFilter_UNIQUE MULTI_FEATURE_MODE没有NULL_ATTR_MODE NO_OP ATTRSET_CREATE_DIRECTIVES _PROPAGATE_MISSING_FDIV ATTR_ACTION{”““SET_TO”“workspaceFilename 价值 workspaceFilename ． 价值 扩展 } OUTPUT OUTPUT FEATURE_TYPE AttributeCreator_2_OUTPUT # ------------------------------------------------------------------------- FACTORY_DEF {*} AttrSetFactory FACTORY_NAME AttributeManager_2 INPUT FEATURE_TYPE AttributeCreator_OUTPUT INPUT FEATURE_TYPE AttributeCreator_2_OUTPUT MULTI_FEATURE_MODE NO NULL_ATTR_MODE NO_OPATTRSET_CREATE_DIRECTIVES _PROPAGATE_MISSING_FDIV ACTION_COLUMN 3 DEF_VAL_COLUMN 2 ATTR_ACTION {"workspaceFilename" "filecopy_dest_filename" "" "RENAME_SET_VALUE"} ATTR_ACTION {"workspacePath" "filecopy_source_dataset" "" "RENAME_SET_VALUE"} OUTPUT OUTPUT FEATURE_TYPE AttributeManager_2_OUTPUT #------------------------------------------------------------------------- FACTORY_DEF {*} AttrSetFactory FACTORY_NAME AttributeManager输入FEATURE_TYPE PATH_PATH_1 MULTI_FEATURE_MODE没有NULL_ATTR_MODE NO_OP ATTRSET_CREATE_DIRECTIVES _PROPAGATE_MISSING_FDIV ACTION_COLUMN 3 DEF_VAL_COLUMN 2 ATTR_ACTION{“path_windows”“workspacePath”““RENAME_SET_VALUE”}ATTR_ACTION{“path_rootname”“workspaceFilename”““RENAME_SET_VALUE”}ATTR_ACTION{“path_extension”“扩展”““RENAME_SET_VALUE”}ATTR_ACTION{“path_modified_date”“LastModified”““RENAME_SET_VALUE”}ATTR_ACTION{“path_directory_windows”“目录”““RENAME_SET_VALUE”}FEATURE_TYPE输出输出AttributeManager_OUTPUT # ------------------------------------------------------------------------- FACTORY_DEF * RoutingFactory FACTORY_NAME“目的地功能类型路由相关器”COMMAND_PARM_EVALUATION SINGLE_PASS输入FEATURE_TYPE *路线FME_GENERIC AttributeManager_OUTPUT, XLSXW __GO_TO_FINAL_OUTPUT_ROUTER__ multi_writer_id, 1, SupplyAttributes 编码 __wb_out_feat_type__ FMEWorkspaceCatalog FILECOPY __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_2_DEF FMEWorkspaceCatalog 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 NO xlsx_protect_sheet_level . txt xlsx_protect_sheet_password xlsx_protect_sheet_permissions workspaceFilename字符串（20，版本 1 number_format_string 字体 字体颜色 背景色 图案颜色 pattern_style 单元格\u边框\u格式 不