Convert to text file

I want to convert excel to text file as below.

Please suggest me about this.

1 Like

Hello @fairymemay,

You can try this

  • Use Read Range and get output as outDataTable
  • Now use Output Datatable Activity and get the the output as outStr
  • you can pass outStr Variable to Write Text File Activity and pass the file path.


@Pradeep_Shiv How to set end indicates (net)?

1 Like

Do you want to group them by “Net”?

@Pradeep_Shiv I​ want​ copy​ net​ to​ column​ F.(red​ text)​