Convert .xlsx to .txt file

What is the best way to convert an .xlsx file to .txt?

i have an excel file with over 100 lines of data that need to be converted into one text file

@john.gordon

Use Read Range Workbook and store it as datatable
Use Output datatable activity store in a String
Use Write Text file activity to write the text into a Notepad file pass the string variable

Hi @john.gordon

=> Read Range Workbook
Output: dtExcelData

=> Set Variable value activity:

OutputText = String.Join(Environment.NewLine, dtExcelData.AsEnumerable().Select(Function(row) String.Join(",", row.ItemArray)))

=> Write Text File

Regards

1 Like

Hi @john.gordon

May be below image will help you.

If you find the solution for your query, please mark my post as solution to close the loop. or if you have any questions, Iā€™m happy to help you.

Regards

Please remember, this output text will be depends on the read rage what we select in DataTable.