Showing results for 
Search instead for 
Did you mean: 

Time stamp and barcode into .xls spreadsheet

Go to solution
Hello, I am pretty new to programming in Labview and I have a few issues I need to get worked out. I am using a "Prompt User for Input" asking for a units barcode if there is a failure. So when the message prompts I have the user scan in a barcode and this needs to be sent to a .xls file. Numbers will go into the .xls file but the barcodes I am using have dashes(-) in them and when these barcodes get scanned Labview sends a zero to the spreadsheet. If I manually send numbers they will write to the spreadsheet. I also need a timestamp of when the barcode was scanned to get written to the spreadsheet as well.  Any suggestions?
0 Kudos
Message 1 of 4
Accepted by topic author Branderegg
It sounds like you should be setting the Prompt User input as a string instead of a numeric if you want to preserve the dashes. Use a Get Date/Time String function along with the prompt.
Message Edited by Dennis Knutson on 05-13-2009 12:18 PM
0 Kudos
Message 2 of 4



I believe you have become infected (by Express vi's, that is) 🙂


I have to be truthful, that is the one and only Express vi I have ever used.



"It’s the questions that drive us.”
0 Kudos
Message 3 of 4

To tell the truth, I've only really used the express Elapsed Time function in my programs. In this case, since the op was already using the express function, I really didn't see much reason to use anything else since the fix was just a right click option.

0 Kudos
Message 4 of 4