creating new file using report generation express vi

[r_te]

Hello,

In my application, I need to write certain data in excel sheet. For that I created an excel template and I used the express vi in report generation toolkit to save the appropriate data in appropritate columns. I need a new file created everyday by that day's name and write the data to it rest of the day. I am having problems creating new file using this express vi. I tried using the low level vi's but not been able to it properly.

Attaching my code and excel template.

Please help.

Thanks!

[Lourens]

Personally I would log to a comma or tab delimited (.CSV) file using "Write to Spreadsheet File.vi". It is simple to use and easy to append data. If an Excel file is required, you could read the previous day's CSV file and populate your Excel template. The CSV can then be deleted by you LabVIEW app.

[r_te]

Saving in excel is one of the requirements

[crossrulz]

You need to supply a file to the Express VI to tell it where to save the file.  Also check the "Configure to Save File Options" button in the Express VI's configuration dialog.

[r_te]

The thing is everyday there cannot be a file provided. I want the program to create a new file everyday. In my program I have already given the path where to create it. Is there any way I can get the program to create it?

And I did check those options, but there is no option to create a file if it doesnt exist

[crossrulz]

---

@r_te wrote:

The thing is everyday there cannot be a file provided.

---

Sure there can.  Don't you see the input on the Express VI for a file? "Path To Save Report" is the name of the input you want.

[r_te]

I am giving it a path input, it gives me an error saying file doesnt exit or have been moved.

[r_te]

Anyone??

[.aCe. · Accepted solution]

I suspect your problem is illegal characters ("/") in your file path, certainly that is the case in your original vi. You need to format your path, something like this (underscore instead of forward slash):

[r_te]

yeah finally got the hang of it. But now new problem. I cannot apeend data to it. It just overwrites