How to Convert Csv file to Excel

[Anonymous]

Hello,

I have a requirement wherein I have to convert CSV file to Excel (.xlsx). The file is getting converted but with incorrect data. 

Example, If in InputFile i.e CSV there is a row which contains a comma(,) then while loading the data in Excel file comma(,) is removed. 

I want data of csv as it is in excel file including all special characters/symbols.

I am using Talend Data Fabric 6.3.1 & Java 8 . Kindly check attached images of my job design. 

Job DesigntFileInputBasicSettingstFileInputAdvSettingstFileOutPutExcelSettings

SourceFileDataOutPut(xlsx)FileData

[manodwhb · Accepted solution]

@Vikas,you should get data for each and every coulmn in " " then you will not face any issue.if you have same delimiter as part of column value,you will not extract as per your requirement.

i am just showing,this will be help to you to understand.

Input data:-

col1,col2
"Hello"|"ABC"
"aass"|"CDF|AC"

[manodwhb]

@Vikas,still do you have the issue.

[manodwhb]

@Vikas,other way you can check Advanced sepaartor.

[Anonymous]

Thanks, @Manohar Escape char and Text enclosure settings solved the problem.