11-18-2008 12:38 PM
I'd like to be able to save recipes every four hours to an excel file without overwriting the previous entry. It would function as a "save as" button, but instead of inputting a new name, the recipe name along with the date and time is what the file would be saved as. Any thoughts on if this is possible or how it can be accomplished would be great.
Solved! Go to Solution.
11-19-2008 03:23 AM
Try the datatable.
I connect the recipe datamember to the datatable datamember. Create a counter to count a pulse signal(Timer1). The database filename = "d:\data"&Counter1&".xls". Its export = Timer1. Then, it will periodically export the data into the xls file. The data file name will change with the counter, such as data1.xls, data2.xls, etc.
You can use expression to get the date or time value, and add them in the file name. Or you can write the time value to the xls file.
11-20-2008 10:01 AM
11-20-2008 09:28 PM
For example, the file name is in C1.txt, just set Filename = "d:\"&Table1.C1.txt.
12-05-2017 08:42 PM
just put another row in the excel file, do not forget that the option that connects excel with NI application must be enabled.