ConvertExcelToCSVProcessor of Apache nifi automatically convert year format from 'yyyy' to 'yy'

Question

I am designing flow using apache NIFI where I need to convert excel to CSV and then pass it to downstream system. For excel to CSV conversion I am using ConvertExcelToCSVProcessor and facing issue in date conversion where year is getting converted into short format from long i.e. from 'yyyy' to 'yy'.

I have d/m/yyyy format data available in excel

How to avoid such format changing while converting excel to CSV using apache nifi

Answer 1

I am working on a similar project, NiFi Excel to CSV, and the solution found is:

• set the property Format Cell Values to true
• force the format of cells to excel with the Format Cells function