How to convert a excel file to csv file using pipe ( "|") separator?

nirmalya.sarkar · August 13, 2021, 8:12am

Book1.xlsx (8.5 KB)
I have this excel worksheet.
My output should be - ( I have to show the output in notepad)

.

Guys, Please suggest any idea.
Regards,
Nirmalya Sarkar

ppr · August 13, 2021, 8:47am

readin excel with rwad range into a datable
write out csv file with write csv Activity

grafik
grafik

nirmalya.sarkar · August 13, 2021, 10:12am

@ppr , Thank you.

Regards,
Nirmalya Sarkar

system · August 16, 2021, 10:13am

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
Pipe Separate file in .xls Help	7	1130	July 3, 2019
Fast way to convert Excel sheet to CSV? Studio activities , question	1	672	July 22, 2020
Convert CSV to Excel with Modern Design Experience Studio studio , question , tools	4	1037	April 24, 2022
Convert excel to text file with pipe Help excel , selector , activities , question	1	1213	September 3, 2020
Convert CSV to Excel using ¶ as a delimiter Studio studio , question , activities_panel	10	629	April 20, 2023