LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

I need to save two 1D arrays to excel in version 8.2

Solved!
Go to solution

Hi educob,

 

to store more columns you can

- collect the data in memory and use BuildArray with more inputs...

- load the already saved file, use IndexArray to attach two more columns and save the file again...

 

It would be much easier to use rows (instead of columns) for each measurement!

Best regards,
GerdW


using LV2016/2019/2021 on Win10/11+cRIO, TestStand2016/2019
0 Kudos
Message 11 of 20
(987 Views)

Hi,

 

thanks for the answer.

I wouldn't know how to read the file and then add the new columns.

 

I am a developer but in the standard languajes. This labview language is getting on my nerves.

 

 

0 Kudos
Message 12 of 20
(983 Views)

Hi educob,

 

you already heard of WriteToSpreadsheetFile.

Right next to it is a function named "ReadFromSpreadsheetFile" - and it gives you a 2D array of values. Now you only have to append two more rows and save again...

Best regards,
GerdW


using LV2016/2019/2021 on Win10/11+cRIO, TestStand2016/2019
0 Kudos
Message 13 of 20
(981 Views)

Hello Smercurio,

 

Educob Wrote...

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Hello,

 

I can't find good examples for labview 8.2.

I have two 1D arrays of 1024 elements. I need to save each of them in a different column of an excel file.

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

 

Here developer want to save the data in Excel file. Run the code with some parameters and save in xls format. I think this will save in excel file.

Have a look with attacted generated file, Correct me if i am wrong.

Thanks and Regards
Himanshu Goyal | LabVIEW Engineer- Power System Automation
Values that steer us ahead: Passion | Innovation | Ambition | Diligence | Teamwork
It Only gets BETTER!!!
0 Kudos
Message 14 of 20
(968 Views)

Thanks to Himanshu Goyal I am saving 1D arrays into an excel file.

 

I don't know how to save individual values in controls.

 

Thanks.

0 Kudos
Message 15 of 20
(959 Views)

Hi Educob,

 

Can you please elebrote your question, it may help to understant the prooble and to find the quick solution.

Thanks and Regards
Himanshu Goyal | LabVIEW Engineer- Power System Automation
Values that steer us ahead: Passion | Innovation | Ambition | Diligence | Teamwork
It Only gets BETTER!!!
0 Kudos
Message 16 of 20
(961 Views)

I would like, besides saving 1D arrays saving indivual values. For instance I have a control for Torque, another for power, etc.

 

I would like also to add a header to each column like:

alfa  pressure volumen

0        1.5        0

0.1     1.6        0.1 .....

 

Thanks.

0 Kudos
Message 17 of 20
(951 Views)

Hello Educob,

 

Please find the attached Vi. I hope this will work for you.

Thanks and Regards
Himanshu Goyal | LabVIEW Engineer- Power System Automation
Values that steer us ahead: Passion | Innovation | Ambition | Diligence | Teamwork
It Only gets BETTER!!!
0 Kudos
Message 18 of 20
(941 Views)

Thanks.

 

I will try to udnerstand it.

0 Kudos
Message 19 of 20
(935 Views)

More Simpler........Smiley Wink

Thanks and Regards
Himanshu Goyal | LabVIEW Engineer- Power System Automation
Values that steer us ahead: Passion | Innovation | Ambition | Diligence | Teamwork
It Only gets BETTER!!!
0 Kudos
Message 20 of 20
(931 Views)