| <?xml version="1.0" encoding="UTF-8"?> |
| <!-- |
| |
| Licensed to the Apache Software Foundation (ASF) under one or more |
| contributor license agreements. See the NOTICE file distributed with |
| this work for additional information regarding copyright ownership. |
| The ASF licenses this file to You under the Apache License, Version 2.0 |
| (the "License"); you may not use this file except in compliance with |
| the License. You may obtain a copy of the License at |
| |
| http://www.apache.org/licenses/LICENSE-2.0 |
| |
| Unless required by applicable law or agreed to in writing, software |
| distributed under the License is distributed on an "AS IS" BASIS, |
| WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. |
| See the License for the specific language governing permissions and |
| limitations under the License. |
| |
| --> |
| <pipeline> |
| <info> |
| <name>0003-write-xlsx</name> |
| <name_sync_with_filename>Y</name_sync_with_filename> |
| <description/> |
| <extended_description/> |
| <pipeline_version/> |
| <pipeline_type>Normal</pipeline_type> |
| <parameters> |
| </parameters> |
| <capture_transform_performance>N</capture_transform_performance> |
| <transform_performance_capturing_delay>1000</transform_performance_capturing_delay> |
| <transform_performance_capturing_size_limit>100</transform_performance_capturing_size_limit> |
| <created_user>-</created_user> |
| <created_date>2021/01/05 12:59:57.065</created_date> |
| <modified_user>-</modified_user> |
| <modified_date>2021/01/05 12:59:57.065</modified_date> |
| <key_for_session_key/> |
| <is_key_private>N</is_key_private> |
| </info> |
| <notepads> |
| </notepads> |
| <order> |
| <hop> |
| <from>Generate rows</from> |
| <to>Fake data</to> |
| <enabled>Y</enabled> |
| </hop> |
| <hop> |
| <from>Fake data</from> |
| <to>Microsoft Excel writer</to> |
| <enabled>Y</enabled> |
| </hop> |
| </order> |
| <transform> |
| <name>Fake data</name> |
| <type>Fake</type> |
| <description/> |
| <distribute>Y</distribute> |
| <custom_distribution/> |
| <copies>1</copies> |
| <partitioning> |
| <method>none</method> |
| <schema_name/> |
| </partitioning> |
| <locale>en</locale> |
| <fields> |
| <field> |
| <name>name</name> |
| <type>Name</type> |
| <topic>fullName</topic> |
| </field> |
| <field> |
| <name>number</name> |
| <type>Number</type> |
| <topic>randomNumber</topic> |
| </field> |
| </fields> |
| <attributes/> |
| <GUI> |
| <xloc>440</xloc> |
| <yloc>188</yloc> |
| </GUI> |
| </transform> |
| <transform> |
| <name>Generate rows</name> |
| <type>RowGenerator</type> |
| <description/> |
| <distribute>Y</distribute> |
| <custom_distribution/> |
| <copies>1</copies> |
| <partitioning> |
| <method>none</method> |
| <schema_name/> |
| </partitioning> |
| <fields> |
| </fields> |
| <limit>10</limit> |
| <never_ending>N</never_ending> |
| <interval_in_ms>5000</interval_in_ms> |
| <row_time_field>now</row_time_field> |
| <last_time_field>FiveSecondsAgo</last_time_field> |
| <attributes/> |
| <GUI> |
| <xloc>270</xloc> |
| <yloc>188</yloc> |
| </GUI> |
| </transform> |
| <transform> |
| <name>Microsoft Excel writer</name> |
| <type>TypeExitExcelWriterTransform</type> |
| <description/> |
| <distribute>Y</distribute> |
| <custom_distribution/> |
| <copies>1</copies> |
| <partitioning> |
| <method>none</method> |
| <schema_name/> |
| </partitioning> |
| <header>Y</header> |
| <footer>N</footer> |
| <makeSheetActive>Y</makeSheetActive> |
| <rowWritingMethod>overwrite</rowWritingMethod> |
| <startingCell>A1</startingCell> |
| <appendOmitHeader>N</appendOmitHeader> |
| <appendOffset>0</appendOffset> |
| <appendEmpty>0</appendEmpty> |
| <rowWritingMethod>overwrite</rowWritingMethod> |
| <forceFormulaRecalculation>N</forceFormulaRecalculation> |
| <leaveExistingStylesUnchanged>N</leaveExistingStylesUnchanged> |
| <appendLines>N</appendLines> |
| <add_to_result_filenames>Y</add_to_result_filenames> |
| <file> |
| <name>${PROJECT_HOME}/files/exelwriter-testfile</name> |
| <extention>xlsx</extention> |
| <do_not_open_newfile_init>N</do_not_open_newfile_init> |
| <split>N</split> |
| <add_date>N</add_date> |
| <add_time>N</add_time> |
| <SpecifyFormat>N</SpecifyFormat> |
| <date_time_format/> |
| <sheetname>Sheet1</sheetname> |
| <autosizecolums>N</autosizecolums> |
| <stream_data>N</stream_data> |
| <protect_sheet>N</protect_sheet> |
| <password>Encrypted </password> |
| <protected_by/> |
| <splitevery>0</splitevery> |
| <if_file_exists>new</if_file_exists> |
| <if_sheet_exists>new</if_sheet_exists> |
| </file> |
| <template> |
| <enabled>N</enabled> |
| <sheet_enabled>N</sheet_enabled> |
| <filename>template.xls</filename> |
| <sheetname/> |
| <hidden>N</hidden> |
| </template> |
| <fields> |
| <field> |
| <name>name</name> |
| <type>String</type> |
| <format/> |
| <title>name</title> |
| <titleStyleCell/> |
| <styleCell/> |
| <commentField/> |
| <commentAuthorField/> |
| <formula>N</formula> |
| <hyperlinkField/> |
| </field> |
| <field> |
| <name>number</name> |
| <type>String</type> |
| <format/> |
| <title>number</title> |
| <titleStyleCell/> |
| <styleCell/> |
| <commentField/> |
| <commentAuthorField/> |
| <formula>N</formula> |
| <hyperlinkField/> |
| </field> |
| </fields> |
| <attributes/> |
| <GUI> |
| <xloc>610</xloc> |
| <yloc>187</yloc> |
| </GUI> |
| </transform> |
| <transform_error_handling> |
| </transform_error_handling> |
| <attributes/> |
| </pipeline> |