Data export to excel

[AlexKTH]

Dear users,

Sorry if I repeat a question, I searched this forum for solution of my problem and didn`t succeed. I am very new to LabVIEW. I need to export data from 3 channels (Stokes vectors) to 3 labeled columns in Excel. Every measurement session should create a new sheet in one excel file. I tried methods described on http://zone.ni.com/devzone/cda/pub/p/id/1339, but due to lack of knowledge didn`t get what I need.
It would be very nice of you to help me with this situation, I attach a screenshot of block diagram  and vi. I hope this is very simple for experienced LabVIEW users.

Best regards,
Alex

[Ranjeet_Singh]

not exactly your requirement but can be customized. Let me know if you need some explanation

[AlexKTH]

Sorry for stupid question, but how can I connect my output channels (Stokes 1, Stokes 2, Stokes 3)  with your scheme? Thanks for help.

[Ranjeet_Singh]

Its not stupid, it happens. Some how you need to acquire the data, you may use serial comm, or some kind of interface. This application only will write the data it got. It cant help in acquiring.

Let me know your application

[AlexKTH]

My vi is in attachment in the first post. There are 3 output channels (Stokes 1, Stokes 2, Stokes 3, marked on the picture) which I need to connect with your data saving application.

[Ranjeet_Singh]

Where you are storing the data...Database?

[Ranjeet_Singh]

Linkup you can do is reading first from database and later using my application

[PontusMarkstrom]

Hi AlexKTH,

I have modified Ranjeet Singh's VI a bit so that it might be easier for you to use with your attached VI in mind. As you can see, I have prepared three arrays for you to insert your Stokes data. I noticed from your attached VI that the Stokes values are scalars. However, you describe that you want collumn vectors in your excel data sheets. I then take it that you will prepare arrays from your scalars before saving your Stokes data to Excel? My attached VI is created with this in mind.

The VI also assumes that you want to save data continuously, thus it will create a new worksheet within a period that you decide. If you want to save to Excel by the press of a button, then you can use my VI and edit it to instead use an Event Structure with an additional idle state (waiting for you to press a button and save to file).

In the VI, replace the prepared three arrays with your real arrays. As mentioned above, the arrays will be collumn vectors in the Excel file that you determine the path for (see control on the frontpanel). For each loop (in this example every 1000 ms) you will generate a new worksheet, labeled with the local time of the experiment (down to 1/10 of a second). Observe that no two labels can have the same name.

I saved the file in version 2011 as I saw that your saved your VI in that version. Please give some feedback if this is of any help to you.

[AlexKTH]

Hi PontusMarkstrom,

Thank you for your help, you did really great job! I am now connecting arrays. I must say I gave you not correct information - output data are not vectors, but just scalars, numericals, and they will not be converted to vectors. Sorry for that, now I will make everything working.
Thank you again!

Alex