topic Re: How to output the data in excel from CSV in Talend Studio

How to output the data in excel from CSV

Anonymous — Thu, 30 Jan 2020 09:42:23 GMT

I'm using tFileOutputDelimited to output the data in CSV to reduce load time, but CSV prints some text errors, to what should i connect it so the data can be converted to xlsx?

Re: How to output the data in excel from CSV

manodwhb — Thu, 30 Jan 2020 11:08:21 GMT

@Sieg, if you want to read the data from CSV and write it to Excel,you need to design job in below way. if you try to use other component your output file will corrupted.

tFileInputDelimitted>>Row>>Main>>tFileoutputExcel

Re: How to output the data in excel from CSV

Anonymous — Thu, 30 Jan 2020 12:04:46 GMT

Hi, thanx for the help, that did the trick, is it possible to only output the xlsx and not the CSV? its currently outputing both

Re: How to output the data in excel from CSV

manodwhb — Thu, 30 Jan 2020 12:22:39 GMT

@Sieg , I did not understand your issue can you share your job design and explain your issue.

Re: How to output the data in excel from CSV

Anonymous — Thu, 30 Jan 2020 13:46:40 GMT

Hi, i only want to output the "output_xlsx", instead it still outputs the "output_csv" too. Is it possible?

output_csv.csv
output_xlsx.xls

Re: How to output the data in excel from CSV

manodwhb — Fri, 31 Jan 2020 06:23:51 GMT

@Sieg ,can you share your job design?

Re: How to output the data in excel from CSV

Anonymous — Fri, 31 Jan 2020 08:46:07 GMT

Hi, yes thank you

Annotation 4.png

Re: How to output the data in excel from CSV

manodwhb — Fri, 31 Jan 2020 11:36:01 GMT

@Sieg , you need to generate only xls file then remove tFileoutputdelimited or deactivate it.