combining 1-D arrays to save in excel format

[Shan21]

I have different 1-D arrays which I want to store in excel. All arrays in a single MS excel file.

How do I do that?

[MikeS81]

Hi Shan21,

are your arrays from different type? If you need a "real" Excel file, then you have to use ActiveX functions. To write two different array (different type) use two invoke node (value) to write the different types.

If you only need a Spreadsheet file, then the easiest way is to convert both arrays to string and write all at ones.

Hope it helps.

Mike

[Shan21]

If I convert it to a spreadsheet, can we manipulate the numbers inside the spreadsheet cause now they are strings?

[MikeS81]

Hi Shan21,

yes, you can change what you want in your file. Do you need to read the values later?

Mike

[Shan21]

Yes I do need to read the values later and make an XY plot for comparsion for the values.

[MikeS81]

Hi Shan21,

it shouldn't be a problem. Do you have different types? Can you show an image of what you make?

Mike