shift array row

[sushmith_ks]

Hello everyone,

             I need to do a strange task. i.e say i have a 2 day array ( find the attached) taken from excel file. I have to edit the array in such a way that after 30 3000, i need to insert 40 4000. If i place cursor near 3000 and press ENTER or some button new row should be created where i can fill 40 4000. Is it possible?

[GerdW]

Hi Sushmith,

in Excel you would insert an empty row and input the missing values. Is that what you want? Maybe you could write an Excel macro using VBA to do all this and start that macro with a button in the Excel ribbon menu? Is that what you want?

Anyway: read the Excel/VBA help to do your task... 😄

[sushmith_ks]

No no. I need to insert value/edit in front panel. Later I will be storing whole table in excel, thats not a problem.

[GerdW]

Hi Sushmith,

then why do you attach an Excel file when you need help for a LabVIEW vi?

How do you present that data to a user? When using a table you could check the "active cell" property and use it's indices to insert new data automatically...

[sushmith_ks]

Hello GerdW,

              The Computer with Labview is in lab and i'm out, so I had to use excel.. 

Can you please show me the above mentioned procedure with some example?

[GerdW]

Hi Sushmith,

use ActiveCell and InsertIntoArray: