Create text files for each row of excel file with dynamic names

Help
,
1

Hey guys,
I want to select each row in the excel file. Excel.xlsx (9.3 KB) and create separate (.txt) text file for each row in format. Please do share a solution.

Thank you.

2

This will do it for you.

CreateTextFiles.zip (9.3 KB)

Reading each row and assigning the values to individual variables.

You can then create a text file for each and using vbNewLine to split the data into the format you need.

1 Like
3

Thanks a lot @ronanpeter
Can these .txt files be zipped using Uipath.

4

Yes, download this package of actvities to zip the files. Easier to place them in a folder then zip the folder outside the ForEach loop at the very end of the workflow.

image

6

Hey, @ronanpeter
Can these (.txt) files be stored in a new folder of our choice.

1 Like
7

Here you are, the files placed in their own folder - the folder then zipped at the end.

Ensure you import the following namespace to your imports to allow the code to work:

image
image923×195 10.7 KB

CreateTextFilesWithZip.zip (9.7 KB)

2 Likes
8

Thanks a lot @ronanpeter. It works fine.

9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.