Excellent suggestions from @aputman.
Some things I noticed:
- You are running LabVIEW 2018, but the code for the RGT appears to come from a much older version of the RGT, as you start with "New Report,vi" instead of "Create Report.vi" (I don't remember when the RGT was upgraded, but it was before 2018 ...).
- You specified a "Template" input (and supplied an .xltx file as the "Template"). I believe this is not what NI means by a "Template" -- I think it means an ordinary .xlsx File that specifies a "partly-filled-in" Workbook, possibly with named WorkSheets, that you open and "fill in the blanks" (by, for example, opening a specific Worksheet that has Cell Locations where data should be placed on another Worksheet -- you read this location, switch to the proper WorkSheet, then "fill in the blank" using the Template's Cell location).
A suggestion -- Write a small Demo routine that opens Excel and writes the numbers 1, 2, 3, 4, 5 in the first row of the first WorkSheet (without specifying a Template in the "Create Report" and saves the WorkBook as "My Demo.xlsx". Be sure to do this in the context of a new LabVIEW Project (perhaps call it "RGT Code for LV Forum"). If it works, then gradually "add features" (testing after each step) until you get something similar to what you are trying to do. If it fails,, close the Project, right-click its folder and choose "Send to:", "Compressed (zipped) Folder", and attach the resulting .zip file so we can "see for ourselves" what you are doing and figure out "how to fix it".
Bob Schor
