Add an avergae row in a spreadsheet

[ka_torce]

I would like to add an additional 5th row to a spreadsheet file that contains a row of headers and 3 rows of data. The 5th row will consist on the average values of the 3 corresponding cells above(rows 2, 3 and 4).

See the attached files as example of the initial and final file I would like.

Can this be done with Labview 2011?

Thank you.

[udka]

-I guess, it can be done.
-Open the spreadsheet using read from spreadsheet file.
-Get the data into 2d array and from then its just simple like what you mentioned.

[ka_torce]

I am trying to implement it but I am stuck. I have very basic knowledge of labview and I am not very skilled operating with arrays. Could you please make an example or complete the VI attached I am trying to do?

Thank you.

[udka]

Hi ka_torce,

-Please find the attached vi, you need to again wrtie these data back to same file.

-Apart from that, everything is done (I saved file in csv format and then used).

-Please never ask people in the forum to complete the vi or code, instead ask how to approach or go further.

[ka_torce]

Dear Udka,

thanks for your help but your Labview version is newer than mine. Can you please convert it to Labview 2011? Sorry for asking to complete the code but with the example is better for me for understand how to do it. I will follow your advice and next time ask differently.

[udka · Accepted solution]

Hi ka_torce,

Sorry, here you go for LV11.

[.aCe.]

Another approach.