topic Re: How to Convert Csv file to Excel in Talend Studio

How to Convert Csv file to Excel

Anonymous — Sat, 16 Nov 2024 08:18:18 GMT

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

Re: How to Convert Csv file to Excel

manodwhb — Mon, 07 May 2018 03:41:51 GMT

@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"

Re: How to Convert Csv file to Excel

manodwhb — Mon, 07 May 2018 10:43:57 GMT

@Vikas,still do you have the issue.

Re: How to Convert Csv file to Excel

manodwhb — Mon, 07 May 2018 11:04:42 GMT

@Vikas,other way you can check Advanced sepaartor.

Re: How to Convert Csv file to Excel

Anonymous — Wed, 09 May 2018 06:20:17 GMT

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