CODEWITHSUNDEEP
apache-poiapache-nifi
user3520253
user3520253

Reputation: 65

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

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

Upvotes: 0

Views: 1224

Answers (1)

Dario Lurido
Dario Lurido

Reputation: 98

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

enter image description here

Upvotes: 0

Related Questions