OK, it won't be too difficult. Here are some observations:
- The .csv is, of course, entirely a text file. You specify the precision when you write it. In particular, your Time column shows "time" in minutes, so you have multiple lines having exactly the same time. You can change how Time is saved by specifying that you want a Custom Time Format and specifying HH:MM:SS. I also recommend that you choose 24-hour, so as not to have to contend with AM and PM, and the confusion of Noon and Midnight. So modify the program that creates the .csv file.
- LabVIEW and Excel save TimeStamps using different "rules". But you are working with the "text" representation of the TimeStamp, where the text format can be "common" to both. Everything in your Excel file is considered as Text, and will be formatted according to Excel's general rules, unless you override them. Again, the Time entry will be the Problem Child.
Open your .csv file with Excel. Notice that the Date/Time column shows ########. If you widen it, it will show multiple lines with 6/12/2023 15:05 (because you aren't saving seconds). Even if you were saving seconds, the default Excel format wouldn't show them. So you need a "Custom Format".
Right-click the column header, "A", and choose "Format Cells". Choose Custom. Scan down until you find "m/d/yyyy h:mm". Right-click to select it, and in the "Edit box" on top of the list of choices, add ":ss" and click "OK". The seconds values will appear (they'll be ":00", of course, because you didn't save seconds, see above).
OK, we're almost done. We discussed what you need to do to your Data Generating program to get seconds added to the saved Time, and discussed how to change your "Template" file to allow you to see the seconds when you create an Excel .xlsx version of your .csv data. So the last step is getting Excel to save the data from the .csv file.
It is pretty simple. Pretend you are going to write a new Excel file "from scratch", as shown in the "Generate Excel Report" example. Notice the fourth Input (just above Error In), called "template (empty)". Wire the path to your Template file (which you called "Excel Burn In with limits.xlsx"). It will open, and be available for you to write into it. But don't worry, we are not going to modify the Template -- when the time comes to write, we will use "Save Report to File" and specify the "real" name we want to use for the .xlsx file, e.g. "Burn In #245.xlsx".
Bob Schor
