How to convert excel file to text file for sap format

[sathish_Kumar6 (sathish Kumar)]

i have one excel file and i want to convert that excel file to text file for sap for please find the attachment and sample format pics

Sample.txt (336 Bytes)
Sample (1).xlsx (10.1 KB)

[Vinit_Mhatre (BotBuilder)]

Hi @sathish_Kumar6 ,

I have built one sample flow base on your scenario
Main.xaml (12.3 KB)

Thanks,
Vinit Mhatre

[mkankatala (Mahesh Kankatala)]

Hi @sathish_Kumar6

=> Use Read Range Workbook to read the excel and store the data in a data table say dt. Make sure to remove Add Headers option.
=> Use the below syntax in Assign activity:

Output= String.Join(Environment.NewLine, dt.AsEnumerable().Select(Function(row) String.Join(vbTab, row.ItemArray.Select(Function(item) item.ToString()))))

=> Use Write Text File to write the data into text file.
Input:

Output:

Workflow:

xaml:
Main.xaml (7.1 KB)

Hope it helps!!
Regards