Create an excel file

[dilge]

Hello everyone,

I have searched the whole forum discussions about this and I don't think any of those responds to my needs. I basically need to create a .xlsx file in a specific name and path that I will specify and that's it. I don't want to overwrite or copy or anything, I just want to create an excel file out of nowhere.

THANKS!

[GerdW]

Hi dilge,

what have you tried?

Where are you stuck?

Did you get any errors?

Suggestion: use RGT functions to create your XLSX file. RGT (ReportGenerationToolkit) comes with example VIs!

(Cheap solution: use WriteMeasurementFile ExpressVI to create your XLSX.)

[dilge]

This is my VI:

This is the error:

I also get the following error:

[GerdW]

Hi dilge,

This is my VI

There is no VI, just an image…

This is the error

How is this error related to not being able to provide a filepath as written in your first message?

Did you check any of the reasons given in the error message?

Why do you need to write any data into the XLSX file when you just want to create it?

As you didn't attach your VI we cannot check this for you. Try your best!

I also get the following error:

When you want to create a new file then you should not provide its path for template usage!

[dilge]

Okay, now the VI is attached. It also writes the data to a specific worksheet, I used to use this as a subVI for saving data, but I forgot how to create an excel file in the first place so I cannot use this now.

[dilge · Accepted solution]

OKAY, I got it handled. I shouldn't have used the template input for file path, you were right. 🙂 THANK YOU