Write Spreadsheet To File even if path doesn't exist (yet)

[MrHappyAsthma]

I am interested in using Write Spreadsheet To File to log some data to my disk.  What is the easiest way to include this VI and tell it to create the folders if they don't already exist.

For example:

Using that example, if no "Data" folder can be found on my Desktop, how can I have LabVIEW create the "Data" and "Test1" folders necessary to create Test1.csv in the specified location?

[MrHappyAsthma · Accepted solution]

I ended up making a VI out of this community example https://decibel.ni.com/content/docs/DOC-23385

[wbadry2]

Is it possible to share your VI as I am unable to reach the link.Thanks

[billko]

Just use the Create Folder Function instead.

[crossrulz]

---

@wbadry2 wrote:

Is it possible to share your VI as I am unable to reach the link.Thanks

---

Examples got moved around fairly recently.  So I'm not surprised if the link doesn't work.  See if this fixes your issue.

[UliB]

Or use \vi.lib\Utility\libraryn.llb\Create Directory Recursive.vi

[crossrulz]

---

@UliB wrote:

Or use \vi.lib\Utility\libraryn.llb\Create Directory Recursive.vi

---

Which can now (at least as of 2019) be found in the File I/O->Advanced File Functions palette.

[billko]

So what's the difference between the Create Directory Recursive function and the Create Folder function?  They both seem to create the intermediate folders on the way to creating the target folder.  Curious as to why they both exist...