Skip to main content
Question

How to create File folders from excel column

  • January 14, 2025
  • 5 replies
  • 34 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+49

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
tomfriedl wrote:

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
redgeographics wrote:

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.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings