Generating Date Time Stamped Excel Sheet

[mimran]

Hi

I am working on Data Logging project and requirement is to log data data to excel sheet at one per second. Moreover the name of excel sheet should be automatic date time stamp generated. Can anybody help me in generating datetime stamp file name for this file which I have downloaded from ni website.

Thanks

[MikeS81 · Accepted solution]

Hi mimran,

you can use the "Get Date/Time in Seconds" function. Create a string from this data and use it as the path for your file.

Mike

[RavensFan]

Your program does not create an Excel File.  It creates a text file that Excel is able to open up and import.

As it is right now, the name of the file you create is  determined by a dialog box that pops up with the old version of the Open/Create/Replace file that you have.  If you want the program to determine the file name, you need to build a file path out of string data in the same manner you are using the string coming from the Get Date/Time String function you have inside the loop.

Message Edited by Ravens Fan on 04-25-2010 02:59 PM

[arrowminds]

Thanks Mike.