Report generation tool kit

[Gizzmo]

Hi,

I have recently purchased Report generation tool kit and am trying to familiarise myself with using it. I have come across a problem when trying to "get last row" when reading from an excel spreadsheet. The attached vi and .xls seems to be switching the column and row index and the data feedback is empty. I'm sure it's a simple fix but I cannot see it at the moment.

I would appreciate any help.

Thanks

[StefanA]

Hey Gizzmo,

if you want to display the whole spreadsheet you need to convert your "data type" from a string to a 2D-array of strings and your "data" as well.
If you dicsonnect your "postition (excel)" from the start node of the "Excel Get Data.vi" you will get all information written into the spreadsheet.
"position (excel)" gives back the number of used rows but if you wire that information (row 10, column 0) to the start node it will start with A11 and this element is empty so it will stop immedatly. (because A1 in excel would be row0 and column0)

Regards,

Stefan

[Gizzmo]

Hi StefanA

Thanks for the response, I'm not following you, I do wish to display all the elements in the spreadsheet, is it possible you can explain further or adapt the code? I am not familiar with arrays.

Thanks  

[StefanA · Accepted solution]

Gizzmo,

how much experience do you have programming with LabVIEW?

Attached you will find the correct vi. 

Hope things get clearer now.

Stefan

[StefanA]

I'm not sure which version of LabVIEW you're using. I saved this one for 8.6. If you have another version please let me know.

[Gizzmo]

My experience is very little at the moment, I have experience Agilent VEE in the past, and I'm having difficulty applying this experience to Labview. Anyway, thanks for the code, it works perfectly. How do you create the 2d array constant? Can you suggest any tips to become more familiar with arrays and such?

Thanks

[StefanA]

You will find the array constant on the front panel in modern -> Array, Matrix & Cluster.

If you place it on the front panel and make a right click on the element you can add another dimension to it.

If you're new to LabVIEW I would recommend taking the LabVIEW Basic Courses.

Stefan