<extensionManifest><groupId>org.apache.nifi</groupId><artifactId>nifi-poi-nar</artifactId><version>1.22.0</version><systemApiVersion>1.22.0</systemApiVersion><buildInfo><tag>nifi-1.22.0-RC1</tag><branch>UNKNOWN</branch><revision>71e3ea9</revision></buildInfo><extensions><extension><name>org.apache.nifi.processors.poi.ConvertExcelToCSVProcessor</name><type>PROCESSOR</type><description>Consumes a Microsoft Excel document and converts each worksheet to csv. Each sheet from the incoming Excel document will generate a new Flowfile that will be output from this processor. Each output Flowfile's contents will be formatted as a csv file where the each row from the excel sheet is output as a newline in the csv file. This processor is currently only capable of processing .xlsx (XSSF 2007 OOXML file format) Excel documents and not older .xls (HSSF '97(-2007) file format) documents. This processor also expects well formatted CSV content and will not escape cell's containing invalid content such as newlines or additional commas.</description><tags><tag>excel</tag><tag>csv</tag><tag>poi</tag></tags><properties><property><name>extract-sheets</name><displayName>Sheets to Extract</displayName><description>Comma separated list of Excel document sheet names that should be extracted from the excel document. If this property is left blank then all of the sheets will be extracted from the Excel document. The list of names is case in-sensitive. Any sheets not specified in this value will be ignored. A bulletin will be generated if a specified sheet(s) are not found.</description><required>false</required><sensitive>false</sensitive><expressionLanguageSupported>true</expressionLanguageSupported><expressionLanguageScope>FLOWFILE_ATTRIBUTES</expressionLanguageScope><dynamicallyModifiesClasspath>false</dynamicallyModifiesClasspath><dynamic>false</dynamic></property><property><name>excel-extract-first-row</name><displayName>Number of Rows to Skip</displayName><description>The row number of the first row to start processing.Use this to skip over rows of data at the top of your worksheet that are not part of the dataset.Empty rows of data anywhere in the spreadsheet will always be skipped, no matter what this value is set to.</description><defaultValue>0</defaultValue><required>true</required><sensitive>false</sensitive><expressionLanguageSupported>true</expressionLanguageSupported><expressionLanguageScope>FLOWFILE_ATTRIBUTES</expressionLanguageScope><dynamicallyModifiesClasspath>false</dynamicallyModifiesClasspath><dynamic>false</dynamic></property><property><name>excel-extract-column-to-skip</name><displayName>Columns To Skip</displayName><description>Comma delimited list of column numbers to skip. Use the columns number and not the letter designation. Use this to skip over columns anywhere in your worksheet that you don't want extracted as part of the record.</description><required>false</required><sensitive>false</sensitive><expressionLanguageSupported>true</expressionLanguageSupported><expressionLanguageScope>FLOWFILE_ATTRIBUTES</expressionLanguageScope><dynamicallyModifiesClasspath>false</dynamicallyModifiesClasspath><dynamic>false</dynamic></property><property><name>excel-format-values</name><displayName>Format Cell Values</displayName><description>Should the cell values be written to CSV using the formatting applied in Excel, or should they be printed as raw values.</description><defaultValue>false</defaultValue><allowableValues><allowableValue><displayName>true</displayName><value>true</value><description></description></allowableValue><allowableValue><displayName>false</displayName><value>false</value><description></description></allowableValue></allowableValues><required>true</required><sensitive>false</sensitive><expressionLanguageSupported>false</expressionLanguageSupported><expressionLanguageScope>NONE</expressionLanguageScope><dynamicallyModifiesClasspath>false</dynamicallyModifiesClasspath><dynamic>false</dynamic></property><property><name>CSV Format</name><displayName>CSV Format</displayName><description>Specifies which "format" the CSV data is in, or specifies if custom formatting should be used.</description><defaultValue>custom</defaultValue><allowableValues><allowableValue><displayName>Custom Format</displayName><value>custom</value><description>The format of the CSV is configured by using the properties of this Controller Service, such as Value Separator</description></allowableValue><allowableValue><displayName>RFC 4180</displayName><value>rfc-4180</value><description>CSV data follows the RFC 4180 Specification defined at https://tools.ietf.org/html/rfc4180</description></allowableValue><allowableValue><displayName>Microsoft Excel</displayName><value>excel</value><description>CSV data follows the format used by Microsoft Excel</description></allowableValue><allowableValue><displayName>Tab-Delimited</displayName><value>tdf</value><description>CSV data is Tab-Delimited instead of Comma Delimited</description></allowableValue><allowableValue><displayName>MySQL Format</displayName><value>mysql</value><description>CSV data follows the format used by MySQL</description></allowableValue><allowableValue><displayName>Informix Unload</displayName><value>informix-unload</value><description>The format used by Informix when issuing the UNLOAD TO file_name command</description></allowableValue><allowableValue><displayName>Informix Unload Escape Disabled</displayName><value>informix-unload-csv</value><description>The format used by Informix when issuing the UNLOAD TO file_name command with escaping disabled</description></allowableValue></allowableValues><required>true</required><sensitive>false</sensitive><expressionLanguageSupported>false</expressionLanguageSupported><expressionLanguageScope>NONE</expressionLanguageScope><dynamicallyModifiesClasspath>false</dynamicallyModifiesClasspath><dynamic>false</dynamic></property><property><name>Value Separator</name><displayName>Value Separator</displayName><description>The character that is used to separate values/fields in a CSV Record. If the property has been specified via Expression Language but the expression gets evaluated to an invalid Value Separator at runtime, then it will be skipped and the default Value Separator will be used.</description><defaultValue>,</defaultValue><required>true</required><sensitive>false</sensitive><expressionLanguageSupported>true</expressionLanguageSupported><expressionLanguageScope>FLOWFILE_ATTRIBUTES</expressionLanguageScope><dynamicallyModifiesClasspath>false</dynamicallyModifiesClasspath><dynamic>false</dynamic><dependencies><dependency><propertyName>CSV Format</propertyName><propertyDisplayName>CSV Format</propertyDisplayName><dependentValues><dependentValue>custom</dependentValue></dependentValues></dependency></dependencies></property><property><name>Include Header Line</name><displayName>Include Header Line</displayName><description>Specifies whether or not the CSV column names should be written out as the first line.</description><defaultValue>true</defaultValue><allowableValues><allowableValue><displayName>true</displayName><value>true</value><description></description></allowableValue><allowableValue><displayName>false</displayName><value>false</value><description></description></allowableValue></allowableValues><required>true</required><sensitive>false</sensitive><expressionLanguageSupported>false</expressionLanguageSupported><expressionLanguageScope>NONE</expressionLanguageScope><dynamicallyModifiesClasspath>false</dynamicallyModifiesClasspath><dynamic>false</dynamic></property><property><name>Quote Character</name><displayName>Quote Character</displayName><description>The character that is used to quote values so that escape characters do not have to be used. If the property has been specified via Expression Language but the expression gets evaluated to an invalid Quote Character at runtime, then it will be skipped and the default Quote Character will be used.</description><defaultValue>"</defaultValue><required>true</required><sensitive>false</sensitive><expressionLanguageSupported>true</expressionLanguageSupported><expressionLanguageScope>FLOWFILE_ATTRIBUTES</expressionLanguageScope><dynamicallyModifiesClasspath>false</dynamicallyModifiesClasspath><dynamic>false</dynamic><dependencies><dependency><propertyName>CSV Format</propertyName><propertyDisplayName>CSV Format</propertyDisplayName><dependentValues><dependentValue>custom</dependentValue></dependentValues></dependency></dependencies></property><property><name>Escape Character</name><displayName>Escape Character</displayName><description>The character that is used to escape characters that would otherwise have a specific meaning to the CSV Parser. If the property has been specified via Expression Language but the expression gets evaluated to an invalid Escape Character at runtime, then it will be skipped and the default Escape Character will be used. Setting it to an empty string means no escape character should be used.</description><defaultValue>\</defaultValue><required>true</required><sensitive>false</sensitive><expressionLanguageSupported>true</expressionLanguageSupported><expressionLanguageScope>FLOWFILE_ATTRIBUTES</expressionLanguageScope><dynamicallyModifiesClasspath>false</dynamicallyModifiesClasspath><dynamic>false</dynamic><dependencies><dependency><propertyName>CSV Format</propertyName><propertyDisplayName>CSV Format</propertyDisplayName><dependentValues><dependentValue>custom</dependentValue></dependentValues></dependency></dependencies></property><property><name>Comment Marker</name><displayName>Comment Marker</displayName><description>The character that is used to denote the start of a comment. Any line that begins with this comment will be ignored.</description><required>false</required><sensitive>false</sensitive><expressionLanguageSupported>true</expressionLanguageSupported><expressionLanguageScope>FLOWFILE_ATTRIBUTES</expressionLanguageScope><dynamicallyModifiesClasspath>false</dynamicallyModifiesClasspath><dynamic>false</dynamic><dependencies><dependency><propertyName>CSV Format</propertyName><propertyDisplayName>CSV Format</propertyDisplayName><dependentValues><dependentValue>custom</dependentValue></dependentValues></dependency></dependencies></property><property><name>Null String</name><displayName>Null String</displayName><description>Specifies a String that, if present as a value in the CSV, should be considered a null field instead of using the literal value.</description><required>false</required><sensitive>false</sensitive><expressionLanguageSupported>false</expressionLanguageSupported><expressionLanguageScope>NONE</expressionLanguageScope><dynamicallyModifiesClasspath>false</dynamicallyModifiesClasspath><dynamic>false</dynamic><dependencies><dependency><propertyName>CSV Format</propertyName><propertyDisplayName>CSV Format</propertyDisplayName><dependentValues><dependentValue>custom</dependentValue></dependentValues></dependency></dependencies></property><property><name>Trim Fields</name><displayName>Trim Fields</displayName><description>Whether or not white space should be removed from the beginning and end of fields</description><defaultValue>true</defaultValue><allowableValues><allowableValue><displayName>true</displayName><value>true</value><description></description></allowableValue><allowableValue><displayName>false</displayName><value>false</value><description></description></allowableValue></allowableValues><required>true</required><sensitive>false</sensitive><expressionLanguageSupported>false</expressionLanguageSupported><expressionLanguageScope>NONE</expressionLanguageScope><dynamicallyModifiesClasspath>false</dynamicallyModifiesClasspath><dynamic>false</dynamic><dependencies><dependency><propertyName>CSV Format</propertyName><propertyDisplayName>CSV Format</propertyDisplayName><dependentValues><dependentValue>custom</dependentValue></dependentValues></dependency></dependencies></property><property><name>Quote Mode</name><displayName>Quote Mode</displayName><description>Specifies how fields should be quoted when they are written</description><defaultValue>NONE</defaultValue><allowableValues><allowableValue><displayName>Quote All Values</displayName><value>ALL</value><description>All values will be quoted using the configured quote character.</description></allowableValue><allowableValue><displayName>Quote Minimal</displayName><value>MINIMAL</value><description>Values will be quoted only if they are contain special characters such as newline characters or field separators.</description></allowableValue><allowableValue><displayName>Quote Non-Numeric Values</displayName><value>NON_NUMERIC</value><description>Values will be quoted unless the value is a number.</description></allowableValue><allowableValue><displayName>Do Not Quote Values</displayName><value>NONE</value><description>Values will not be quoted. Instead, all special characters will be escaped using the configured escape character.</description></allowableValue></allowableValues><required>true</required><sensitive>false</sensitive><expressionLanguageSupported>false</expressionLanguageSupported><expressionLanguageScope>NONE</expressionLanguageScope><dynamicallyModifiesClasspath>false</dynamicallyModifiesClasspath><dynamic>false</dynamic><dependencies><dependency><propertyName>CSV Format</propertyName><propertyDisplayName>CSV Format</propertyDisplayName><dependentValues><dependentValue>custom</dependentValue></dependentValues></dependency></dependencies></property><property><name>Record Separator</name><displayName>Record Separator</displayName><description>Specifies the characters to use in order to separate CSV Records</description><defaultValue>\n</defaultValue><required>true</required><sensitive>false</sensitive><expressionLanguageSupported>false</expressionLanguageSupported><expressionLanguageScope>NONE</expressionLanguageScope><dynamicallyModifiesClasspath>false</dynamicallyModifiesClasspath><dynamic>false</dynamic><dependencies><dependency><propertyName>CSV Format</propertyName><propertyDisplayName>CSV Format</propertyDisplayName><dependentValues><dependentValue>custom</dependentValue></dependentValues></dependency></dependencies></property><property><name>Include Trailing Delimiter</name><displayName>Include Trailing Delimiter</displayName><description>If true, a trailing delimiter will be added to each CSV Record that is written. If false, the trailing delimiter will be omitted.</description><defaultValue>false</defaultValue><allowableValues><allowableValue><displayName>true</displayName><value>true</value><description></description></allowableValue><allowableValue><displayName>false</displayName><value>false</value><description></description></allowableValue></allowableValues><required>true</required><sensitive>false</sensitive><expressionLanguageSupported>false</expressionLanguageSupported><expressionLanguageScope>NONE</expressionLanguageScope><dynamicallyModifiesClasspath>false</dynamicallyModifiesClasspath><dynamic>false</dynamic><dependencies><dependency><propertyName>CSV Format</propertyName><propertyDisplayName>CSV Format</propertyDisplayName><dependentValues><dependentValue>custom</dependentValue></dependentValues></dependency></dependencies></property></properties><relationships><relationship><name>original</name><description>Original Excel document received by this processor</description><autoTerminated>false</autoTerminated></relationship><relationship><name>success</name><description>Excel data converted to csv</description><autoTerminated>false</autoTerminated></relationship><relationship><name>failure</name><description>Failed to parse the Excel document</description><autoTerminated>false</autoTerminated></relationship></relationships><writesAttributes><writesAttribute><name>sheetname</name><description>The name of the Excel sheet that this particular row of data came from in the Excel document</description></writesAttribute><writesAttribute><name>numrows</name><description>The number of rows in this Excel Sheet</description></writesAttribute><writesAttribute><name>sourcefilename</name><description>The name of the Excel document file that this data originated from</description></writesAttribute><writesAttribute><name>convertexceltocsvprocessor.error</name><description>Error message that was encountered on a per Excel sheet basis. This attribute is only populated if an error was occured while processing the particular sheet. Having the error present at the sheet level will allow for the end user to better understand what syntax errors in their excel doc on a larger scale caused the error.</description></writesAttribute></writesAttributes></extension></extensions></extensionManifest>