亚搏在线_亚搏在线娱乐平台_亚搏国际在线官网

# !# !Example of how to load images into an Excel spreadsheet

" destination="NONE" destination_routing_file="" doc_extents="3237.86 2028.58" doc_top_left="65.184 -1671.08" end_python="" end_tcl="" explicit_bookmark_order="false" fme_build_num="18528" fme_document_guid="8d9e9795-2a9d-4b57-9b06-1c19df42053d" fme_document_priorguid="ea7c3499-154a-49e5-9b5b-97d6c6ceabfd,24b506b6-f8b9-4877-a99f-1058e5777231,9d4b1231-cacb-416e-896a-180d1d9af0b3,e7560d9a-d872-40bd-aea3-58b4d2b1323a,ccbd98da-7514-4af7-8220-3b63db4c38b2" fme_geometry_handling="Enhanced" fme_implicit_csmap_reprojection_mode="Auto" fme_reprojection_engine="FME" fme_server_services="" fme_stroke_max_deviation="0" history="" ignore_reader_failure="No" last_save_build="FME(R) 2018.1.0.1 (20180730 - Build 18528 - WIN64)" last_save_date="2018-08-31T09:05:56" log_file="" log_max_recorded_features="200" markdown_description="" markdown_usage="" max_log_features="200" multi_writer_dataset_order="BY_ID" password="" python_compatibility="27" redirect_terminators="NONE" show_annotations="true" show_info_nodes="true" source="NONE" source_routing_file="" terminate_rejected="NO" title="WritingImagesToExcel" usage="

" use_markdown="" view_position="-5.34193 357.91" warn_invalid_xform_param="Yes" workspace_version="1" zoom_scale="117"> # ! # ! # !# !# !# !# !# !# !# !# ! # !# !# !# !# !# !# !# !# !# !# !# ! # !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# ! # !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# ! # ! # !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# ! # !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# ! # ! # !# !# ! # !# !# !# ! # !# !# !# ! # !

Writer Type: Microsoft Excel
Feature Type: FireHalls
Dataset: FireHallsfromTemplate2 [XLSXW]
Geometry: All

Parameters:
Raster Format:: PNG
Row ID Attribute:: xlsx_row_id

" POSITION="1785.0061057764424 -653.57300000000009" TOP_LEFT="1785.0061057764424 -653.57300000000009" BOTTOM_RIGHT="2742.0681057764423 -1671.0830000000001" BOUNDING_RECT="1785.0061057764424 -653.57300000000009 957.06200000000001 1017.51" ORDER="500000000000000" FOLLOW_ANCHOR="true" INFO_NODE="false" COLOUR="0.66666666666666663,0.90196078431372551,1,0.29411764705882354" SIZE_POLICY="10" ANCHORED_NODE="13"># !

FireHalls: FireHalls [GML]

Source Coordinate System is UTM83-10

" POSITION="65.183999999999997 -38.998899999999999" TOP_LEFT="65.183999999999997 -38.998899999999999" BOTTOM_RIGHT="64.183999999999997 -37.998899999999999" BOUNDING_RECT="65.183999999999997 -38.998899999999999 -1 -1" ORDER="500000000000000" FOLLOW_ANCHOR="true" INFO_NODE="false" COLOUR="1,1,0.78431372549019607,0.19215686274509805" SIZE_POLICY="8" ANCHORED_NODE="1"># !

AttributeManager [AttributeManager]

Substitute Missing, Null and Empty by: No Substitution

Set 'xlsx_row_id' to '@Count(row_id,2)'

Set 'xlsx_col_id' to '4'

Set 'xlsx_raster_height' to '200'

Set 'xlsx_raster_width' to '200'

Set '_imageURL' to http://maps.googleapis.com/maps/api/staticmap?size=200x200&amp&sensor=false&markers=color:red|size:mid|label:F|@YValue(),@XValue()

" POSITION="65.183999999999997 357.49700000000001" TOP_LEFT="65.183999999999997 357.49700000000001" BOTTOM_RIGHT="2918.3370315303155 -3.7563125331253104" BOUNDING_RECT="65.183999999999997 357.49700000000001 2853.1530315303153 361.25331253312532" ORDER="500000000000000" FOLLOW_ANCHOR="true" INFO_NODE="false" COLOUR="1,1,0.78431372549019607,0.19215686274509805" SIZE_POLICY="8" ANCHORED_NODE="20"># !

Excel Writer

- Remove template file

- Turn OFF overwrite file

" POSITION="623.41607804727619 -875.24806248062487" TOP_LEFT="623.41607804727619 -875.24806248062487" BOTTOM_RIGHT="1240.4160780472762 -874.24806248062487" BOUNDING_RECT="623.41607804727619 -875.24806248062487 617 -1" ORDER="500000000000002" FOLLOW_ANCHOR="true" INFO_NODE="false" COLOUR="1,0,0,0.19607843137254902" SIZE_POLICY="10" ANCHORED_NODE="0"># !

change xlsx_col_id

" POSITION="1260.3399999999999 -18.765624986249861" TOP_LEFT="1260.3399999999999 -18.765624986249861" BOTTOM_RIGHT="1711.3399999999999 -17.765624986249861" BOUNDING_RECT="1260.3399999999999 -18.765624986249861 451 -1" ORDER="500000000000003" FOLLOW_ANCHOR="true" INFO_NODE="false" COLOUR="1,0,0,0.19607843137254902" SIZE_POLICY="10" ANCHORED_NODE="20"># !

FireHalls: FireHalls [XLSXW]

Set update writer mode

remove any columns you don't want to update (especislly the LocationMap column)

" POSITION="2631.043958406251 -119.28256623378203" TOP_LEFT="2631.043958406251 -119.28256623378203" BOTTOM_RIGHT="3303.043958406251 -118.28256623378203" BOUNDING_RECT="2631.043958406251 -119.28256623378203 672 -1" ORDER="500000000000004" FOLLOW_ANCHOR="true" INFO_NODE="false" COLOUR="1,0,0,0.19607843137254902" SIZE_POLICY="10" ANCHORED_NODE="13"># !# ! # !# ! # !# ! # ! # !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# ! # !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# ! # !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# !# ! # !# !# !# !# !# ! # !# ! # !# ! # !# ! # !# !FME_PYTHON_VERSION 27 GUI IGNORE SourceDataset_GML_1，GML_IN_IGNORE_APPLICATON_SCHEMA_GML_1，GML_IN_XSD_DOC_GML_1，GML_IN_VALIDATE_DATASET_GML_1，GML_IN_SKIP_SCHEMA_LOCATION_IN_DATASET_GML_1，GML_IN_MAP_FEATURE_COLLECTION_GML_1，GML_IN_GML_FEATURE_ELEMENTS_GML_1，GML_IN_SRS_GEOMETRY_PARAMETERS_GML_1，GML_IN_SRS_AXIS_ORDER_GML_1，GML_IN_SRS_ANGLE_DIRECTION_GML_1，GML_IN_ENFORCE_PATH_CONTINUITY_BY_GML_1，GML_IN_FEATURE_PROPERTIES_READER_GML_1，GML_IN_MAP_EMBEDDED_OBJECTS_AS_GML_1，GML_IN_MAP_PREDEFINED_GML_PROPERTIES_GML_1，GML_IN_MAP_GEOMETRY_COLUMNS_GML_1，GML_IN_MAP_ALL_SUBSTITUTABLE_PROPERTIES_GML_1，GML_IN_ADD_NAMESPACE_PREFIX_TO_NAMES_GML_1，GML_IN_QNAMES_FOR_PROPERTIES_TO_IGNORE_GML_1，GML_IN_ATTRIBUTE_HANDLING_GML_1，GML_IN_MAP_COMPLEX_PROPERTIES_AS_GML_1，GML_IN_MAX_MULTI_LIST_LEVEL_GML_1，GML_IN_ADD_GEOMETRIES_AS_XML_FRAGMENTS_GML_1，GML_IN_XML_FRAGMENTS_AS_DOCUMENTS_GML_1，gml_in_flatten_xml_fragments_gml_1，gml_in_flatten_xml_fragments_open_list_brace_gml_1，gml_in_flatten_xml_fragments_close_list_brACE_GML_1，GML_IN_FLATTEN_XML_FRAGMENTS_SEPARATOR_GML_1，GML_IN_GML_READER_GROUP_GML_1，GML_IN_USE_OLD_READER_GML_1，GML_IN_DISABLE_AUTOMATIC_READER_TYPE_SELECTION_GML_1，GML_IN_DISABLE_XML_NAMESPACE_PROCESSING_GML_1，GML_IN_EXPOSE_ATTRS_GROUP_GML_1，GML_IN_SEARCH_ENVELOPE_MINX_GML_1，GML_IN_SEARCH_ENVELOPE_MINY_GML_1，GML_IN_SEARCH_ENVELOPE_MAXX_GML_1，GML_IN_SEARCH_ENVELOPE_MAXY_GML_1，GML_IN_CLIP_TO_ENVELOPE_GML_1，GML_IN_GML_RDR_ADV_GML_1，GML_IN_CONTINUE_ON_GEOM_ERROR_GML_1，GML_IN_SYSTEM_ENCODING_GML_1，GML_IN_CACHE_XSD_GML_1，GML_IN_CACHE_XSD_EXPIRY_TIME_GML_1，GML_IN_MULTI_VALUE_SIMPLE_PROPERTIES_AS_CSV_GML_1，GML_IN_NETWORK_AUTHENTICATION_GML_1，SEARCH_ENVELOPE_COORDINATE_SYSTEM_GML_1，DestDataset_XLSXW_1，XLSXW_OUT_OVERWRITE_FILE_XLSXW_1，XLSXW_OUT_TEMPLATEFILE_XLSXW_1，TEMPLATE_SHEET_XLSXW_1 DEFAULT_MACRO SourceDataset_GML $（fme_mf_dir）写入之下magestoexcel-updater / 1 /紧急/ firehalls.gml gui multifile sourceatataset_gml gml_files（*。gml; *。gz; *。xml）| * .gml; * gz; *。xml | gml_files（*。gml）| gml_files* .gml |压缩_gml_files（*。gz）| * .gz | gml_files（*。xml）| * .xml | all_files | *源地理标记语言（gml）文件：default_macro destdataset_xlsxw d：\ tmp \ firehalls.xlsx gui filename destdataset_xlsxwExcel_files（*。xlsx; *。xlsm; *。xls）| * .xlsx; *。xlsm; *。xls | all_files（*）| * destination microsoft Excel文件：包括[if {$（sourceatataset_gml）} =={}} {puts_real {参数'sourceatataset_gml'必须给出一个值。};退出1;};]包括[如果{{$（destdataset_xlsxw）} == {}} {puts_real {参数'destdataset_xlsxw'必须给出一个值。};退出1;}; ] #! START_HEADER #! START_WB_HEADER READER_TYPE MULTI_READER MULTI_READER_TYPE{0} GML MULTI_READER_KEYWORD{0} GML_1 MULTI_READER_GEN_DIRECTIVES{0} MAP_ALL_SUBSTITUTABLE_PROPERTIES,YES,SEARCH_ENVELOPE_MAXY,0,ENFORCE_PATH_CONTINUITY_BY,SNAPPING_END_POINTS,SYSTEM_ENCODING,,FLATTEN_XML_FRAGMENTS_SEPARATOR,,ATTRIBUTE_HANDLING,,SRS_GEOMETRY_PARAMETERS,,MAP_COMPLEX_PROPERTIES_AS,Nested 属性，DISABLE_XML_NAMESPACE_PROCESSING，NO，QNAMES_FOR_PROPERTIES_TO_IGNORE ,, CACHE_XSD，是的，MAP_GEOMETRY_COLUMNS，YES，FLATTEN_XML_FRAGMENTS_OPEN_LIST_BRACE ,, _ MERGE_SCHEMAS，YES，SKIP_SCHEMA_LOCATION_IN_DATASET，不，USE_SEARCH_ENVELOPE，NO，MULTI_VALUE_SIMPLE_PROPERTIES_AS_CSV，不，MAP_PREDEFINED_GML_PROPERTIES，NO，IGNORE_APPLICATON_SCHEMA，不，XSD_DOC ,, SEARCH_ENVELOPE_MAXX，0，map_feature_collection ,, flatten_xml_fragments，no，gml_feature_elements，没用过 ,EXPOSE_ATTRS_GROUP,,SEARCH_ENVELOPE_MINX,0,GML_EXPOSE_FORMAT_ATTRS,,USE_OLD_READER,NO,SRS_AXIS_ORDER,,MAX_MULTI_LIST_LEVEL,,CLIP_TO_ENVELOPE,NO,GML_READER_GROUP,,XML_FRAGMENTS_AS_DOCUMENTS,YES,DISABLE_AUTOMATIC_READER_TYPE_SELECTION,NO,ADD_NAMESPACE_PREFIX_TO_NAMES,,CACHE_XSD_EXPIRY_TIME,,FEATURE_PROPERTIES_READER,,FLATTEN_XML_FRAGMENTS_CLOSE_LIST_BRACE,,ADD_GEOMETRIES_AS_XML_FRAGMENTS,NO,SEARCH_ENVELOPE_MINY,0,CONTINUE_ON_GEOM_ERROR,yes,MAP_EMBEDDED_OBJECTS_AS,ATTRIBUTES,FEATURE_TYPES_SCHEMA_MODE,XML_SCHEMA,VALIDATE_DATASET,no,SRS_ANGLE_DIRECTION,,GML_RDR_ADV, 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 "GML_1" #! END_WB_HEADER #! START_SOURCE_HEADER GML GML_1 # ============================================================================ # The following GUI lines prompt for a GML file to be used as the # the source of the data. # The user input is stored in a macro, which is then used to define # the dataset to be written. # 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_GML_1 $(SourceDataset)} \ } ] #! END_WB_HEADER #! START_SOURCE_HEADER GML GML_1 DEFAULT_MACRO SourceDataset_GML_1 $(SourceDataset_GML) GUI MULTIFILE SourceDataset_GML_1 GML_Files(*.gml;*.gz;*.xml)|*.gml;*gz;*.xml|GML_Files(*.gml)|*.gml|Compressed_GML_Files(*.gz)|*.gz|GML_Files(*.xml)|*.xml|All_Files|* Source Geography Markup Language (GML) File(s): # ============================================================================ DEFAULT_MACRO GML_IN_IGNORE_APPLICATON_SCHEMA_GML_1 no GML_1_IGNORE_APPLICATON_SCHEMA "$(GML_IN_IGNORE_APPLICATON_SCHEMA_GML_1)" GUI ACTIVECHOICE GML_IN_IGNORE_APPLICATON_SCHEMA_GML_1 no,GML_IN_GML_FEATURE_ELEMENTS%yes,GML_IN_XSD_DOC,GML_IN_VALIDATE_DATASET,GML_IN_FEATURE_TYPES_SCHEMA_MODE,GML_IN_SKIP_SCHEMA_LOCATION_IN_DATASET,GML_IN_FEATURE_PROPERTIES_READER,GML_IN_ATTRIBUTE_HANDLING,GML_IN_GML_READER_GROUP Ignore Application Schema: # ============================================================================ # The XSD_DOC keyword overwrites the location of the XML Schema document that # is specified in the xsi:schemaLocation of the XML dataset. DEFAULT_MACRO GML_IN_XSD_DOC_GML_1 GML_1_XSD_DOC "$(GML_IN_XSD_DOC_GML_1)" GUI OPTIONAL FILE_OR_URL GML_IN_XSD_DOC_GML_1 GML_Schema_File(*.xsd)|*.xsd|All_Files(*)|* Application Schema: # ============================================================================ # This specifies whether the XML dataset should be validated against its # DTD file. If set to 'auto', the XML document will only be validated if # its DTD file is available. DEFAULT_MACRO GML_IN_VALIDATE_DATASET_GML_1 no GML_1_VALIDATE_DATASET "$(GML_IN_VALIDATE_DATASET_GML_1)" GUI CHOICE GML_IN_VALIDATE_DATASET_GML_1 yes%no Validate GML Dataset File: # ============================================================================ # Specifies whether we should only show feature types from XSD or dataset DEFAULT_MACRO GML_IN_FEATURE_TYPES_SCHEMA_MODE_GML_1 XML_SCHEMA GML_1_FEATURE_TYPES_SCHEMA_MODE "$(GML_IN_FEATURE_TYPES_SCHEMA_MODE_GML_1)" DEFAULT_MACRO GML_IN_SKIP_SCHEMA_LOCATION_IN_DATASET_GML_1 No GML_1_SKIP_SCHEMA_LOCATION_IN_DATASET "$(GML_IN_SKIP_SCHEMA_LOCATION_IN_DATASET_GML_1)" GUI CHOICE GML_IN_SKIP_SCHEMA_LOCATION_IN_DATASET_GML_1 Yes%No Ignore xsi:schemaLocation in Dataset: DEFAULT_MACRO GML_IN_MAP_FEATURE_COLLECTION_GML_1 GML_1_MAP_FEATURE_COLLECTION "$(GML_IN_MAP_FEATURE_COLLECTION_GML_1)" GUI OPTIONAL LOOKUP_LISTBOX GML_IN_MAP_FEATURE_COLLECTION_GML_1 gml:FeatureCollection,gml%wfs:FeatureCollection,wfs Map FeatureCollection: DEFAULT_MACRO GML_IN_GML_FEATURE_ELEMENTS_GML_1 gml_1_gml_feature_elements“$（gml_in_gml_feature_elements_gml_1）”gui可选text_edit_ gml_in_gml_feature_elements_gml_1 gml特征元素：＃===========================================================================默认_macro gml_in_srs_gometry_parameters_gml_1 gui可选泄露rom gml_in_srs_geometry_parameters_gml_1 srs_axis_order％SRS_ANGLE_DIRECTION％ENFORCE_PATH_CONTINUITY_BY GML SRS /几何参数DEFAULT_MACRO GML_IN_SRS_AXIS_ORDER_GML_1 GML_1_SRS_AXIS_ORDER “$（GML_IN_SRS_AXIS_ORDER_GML_1）” GUI OPTIONAL CHOICE GML_IN_SRS_AXIS_ORDER_GML_1 1,2％2,1％1,2,3％2,1,3 GML SRS轴顺序：DEFAULT_MACRO GML_IN_SRS_ANGLE_DIRECTION_GML_1 GML_1_SRS_ANGLE_DIRECTION“$（GML_IN_SRS_ANGLE_DIRECTION_GML_1）” GUI可选LOOKUP_CHOICE GML_IN_SRS_ANGLE_DIRECTION_GML_1逆时针，CCW％顺时针，CW GML SRS角方向：DEFAULT_MACRO GML_IN_ENFORCE_PATH_CONTINUITY_BY_GML_1 SNAPPING_END_POINTS GML_1_ENFORCE_PATH_CONTINUITY_BY “$（GML_IN_ENFORCE_PATH_CONTINUITY_BY_GML_1）” GUi可选Lookup_Choice GML_IN_ENFORCE_PATH_CONTINININETY_BY_GML_1“\”捕捉端点\“，SNAPPANCE_END_POINTS”％“\”插入新段\“，插入_new_segment”实施路径连续性：＃============================================================================ DEFAULT_MACRO GML_IN_FEATURE_PROPERTIES_READER_GML_1 GUI可选DISCLOSUREGROUP GML_IN_FEATURE_PROPERTIES_READER_GML_1 MAP_EMBEDDED_OBJECTS_AS％MAP_PREDEFINED_GML_PROPERTIES％MAP_GEOMETRY_COLUMNS％MAP_ALL_SUBSTITUTABLE_PROPERTIES％ADD_NAMESPACE_PREFIX_TO_NAMES％QNAMES_FOR_PROPERTIES_TO_IGNORE特征属性DEFAULT_MACRO GML_IN_MAP_EMBEDDED_OBJECTS_AS_GML_1 ATTRIBUTES GML_1_MAP_EMBEDDED_OBJECTS_AS “$（GML_IN_MAP_EMBEDDED_OBJECTS_AS_GML_1）” GUI LOOKUP_CHOICE GML_IN_MAP_EMBEDDED_OBJECTS_AS_GML_1 “\” 属性\ “属性”％“几何形状”，几何“％”\“特征类型\”，feature_types“映射嵌入对象作为：default_macro gml_in_map_predefinned_gml_properties_gml_1 no gml_1_map_predefinning_gml_properties”$（gml_in_map_predefinED_GML_PROPERTIES_GML_1）” GUI可选复选框GML_IN_MAP_PREDEFINED_GML_PROPERTIES_GML_1 YES％没有地图的预定义属性DEFAULT_MACRO GML_IN_MAP_GEOMETRY_COLUMNS_GML_1 YES GML_1_MAP_GEOMETRY_COLUMNS “$（GML_IN_MAP_GEOMETRY_COLUMNS_GML_1）” GUI可选复选框GML_IN_MAP_GEOMETRY_COLUMNS_GML_1 YES％没有地图几何列DEFAULT_MACRO GML_IN_MAP_ALL_SUBSTITUTABLE_PROPERTIES_GML_1 YES GML_1_MAP_ALL_SUBSTITUTABLE_PROPERTIES “$（GML_IN_MAP_ALL_SUBSTITUTABLE_PROPERTIES_GML_1）” GUI可选复选框GML_IN_MAP_ALL_SUBSTITUTABLE_PROPERTIES_GML_1 YES％NO地图所有的可替代的属性DEFAULT_MACRO GML_IN_ADD_NAMESPACE_PREFIX_TO_NAMES_GML_1 GML_1_ADD_NAMESPACE_PREFIX_TO_NAMES “$（GML_IN_ADD_NAMESPACE_PREFIX_TO_NAMES_GML_1）” GUI可选LOOKUP_CHOICE GML_IN_ADD_NAMESPACE_PREFIX_TO_NAMES_GML_1 “\” 要素类\ “FEATURE_TYPES ”％“ \ ”功能类型和属性\“，FEATURE_TYPES_AND_ATTRIBUTES” 添加XML命名空间前缀到：DEFAULT_MACRO GML_IN_QNAMES_FOR_PROPERTIES_TO_IGNORE_GML_1 GML_1_QNAMES_FOr_properties_to_ignore“$（gml_in_qnames_for_properties_to_ignore_gml_1）”gui可选text_edit_xml gml_in_qnames_for_properties_to_ignore_gml_1属性忽略：＃===================================================================================== default_macro gml_in_attribute_handling_gml_1 gui可选披露群gml_in_attribute_handling_gml_1 map_complex_properties_as％MAX_MULTI_LIST_LEVEL％ADD_GEOMETRIES_AS_XML_FRAGMENTS％XML_FRAGMENTS_AS_DOCUMENTS％FLATTEN_XML_FRAGMENTS特征属性 - 属性处理DEFAULT_MACRO GML_IN_MAP_COMPLEX_PROPERTIES_AS_GML_1嵌套属性GML_1_MAP_COMPLEX_PROPERTIES_AS “$（GML_IN_MAP_COMPLEX_PROPERTIES_AS_GML_1）” GUI ACTIVECHOICE GML_IN_MAP_COMPLEX_PROPERTIES_AS_GML_1 “嵌套属性” ％ “\” XML片段\ “GML_IN_MAX_MULTI_LIST_LEVEL” 地图复杂的属性为：DEFAULT_MACRO GML_IN_MAX_MULTI_LIST_LEVEL_GML_1 GML_1_MAX_MULTI_LIST_LEVEL“$（gml_in_max_multi_list_level_gml_1）“gui可选选择gml_in_max_multi_list_level_gml_1 0％1％2％3％4％5％6％7％8％9％10％11％12％13％14％15％16％17％18％19％在嵌套列表的20限制次数属性：DEFAULT_MACRO GML_IN_ADD_GEOMETRIES_AS_XML_FRAGMENTS_GML_1 NO GML_1_ADD_GEOMETRIES_AS_XML_FRAGMENTS “$（GML_IN_ADD_GEOMETRIES_AS_XML_FRAGMENTS_GML_1）” GUI OPTIONAL CHECKBOX GML_IN_ADD_GEOMETRIES_AS_XML_FRAGMENTS_GML_1YES％无添加几何图形作为XML片段DEFAULT_MACRO GML_IN_XML_FRAGMENTS_AS_DOCUMENTS_GML_1 YES GML_1_XML_FRAGMENTS_AS_DOCUMENTS “$（GML_IN_XML_FRAGMENTS_AS_DOCUMENTS_GML_1）” GUI可选复选框GML_IN_XML_FRAGMENTS_AS_DOCUMENTS_GML_1 YES％NO包括XML声明的XML片段DEFAULT_MACRO GML_IN_FLATTEN_XML_FRAGMENTS_GML_1 NO GML_1_FLATTEN_XML_FRAGMENTS “$（GML_IN_FLATTEN_XML_FRAGMENTS_GML_1）” GUI ACTIVEDISCLOSUREGROUP GML_IN_FLATTEN_XML_FRAGMENTS_GML_1 FLATTEN_XML_FRAGMENTS_OPEN_LIST_BRACE％FLATTEN_XML_FRAGMENTS_CLOSE_LIST_BRACE％FLATTEN_XML_FRAGMENTS_SEPARATOR拼合XML片段Default_Macro GML_IN_FLATTEN_XML_FRAGMANS_OPEN_LIST_BRACE_GML_1 GML_1_FLATTEN_XML_FRAGMANSS_OPEN_LIST_BRACE “$（GML_IN_FLATTEN_XML_FRAGMENTS_OPEN_LIST_BRACE_GML_1）” GUI可选STRING_OR_CHOICE GML_IN_FLATTEN_XML_FRAGMENTS_OPEN_LIST_BRACE_GML_1 {％_％ - ％empty_string替代打开清单布雷斯：DEFAULT_MACRO GML_IN_FLATTEN_XML_FRAGMENTS_CLOSE_LIST_BRACE_GML_1 GML_1_FLATTEN_XML_FRAGMENTS_CLOSE_LIST_BRACE “$（GML_IN_FLATTEN_XML_FRAGMENTS_CLOSE_LIST_BRACE_GML_1）” GUI可选STRING_OR_CHOICE GML_IN_FLATTEN_XML_FRAGMENTS_CLOSE_LIST_BRACE_GML_1}％_％ - ％empty_string替代关闭名单布雷斯：DEFAULT_MACRO GML_IN_FLATTEN_XML_FRAGMENTS_SEPARATOR_GML_1 GML_1_FLATTEN_XML_FRAGMENTS_SEPARATOR "$(GML_IN_FLATTEN_XML_FRAGMENTS_SEPARATOR_GML_1)" GUI OPTIONAL STRING_OR_CHOICE GML_IN_FLATTEN_XML_FRAGMENTS_SEPARATOR_GML_1 .%_%empty_string Substitute Element List Separator: # ============================================================================ DEFAULT_MACRO GML_IN_GML_READER_GROUP_GML_1 GUI OPTIONAL DISCLOSUREGROUP GML_IN_GML_READER_GROUP_GML_1 USE_OLD_READER%DISABLE_AUTOMATIC_READER_TYPE_SELECTION%DISABLE_XML_NAMESPACE_PROCESSING Version and XML Namespace Processing DEFAULT_MACRO GML_IN_USE_OLD_READER_GML_1 NO GML_1_USE_OLD_READER "$(GML_IN_USE_OLD_READER_GML_1)" GUI OPTIONAL ACTIVECHECK GML_IN_USE_OLD_READER_GML_1 YES,GML_IN_MAP_ALL_SUBSTITUTABLE_PROPERTIES%NO Use Old Reader for GML v3.1.1 and v2.1.2 Documents DEFAULT_MACRO GML_IN_DISABLE_AUTOMATIC_READER_TYPE_SELECTION_GML_1 NO GML_1_DISABLE_AUTOMATIC_READER_TYPE_SELECTION "$(GML_IN_DISABLE_AUTOMATIC_READER_TYPE_SELECTION_GML_1)" GUI OPTIONAL CHECKBOX GML_IN_DISABLE_AUTOMATIC_READER_TYPE_SELECTION_GML_1 YES%NO Disable Automatic Reader Type Selection DEFAULT_MACRO GML_IN_DISABLE_XML_NAMESPACE_PROCESSING_GML_1 NO GML_1_DISABLE_XML_NAMESPACE_PROCESSING "$(GML_IN_DISABLE_XML_NAMESPACE_PROCESSING_GML_1)" GUI OPTIONAL CHECKBOX GML_IN_DISABLE_XML_NAMESPACE_PROCESSING_GML_1 YES%NO Disable XML Namespace Processing DEFAULT_MACRO GML_IN_EXPOSE_ATTRS_GROUP_GML_1 GML_1_EXPOSE_ATTRS_GROUP "$(GML_IN_EXPOSE_ATTRS_GROUP_GML_1)" GUI OPTIONAL DISCLOSUREGROUP GML_IN_EXPOSE_ATTRS_GROUP_GML_1 GML_EXPOSE_FORMAT_ATTRS Schema Attributes # Include this file in source setting section to add external search envelope processing # Zero as a default means we don't do any search -- this makes workbench happier # =========================================================================== DEFAULT_MACRO GML_IN_SEARCH_ENVELOPE_MINX_GML_1 0 GML_1_SEARCH_ENVELOPE "$(GML_IN_SEARCH_ENVELOPE_MINX_GML_1)" GUI OPTIONAL FLOAT GML_IN_SEARCH_ENVELOPE_MINX_GML_1 Minimum X: # =========================================================================== DEFAULT_MACRO GML_IN_SEARCH_ENVELOPE_MINY_GML_1 0 GML_1_SEARCH_ENVELOPE "$(GML_IN_SEARCH_ENVELOPE_MINY_GML_1)" GUI OPTIONAL FLOAT GML_IN_SEARCH_ENVELOPE_MINY_GML_1 Minimum Y: # =========================================================================== DEFAULT_MACRO GML_IN_SEARCH_ENVELOPE_MAXX_GML_1 0 GML_1_SEARCH_ENVELOPE "$(GML_IN_SEARCH_ENVELOPE_MAXX_GML_1)" GUI OPTIONAL FLOAT GML_IN_SEARCH_ENVELOPE_MAXX_GML_1 Maximum X: # =========================================================================== DEFAULT_MACRO GML_IN_SEARCH_ENVELOPE_MAXY_GML_1 0 GML_1_SEARCH_ENVELOPE "$(GML_IN_SEARCH_ENVELOPE_MAXY_GML_1)" GUI OPTIONAL FLOAT GML_IN_SEARCH_ENVELOPE_MAXY_GML_1 Maximum Y: # =========================================================================== # BUG18999: We now have a soft clip to fall back on like native spatial index # thus we are reintroducing the clip to envelop as an option for users. # Defualt to soft clip as per the existing database readers we are emulating DEFAULT_MACRO GML_IN_CLIP_TO_ENVELOPE_GML_1 NO GML_1_CLIP_TO_ENVELOPE "$(GML_IN_CLIP_TO_ENVELOPE_GML_1)" GUI OPTIONAL CHECKBOX GML_IN_CLIP_TO_ENVELOPE_GML_1 YES%NO Clip to Search Envelope DEFAULT_MACRO GML_IN_GML_RDR_ADV_GML_1 GUI OPTIONAL DISCLOSUREGROUP GML_IN_GML_RDR_ADV_GML_1 CONTINUE_ON_GEOM_ERROR%SYSTEM_ENCODING%CACHE_XSD%CACHE_XSD_EXPIRY_TIME%MULTI_VALUE_SIMPLE_PROPERTIES_AS_CSV Advanced # ============================================================================ # This keyword allows the GML reader to continue reading the input dataset when # it encounters an error reading a feature's geometry. DEFAULT_MACRO GML_IN_CONTINUE_ON_GEOM_ERROR_GML_1 yes GML_1_CONTINUE_ON_GEOM_ERROR "$(GML_IN_CONTINUE_ON_GEOM_ERROR_GML_1)" GUI CHOICE GML_IN_CONTINUE_ON_GEOM_ERROR_GML_1 yes%no Continue on Geometry Error: # ============================================================================ # This keyword specifies what encoding the GML schema and data features should # be in when they are output to the FME. The default value for this keyword # is the system's encoding. DEFAULT_MACRO GML_IN_SYSTEM_ENCODING_GML_1 GML_1_SYSTEM_ENCODING "$(GML_IN_SYSTEM_ENCODING_GML_1)" GUI OPTIONAL TEXT GML_IN_SYSTEM_ENCODING_GML_1 System Encoding: # ============================================================================ # This keyword allows XML Schemas to be temporarily cached thereby minimizing # the number of network fetches. DEFAULT_MACRO GML_IN_CACHE_XSD_GML_1 yes GML_1_CACHE_XSD "$(GML_IN_CACHE_XSD_GML_1)" GUI CHOICE GML_IN_CACHE_XSD_GML_1 yes%no Cache XSD Documents: # ============================================================================ # Specifies the amount of time in seconds an XML Schema document is allowed # to be cached before it expires. DEFAULT_MACRO GML_IN_CACHE_XSD_EXPIRY_TIME_GML_1 GML_1_CACHE_XSD_EXPIRY_TIME "$(GML_IN_CACHE_XSD_EXPIRY_TIME_GML_1)" GUI OPTIONAL INTEGER GML_IN_CACHE_XSD_EXPIRY_TIME_GML_1 Cache XSD Expiry Time: DEFAULT_MACRO GML_IN_MULTI_VALUE_SIMPLE_PROPERTIES_AS_CSV_GML_1 no GML_1_MULTI_VALUE_SIMPLE_PROPERTIES_AS_CSV "$(GML_IN_MULTI_VALUE_SIMPLE_PROPERTIES_AS_CSV_GML_1)" GUI CHOICE GML_IN_MULTI_VALUE_SIMPLE_PROPERTIES_AS_CSV_GML_1 no%yes Simple multi-valued properties as csv: # =========================================================================== DEFAULT_MACRO GML_IN_NETWORK_AUTHENTICATION_GML_1 GML_1_NETWORK_AUTHENTICATION "$(GML_IN_NETWORK_AUTHENTICATION_GML_1)" GUI OPTIONAL AUTHENTICATOR GML_IN_NETWORK_AUTHENTICATION_GML_1 CONTAINER%GROUP%CONTAINER_TITLE%"Network Authentication"%PROMPT_TYPE%NETWORK Network Authentication # =========================================================================== DEFAULT_MACRO GML_IN_ATTRIBUTE_READING_GML_1 ALL GML_1_ATTRIBUTE_READING "$(GML_IN_ATTRIBUTE_READING_GML_1)" # PR:31021 # Include this file in workbench source preamble section to enable the ability # to specify a coordinate system for search envelope processing # =========================================================================== DEFAULT_MACRO SEARCH_ENVELOPE_COORDINATE_SYSTEM_GML_1 GUI OPTIONAL COORDSYS SEARCH_ENVELOPE_COORDINATE_SYSTEM_GML_1 Search Envelope Coordinate System: GML_1_SEARCH_ENVELOPE_COORDINATE_SYSTEM "$(SEARCH_ENVELOPE_COORDINATE_SYSTEM_GML_1)" # =========================================================================== GML_1_DATASET "$(SourceDataset_GML_1)" GML_1_GENERATE_FME_BUILD_NUM 16664 #! 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: # ============================================================================ # 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_OUT_TEMPLATE_SHEET,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（*）| *模板文件：＃============================================================================＃参数将从特征类型占用的值，但不会留下作为Writer级别设置＃默认为删除功能类型第一个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，保留格式/标题等。）default_macro xlsxw_out_truncate_table_xlsxw_1 no xlsxw_1_truncate_table“$（xlsxw_out_truncate_table_xlsxw_1）”＃默认为写出字段名称default_macro xlsxW_OUT_FIELD_NAMES_OUT_XLSXW_1是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）” ＃============================================================================ ## opt in for目标数据集类型vs格式类型验证default_macro xlsxw_out_destination_datasettype_validation_xlsxw_1是xlsxw_1_destination_dataseTtype_validation“$（xlsxw_out_destination_datasettype_validation_dataseTtype_validation_xlsxw_1）”＃在wb中为导航树添加一个新的文本字段。Bug51426中有更多细节。default_macro template_sheet_xlsxw_1 gui可选文本templay_sheet_xlsxw_1模板表：xlsxw_1_template_sheet“$（template_sheet_xlsxw_1）”xlsxw_1_dataset“$（destdataset_xlsxw_1）”xlsxw_1_generate_fme_build_num 16664＃！end_dest_header＃！start_wb_header＃！end_wb_header＃！ END_HEADER LOG_FILENAME "$(FME_MF_DIR)WritingImagesToExcel-Updater.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 Auto FME_GEOMETRY_HANDLING Enhanced FME_STROKE_MAX_DEVIATION 0 MAPPING_FILE_ID WritingImagesToExcel DEFAULT_MACRO DATASET_KEYWORD_GML_1 GML_1 DEFAULT_MACRO DATASET_KEYWORD_XLSXW_1 XLSXW_1 # ------------------------------------------------------------------------- GML_1_READER_META_ATTRIBUTES fme_feature_type # ------------------------------------------------------------------------- MULTI_READER_CONTINUE_ON_READER_FAILURE No # ------------------------------------------------------------------------- MACRO WORKSPACE_NAME WritingImagesToExcel-Updater MACRO FME_VIEWER_APP fmedatainspector # ------------------------------------------------------------------------- GML_1_DEF FireHalls HallNumber xml_char(30) Name xml_char(30) Address xml_char(30) PhoneNumber xml_char(30) Engine xml_char(1) Ladder xml_char(1) Quint xml_char(1) Rescue xml_char(1) Medic xml_char(1) gml_pointProperty xml_geometry gml_multiPointProperty xml_geometry # ------------------------------------------------------------------------- FACTORY_DEF * RoutingFactory FACTORY_NAME "Router and Unexpected Input Remover" COMMAND_PARM_EVALUATION SINGLE_PASS MULTI_READER_KEYWORD $(DATASET_KEYWORD_GML_1) INPUT FEATURE_TYPE * ROUTE GML GML_1::FireHalls multi_reader_keyword,$(DATASET_KEYWORD_GML_1) TO FME_GENERIC ::FireHalls ALIAS_GEOMETRY MERGE_INPUT Yes OUTPUT ROUTED FEATURE_TYPE * GML_1_MERGE_DEF GML_1::FireHalls EXACT FireHalls # ------------------------------------------------------------------------- FACTORY_DEF * TeeFactory FACTORY_NAME "FireHalls (GML_1) Splitter" INPUT FEATURE_TYPE FireHalls OUTPUT FEATURE_TYPE FireHalls_GML_1 DEFAULT_MACRO WB_CURRENT_CONTEXT # ------------------------------------------------------------------------- # Wipe out the source setting if it was untouched from the default setting DEFAULT_MACRO Reprojector_SOURCE "Read from feature" INCLUDE [if { {Read from feature} == {Read from feature} } { puts {MACRO Reprojector_SOURCE} } ] FACTORY_DEF * TeeFactory FACTORY_NAME Reprojector INPUT FEATURE_TYPE FireHalls_GML_1 OUTPUT FEATURE_TYPE Reprojector_REPROJECTED @Reproject($(Reprojector_SOURCE),"LL-WGS84",NearestNeighbor,PreserveCells,Reprojector,"COORD_SYS_WARNING",RASTER_TOLERANCE,0.0) # ------------------------------------------------------------------------- FACTORY_DEF {*} AttrSetFactory FACTORY_NAME AttributeManager INPUT FEATURE_TYPE Reprojector_REPROJECTED MULTI_FEATURE_MODE NO NULL_ATTR_MODE NO_OP ATTRSET_CREATE_DIRECTIVES _PROPAGATE_MISSING_FDIV ACTION_COLUMN 3 DEF_VAL_COLUMN 2 ATTR_ACTION { "" "xlsx_row_id" " 计数 row_id 2 “”set_to“} attr_action {”“”xlsx_col_id“”5“”set_to“} attr_action {”“xlsx_raster_height”200“”set_to“} attr_action {”“xlsx_raster_width”200“”set_to“} attr_action {”“”_imageurl“”http： maps.gooleapis.com. 地图 API. staticmap？size = 值 xlsx_raster_width x 值 xlsx_raster_height. amp. Sensor = False. markers=color:red|size:mid|label:F| yvalue. XValue “”set_to“}输出输出_type attributemanager_output＃-----------------------------------------------------------------------------------------------------------------_attribute___tric_Attribute ___mer_image_filename_____image_filename___cname_def * teefactory factory_name imagefetper_gatherer输入feature_type attributemanager_output输出effect_type ___gathered___factory_def * httpfactory输入feature_type ___gathered___ target_url“@EvaluateExpression（FDIV，String_Encoded，值 _imageurl. ，ImageFetcher）“http_method get target_attr $（image_data_attribute）use_response_encoding no auth_method” “named_connection” “CONNECTION_TIMEOUT_LENGTH 60 TRANSFER_TIMEOUT_LENGTH 90 FOLLOW_REDIRECTS是VERIFY_SSL_CERTIFICATES是USE_COOKIES无RESPONSE_HEADER_LIST_ATTR ”_http_headers“ STATUS_CODE_ATTR ”_http_status_code“ ERROR_ATTR ”_http_error“ 输出端输出FEATURE_TYPE ___http_response___ FACTORY_DEF * TestFactory中FACTORY_NAME ImageFetcher_ResponseTester INPUT FEATURE_TYPE ___http_response___ TEST @Value（$（IMAGE_DATA_ATTRIBUTE））！= ”“ 的Passedfeature_type ___non_empty_response_____d proc imagefether_detect_content_type {} {if {[string比较{auto} {auto}] == 0} {set index [fme_execute searchlist“_http_headers {}。name”content-type“];如果{[string比较$索引“-1”]！= 0} {set mime [fme_getattribute“_http_headers {$ index} .value”];如果{[字符串匹配“图像/ * bmp *”$ mime“== 1} {return”bmp“} elsef {[字符串匹配“图像/ * gif *”$ mime“== 1} {return”gif“} elsef {[string匹配”图像/ * jpeg *“$ mime”== 1} {return“jpeg”} elsef {[字符串匹配“图像/ * png *”$ mime“== 1} {返回“png”} elsef {[string匹配'图像/ * tif *“$ mime”== 1} {return“tiff”} else {fme_setattribute“_http_error”[fme_getmessage 917355 imagefetcher $ mime];fme_logmessage fme_warn 917355 imagefetcher $ mime;返回“未知”;}否则{fme_settribute“_http_error”[fme_getmessage 917356 imagefetcher];fme_logmessage fme_warn 917356 imagefetcher;返回“未知”; } } else { return AUTO } } FACTORY_DEF * TestFactory FACTORY_NAME ImageFetcher_ContentTypeTester INPUT FEATURE_TYPE ___non_empty_response___ _____image_type_____ @Tcl2("ImageFetcher_detect_content_type") TEST @Value(_____image_type_____) != UNKNOWN OUTPUT PASSED FEATURE_TYPE ___has_content_type___ @Tcl2("FME_SetAttribute $(IMAGE_FILE_ATTRIBUTE) [FME_TempFilename ImageFetcher]") @File(DestWriteSrcRead,$(IMAGE_DATA_ATTRIBUTE),@Value($(IMAGE_FILE_ATTRIBUTE))) @RemoveAttributes($(IMAGE_DATA_ATTRIBUTE)) @RemoveAttributes(fme_regexp_match,^_http_headers{[0-9]+}.*$) @RemoveAttributes("_http_status_code","_http_error") @RemoveAttributes(fme_regexp_match,^fme*) @RemoveGeometry() FACTORY_DEF * QueryFactory FACTORY_NAME ImageFetcher_Reader INPUT FEATURE_TYPE ___has_content_type___ READER_TYPE @Value(_____image_type_____) READER_DATASET @Value($(IMAGE_FILE_ATTRIBUTE)) CONTINUE_ON_READER_ERROR YES READER_PARAMS DELETE_SOURCE_ON_CLOSE yes COMBINE_ATTRIBUTES PREFER_RESULT OUTPUT RESULT FEATURE_TYPE ImageFetcher_RASTER @RemoveAttributes($(IMAGE_FILE_ATTRIBUTE),_____image_type_____) @SupplyAttributes(fme_basename,ImageFetcher) # ------------------------------------------------------------------------- FACTORY_DEF * RoutingFactory FACTORY_NAME "Destination Feature Type Routing Correlator" COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE * ROUTE FME_GENERIC ImageFetcher_RASTER TO XLSXW __GO_TO_FINAL_OUTPUT_ROUTER__ multi_writer_id,0, 供应编码 __wb_out_feat_type__ Firehalls. 几何Feature_Type_attribute __WB_OUT_FEAT_TYPE__输出路由FEATURE_TYPE *输出NOT_ROUTED FEATURE_TYPE __NUKE_ME__ @ TCL2（“FME_STATMESSAGE 818059 [FME_GETATATRIBUTE FME_TEMPLACE_FEATURE_TYPE）818060 818061 FME_WARN”）＃ - - -----------------------------------------------------------------factory_def * teefactory factory_name“最终输出nuker”输入feature_type __nuke_me__＃---------------------------------------------------------------xlsx_field_col_out no xlsx_start_col“”xlsx_start_col“”xlsx_offset_crow“”xlsx_protect_sheet no xlsx_raster_type png xlsx_table_wrieter_mode更新xlsx_row_id_column xlsx_row_id hallnumber字符串（15，版本 1 number_format_string. font 字体颜色 background_color pattern_color pattern_style. text_alignment 没有水平对齐 vertical_alignment 缩进 text_orientation. text_control. cell_protection. 没有 hide_cells lock_cells. ）名称字符串（30，版本 1 number_format_string. font 字体颜色 background_color pattern_color pattern_style. text_alignment 没有水平对齐 vertical_alignment 缩进 text_orientation. text_control. cell_protection. 没有 hide_cells lock_cells. ）Address string(20,version 1 number_format_string. font 字体颜色 background_color pattern_color pattern_style. text_alignment 没有水平对齐 vertical_alignment 缩进 text_orientation. text_control. cell_protection. 没有 hide_cells lock_cells. ）phonenumber字符串（20，版本 1 number_format_string. font 字体颜色 background_color pattern_color pattern_style. text_alignment 没有水平对齐 vertical_alignment 缩进 text_orientation. text_control. cell_protection. 没有 hide_cells lock_cells. ）