Skip to main content
Question

How to create File folders from excel column

  • January 14, 2025
  • 5 replies
  • 54 views

tamadur
Contributor
Forum|alt.badge.img+2

I have Excel sheet with 2 fields, and I need to create folders with the values of the field 

5 replies

tomfriedl
Contributor
Forum|alt.badge.img+13
  • Contributor
  • January 14, 2025

You can use the SystemCaller to start Windows-Cmd:

Command:

cmd /k "md c:\temp\test2 & exit"

 


redgeographics
Celebrity
Forum|alt.badge.img+62

Do you just want to create folders, or also write data to them?


tamadur
Contributor
Forum|alt.badge.img+2
  • Author
  • Contributor
  • January 14, 2025

You can use the SystemCaller to start Windows-Cmd:

Command:

cmd /k "md c:\temp\test2 & exit"

 

thanks i will try 


tamadur
Contributor
Forum|alt.badge.img+2
  • Author
  • Contributor
  • January 14, 2025

Do you just want to create folders, or also write data to them?

yes, just empty files by names of values attribute 


tomfriedl
Contributor
Forum|alt.badge.img+13
  • Contributor
  • January 14, 2025

You can write Textfile’s. With the params

Write Last Line Terminator = no

Write UTF Byte Order Mark = no

will create files with 0 Byte. Missing folder create the writer automatically folder.