Report Generation Toolkit - "Get Last Row" to feed position to "Excel Get Data VI"

[joshuatran17]

Hello, 

I am having trouble using the "Get Last Row" to properly pass a position into the "Excel Get Data VI". As shown in the image the population of the arrays does not work. I am simply trying to extract a specific cell of data from different txt files through a loop. 

The population of the arrays work when i do not use the "Get Last Row" and provide a fixed cell value. Is there something I am missing? Any help would be greatly appreciated. 

Thanks!  

[altenbach]

We can't really debug truncated images. If you want real help, attach your Vi instead.

Obviously, you have a glaring race condition due to blatant overuse of local variables. During each iteration, the "MS Office parameters out: local will get read way before the corresponding indicator gets written, giving you stale data (form the previous iteration or from the previous run).  Also, don't you want to use initialized shift registers.

I also strongly recommend to not use "string to path". This immediately makes it OS specific.

[Bob_Schor]

In addition to @altenbach's request for the actual LabVIEW Code (a .VI file, or, better, a compressed version of the entire Project File), please attach an example "data file" that you hope to use with this code.

Note that you are using the Report Generation Toolkit, and specifying "Excel" as the file type to process.  Your input file, accordingly, should be an Excel file with the .xls or .xlsx extension.

Bob Schor