Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Issue in ExcelToCsv NiFi processor

Highlighted

Issue in ExcelToCsv NiFi processor

Expert Contributor

Hello ,

 

I am using ExcelToCsv nifi processor for conversation of .xlsx files to csv file. Wants to convert bunch of .xlsx files which has data in different format to csv. Once the file get converted to csv ,data is getting changed as below.

 

FYI.

I have used below property values inside ExcelToCsv processor.

 

Refered ExcelToCsv nifi processor link 

 

CSV format:custom

Value separator : comma

Quote character : double quotes

Quote mode : Quote minimal

 

Here are few points where i observed data got changed.

17.90==>17.900000001
270E+11===> 270000000000

34,45,67,344===>344567344 : for third case,quote character does not get added.

 

Somebody please let us know why am i getting wrong results in csv ouput file?

 

How to solve this issue?Or  Is there any solution for excel to csv conversion?

Don't have an account?
Coming from Hortonworks? Activate your account here