12-05-2018 12:24 AM
Hello,
I am trying to save time with data in MS excel sheet. I am using "File I/O > Write to measurement file" option. But can't succeed. I have attached a picture of setting. Any suggestion would be appreciated.
Solved! Go to Solution.
12-05-2018 12:36 AM
Hi Milon,
I am using "File I/O > Write to measurement file" option. But can't succeed.
Where are you trying to save "time with data"? All you do is using a tmestamp for filename creation…
I guess you want to have a column with timestamps in your Excel sheet!?
Any suggestion would be appreciated.
Do you know the problem with using ExpressVIs? (Apart from DDT wires?)
They only support exactly the functionality they are made for!
When you want to achieve goals with functions not included in ExpressVIs you need to get rid of those ExpressVIs and create your own tool…
12-05-2018 12:47 AM
Hello Mr. GerdW,
Greetings. Sorry for my poor explanation. Yes I want a column with timestamps along with data column in my excel sheet. Is it possible using 'write to measurement file.VI'?
If not, I have attached another picture here related with data saving with time. But can't understand instructions, specially 3 and 4.
12-05-2018 04:04 AM
12-05-2018 11:22 PM
Hi Mr. GerdW,
Would you please suggest any simple way to do it (data with time)?
12-06-2018 07:47 AM
12-06-2018 08:11 AM
Actually, the express vi can be configured to add a time column and even supports changing the time format
And the novice that wrote that example did not know that Format Date Time has a format specifier input
%y - Year within century (0-99)
%j - Julian date (0-366)
%H - Hour (0-23)
%M - Minute (0-60)
No special characters!
12-06-2018 08:19 AM
12-06-2018 08:36 AM
@GerdW wrote:
Hi Jeff,
thanks for your correction.
(Maybe I should lower my bias against ExpressVIs to notice their capabilities…)
I wouldn't want you to lower your bias. The Write Measurement File Express vi still uses the dreaded DDT and hides a whole lot of configuration information that can't be debugged from a *.jpg
12-06-2018 09:30 AM
Express VI's are only there for those 2 hour LabVIEW classes sales pitches to show managers and other non programmers how you can "just throw something together" in LabVIEW without knowing anything.
But in real world applications Express VI's fail more often than not.