how to auto save instrument output data to Excel with preset file path and names

[byuan]

Hi,

I'm having this auto saving problem. The type of my instrument output is ''1-D array of cluster of two elements''. I tried to use ''Report Generation Toolkit", but it seems the data type doesn't match. Anybody got ideas about the data type conversion?  Other possible approaches are also welcome!

Thanks!!

[RTSLVU]

Try the "Write to Spreadsheet File" vi in the "File IO" group

[byuan]

Hi PTSLVU,

Hi. I tried that way but I think it does not accept the my input data type '1-D array of cluster of two elements'.

I also tried to unbundle before that, but I could only get 250 data points from the 1600 in total. Could you tell me how to do that?

Thanks!

[crossrulz]

What's in the cluster?  Can you show us some code?

[RTSLVU]

---

@byuan wrote:

Hi PTSLVU,

Hi. I tried that way but I think it does not accept the my input data type '1-D array of cluster of two elements'.

I also tried to unbundle before that, but I could only get 250 data points from the 1600 in total. Could you tell me how to do that?

Thanks!

---

Without seeing the actual data cluster I would say you should look through the Cluster, Class, and Variant pallet to see if you can find what you need to convert the array of clusters to a 1-D numeric array that the Write to Spreadsheet vi can use.

[byuan]

Hi crossrulz,

I attached the picture for output part down here. The output data from the network analyzer comes out of 'collect data' VI and I display it in the xyGraph. It contains the result of linear sweep of 1600 points and the output is type '1-D array of cluster of two elements'. I am saving the data with 'Export plot data to Excel', but I have to save the path and filename by hand, which is the problem now. 

Thanks!

[byuan]

Sorry here is the screen shot

[byuan]

I didn't find any VI that could do that.. I attach the output part of code down there and you could see the output data type. Hope that helps.

Thanks!

[Dennis_Knutson]

If you don't attach the VI, you aren't going to get much help beyond saying use the unbundle function. The image you posted does not show anything about the actual data in the cluster.