09-22-2011 07:24 AM
I want to print time stamp every second to an excel sheet, tried 1000 of times to add row to the sheet but failed, any clue how to?
09-22-2011 07:30 AM
Here's a VI I wrote to open an excel sheet, and write the current timestamp to the active cell, after setting its cell format. You could edit this to write multiple values.
Regards,
09-22-2011 07:30 AM
You will need to use a loop, and increment the cell number each time you write.
Hope this helps.
09-22-2011 07:56 AM
thats the problem, i cant do it automatically
09-22-2011 08:09 AM
Why not? Can't you use the loop index to increment the cell position for each iteration?
09-22-2011 08:13 AM
That's because you're wiring the N value of the for-loop to the "column" element of the cell cluster, and you are wiring a constant of 1 to the "row" element of the cluster. You also have several issues with the code:
See attached modification as a starting point. You should also review the LabVIEW training materials. To learn more about LabVIEW it is recommended that you go through the introduction material, tutorial(s), and other material in the NI Developer Zone's Learning Center which provides links to other materials and other tutorials. There are also several Technical Resources. You can also take the online courses for free.
09-22-2011 09:10 AM
smercurio_fc wrote:
- Be aware that timestamps between LabVIEW and Excel are different, since they use different epochs. This has been discussed ad nauseam in these forums, so do a search and you will find out how to deal with this.
Or just wait a few seconds an Jeff will post a link to This idea (just like almost every time I see Time and Excel in a subject line)