LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

excel editing

Hi.

Am accessing excel data In single excel sheet contains so many columns. and am displaying particular column into different tables . during running time am not able to edit and edited data i need to save same column(particular columns) in a excel sheet. how to solve this please tell me.

thanks in advance 

basavaraj.

0 Kudos
Message 1 of 5
(2,653 Views)

Please post the vi what you have tried so far. So that we can debug it and help you learn quicker.

 

Thanks,

Mathan

0 Kudos
Message 2 of 5
(2,646 Views)

Are you editing the actual Excel file or a .csv file? As said you can post the code (in 2009 version) so that its easy to find where the issue is.

-----

The best solution is the one you find it by yourself
0 Kudos
Message 3 of 5
(2,644 Views)

i have attached my vi ....please tell me the solution.

thanks in advance

basavaraj

 

0 Kudos
Message 4 of 5
(2,602 Views)

A couple of suggestions:

 

1.  Don't open up the Excel file on every iteration of the outer while loop.  Only do it once since you are using the same file on every iteration.  Move the Open nodes ahead of the loop, and the Close node after the loop.

 

2.  You have a weird construction of bundling up references in a cluster, then immediately unbundling them.  While I think I understand that you are trying to neaten up the wiring a bit, the immediate bundling and unbundling just seems like needless operations.  I would recommend eliminating all of that.

 

3.  You have a lot of local variables.  That can lead to race conditions.  Some are just redundant.  I would eliminate the locals and replace them with wires wherever you can.  For instance, you have 40 instances of "Exl- tbl-Exl", one in each of your cases inside the inner while loop.  Meanwhile you have the terminal for that control unused in the while loop.  Just wire from that terminal into the case structure through a tunnel, and you'll have access to the data in that control without the 40 instances of the local variable.

0 Kudos
Message 5 of 5
(2,578 Views)