Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am currently executing a db query and want to output it to a csv file however i want everything to be seperated via columns so it would be like an xlsx file.
The only reason i am not using tFileOutputXLSX is because i need the csv extension for some other use. How could i get it formatted similar to an xlsx file?
How would i be able to output a textractdelimitedFields into a csv file?
Hi, tFileOutputDelimited will do the job.
when you open a csv with excel , it will show the result like an excel file
Send me love and kudos
I am looking to have the csv file by default be the same as an excel sheet. I don't want to have to open it with excel to show the correct format.
Hello,
If you only output the xlsx and not the CSV, please have a look at tFileoutputExcel component.
Best regards
Sabrina