05-13-2009 10:00 AM
I've got a LabVIEW library which is called by a higher level VI to create an excel workbook and/or save data to it. I have not yet written a sequence to save the file to disk, but could someone look over it and tell me what they think. I've initialised all the inputs with default data, so it should run okay. This library was the first bit of code I ever wrote in LabVIEW (concocted it from scratch too), so it may do things in a rather long winded way.
The 'Summary' sheet is currently just a duplicate of the 'Data' sheet since its content has not yet been finalised.
The 'New' and 'Save' boolean controls on the front panel create a new excel workbook with no data, and save data into the 'Data' sheet under the relevant temperature.
I am using Microsoft Excel (Version 10.0.6501.0), LabVIEW Development System (Version 6.1.0.4004), and Microsoft Windows XP Professional (Version 2002, Service pack 2). I say this because this library uses active-x controls, and I don't know how much is program version specific.
Thank you in advance.
James
05-14-2009 06:31 PM
05-18-2009 10:08 AM
05-18-2009 05:40 PM
Does not look bad at all to me. Please put a link to this thread on the excel board
Thanks,
07-15-2009 10:53 PM
07-15-2009 11:06 PM
marp84 wrote:
can i put date & time to excel?
Yes.
07-15-2009 11:47 PM
07-16-2009 03:43 AM - edited 07-16-2009 03:48 AM
You could use the 'Get Date/Time String', and then input the string into whichever cell in whichever sheet in whichever workbook in Excel you want. This is a static date/time, and doesn't change once it's been written into Excel.
You could also write a formula into a particular cell:
=TODAY() ...inserts the current date.
=NOW() ...inserts the current date and time.
These two values are updated whenever the worksheet is calculated, and are taken from the system clock.