(HELP) Enter data in excel using both text / menu ring

[Munkshire]

Hi, newbie to labview sorry if I am missing something basic.

I am trying to create a database and I wish to enter data into excel last line using both text fields and drop down list of pre set information, how can I implement this? I tried various arrays but I keep getting broken wires.

this is how I need the data entering.

COLUMN A

number, this will be inserted by a counter on labview that increases by 1 every time the .vi is run OR pre set number in the sheet that labview will grab ( more tricky )

COLUMN B

this will be a drop down list of fixed selections

COLUMN C

this will be a text field

COLUMN D

this will be the current date / time 

COLUMN E

this will be a drop down list of fixed selections

COLUMN F

this will be a text field that can contain any text

[cy...]

convert all to string before building the array

[Bob_Schor]

About eight years ago, I posted in this LabVIEW Forum a Revised "Generate Excel Report" Example.  Go to the Search Bar and type the words -- Revised "Generate -- and it should pop up.  Since you are mixing the data types that you are putting in the different columns, you may have to enter your values one cell at a time, but I think the Example shows how to do that.  What might be a little trickier is handling TimeStamp data, as LabVIEW and Excel store Date/Time data differently.  This has also been covered in the Forum, but I don't have the citation handy.

Bob Schor