How do I write multiple clusters to excel?

[lizimunro]

Hi Folks,

I have got a listbox that contains a list of tests selected from another listbox. When the user clicks on these tests that have been added to the listbox (Selected Tests) , they can then enter a series of test settings per item. These test settings are stored in numeric clusters.  The idea is that the user will be able to add values to these controls and then save them to file by clicking a save button. Or if the user already has the values saved then they will be able to import them to the controls via a load button.

Can someone offer me advice as to how to go about saving the values to file. I am assuming an excel file would be best as it would need to be 2D - the listbox items against the test values. I have tried to wire the clusters to the write to excel file vi when the save button is pressed but haven't had much luck as it says something about not being able to wire to a polymorphic source.

Apologies if the explanation does not appear to be clear. I have attached my working vi if that helps more.

Thanks Liz 🙂

[Pnt]

Saving in excel format, can be a little complicated.

I would suggest to save your data in a spreadsheet. There are examle vis in Labview examples.

Excel can open a spreadsheet  file if needed..

[Pnt]

this may help too..

http://forums.ni.com/ni/board/message?board.id=170&thread.id=321361

[lizimunro]

Thanks 🙂

I have tried to output all the test settings to spreadsheet and whilst I can get all the data I require to be output. I cannot get it into a meaningful order so it can be loaded again at another time. I need to have the selected tests down the left hand column and then the corresponding test values for each of those tests in horizontal rows.

If anyone can suggest how I can organise the data into columns etc or add headers I would be sooooooo greateful!

I have attached my working vi and also a spreadsheet file of how I wish it to look.

Thank you very much

Liz

[MikeS81]

Hi Liz,

you can create a 2D array of your 1D array´s and write this to your spreadsheet file.

Mike