.xlsx to .txt Conversion

[AmarKr (Amar Kumar)]

Looking for the solution, which can convert .xlsx file into a .txt.

Regrads,
Amar Kr.

[Jan_Brian_Despi]

Hi @AmarKr

Please refer to this post:

Excel to Text conversion

HI @AmarKr Add an Excel Application Scope and add the excel path. Inside the scope, add a Read Range activity. Use Output Data Table activity to write a data table to a string using a CSV format. Use Write Text File activity to write the string in a text file. Hope this helps. Thanks and regards

Thanks and regards.

[Lahiru.Fernando]

Hi @AmarKr

I have created a sample workflow on a similar task to one of my friends in the forum and would like to share it with you… This also extracts data from the excel sheet and updates a notepad. You have the logic here. you my tweak it a bit so you can get your desired output…

ExcelToNotePad.xaml (8.8 KB)