this new CSV file basically has the same content/formatting as the one attached at the start of this thread.
So also my suggestion from message #3 still applies…
(The only difference in the new CSV file is the additional (but empty) column due to those trailing comma in each line/row!)
Is this what you expect to see? [I did this quickly, so the time is "elapsed time" since the start of the data ...]
quick adaption of my previous suggestion:
Using just the "nice" part of your data to determine the dt…
Your latest CSV is still malformed, see the last lines in the file:
1/11/2019 8:59,349.78, 1/11/2019 8:59,359.3, 1/11/2019 8:59,361.73, 1/11/2019 8:59,355.94, 1/11/2019 9:00,381.69, 1/11/2019 9:00,392.2, 1/11/2019 9:00,390.48, 1/11/2019 9:00,385.22, 2/11/2019 9:00,394.93, 3/11/2019 9:00,405.88, ,,
The last line contains empty cells.
There are still empty cells in column 2.
The two lines before the last line contain just one sample per day, while the data before are sampled at 4 samples per minute. This will give "not so nice" looking graphs and makes it harder to use waveforms…
Recommendation: Save the data using more precision in the timestamps!
Hello guys need help with xy graph which read from the excel file and able to prompt the ambient temperature and also the irradiance(w/m^2) respectively in a single program using only 8-9am data. I have attached an excel file below. Thank You!
You have previously created a trend on this from the LabVIEW forums https://forums.ni.com/t5/LabVIEW/read-from-excel-and-plot-xy-graph/td-p/3992256/page/2
Bob and Gerd have previously posted the solutions for your problem when I look through the trend...
Do refer to this link here I attached https://knowledge.ni.com/KnowledgeArticleDetails?id=kA00Z000000PAiESAW&l=en-SG
Attached the VI and detail what problem you are facing with the VI instead so that we could help you from there...
I suggest you get a firm understanding of the basics of LabVIEW first before attempting on writing a VI....