10-17-2012 06:17 AM
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.
10-17-2012 06:36 AM
Please post the vi what you have tried so far. So that we can debug it and help you learn quicker.
Thanks,
Mathan
10-17-2012 06:43 AM - edited 10-17-2012 06:44 AM
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.
10-29-2012 12:22 AM
i have attached my vi ....please tell me the solution.
thanks in advance
basavaraj
10-29-2012 10:41 AM
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.