I'm collecting serial data (from an RS232 port), and want to write it to a spreadsheet. I've been working on this problem for a few days (have been stumbling, and haven't found any related posts), and have some formatting issues. I'm thinking I need to create an array for the headings, and another for the data? I've been having issues with data type errors, and I need some help. The results should look something like this...
What's the best way to do this?
Thanks. I have a specific question, and then a general one. Where can I find this? And, is there some sort of document that shows all LabVIEW images, and where to find them (i.e. - where in the Functions menus)?
That's simply an Array Constant of Strings that I made.
p.s.: The word "Header" above the original constant is the Label, which I named "Header".
Got it - easy peasy one, two, threesy. I haven't used LabVIEW for about year, and I already forgot that - alzheimer's moment.
Another question. How do I format the date/time data going into excel? I'm using "%Y%b%d" for the date (result is an integer); and "%H:%M:%S" for the time (result is an integer). LabVIEW indicators display formatting appropriately. There must be something happening when the data gets moved into the spreadsheet - BTW, I opened the file in excel and notepad - same formatting.
Yet another thing. Is there a way to set up the serial data capture (and importation into a spreadsheet) to occur indefinitely (without a For-loop restriction)? And, what would the reason be for the date/time/data to be offset by one column, in relation to the header?
Figured out the offset - it was how I had the date/time/data array arranged. Haven't figured out the endless read part yet.