Convert xlsx file to text file

Hi Team,

I need to change xlsx file extension to text file with tab delimited. What is the best way to do it.

Hello Shashi123,

not sure if that’s the easiest and fastest way to accomplish:

have you tried following activity: https://connect.uipath.com/marketplace/components/balareva-xl-activities
The export function as far as I remember only translates into PDF, but you could always use PDF activities and write output into a txt file.

Let me know if you get it working.

There is a very easy way to do.
Just read your excel-file with read-range and write your datatable with “Write CSV file” to a file.
In settings select as delimiter the Tab.

image

1 Like