The term "Template" when describing the New Report function (particularly for Excel) is something of a misnomer. If you intend to read from an existing Workbook, then "Template" means "Input File". Where it differs slightly from expected/accepted usage is that you need to separately specify the Output File when you do a "Save Report to File" -- it does not automatically follow that it will be the same as the file you opened.
The RGT doesn't really care whether you use the "old" Excel file format (.xls) or the "new" one (.xlsx), which is more "modern". Since the "x" versions of Office Files (.docx, .pptx, .xlsx) are the default formats since Office 2010 (a few versions ago), they are what I use.
I just looked at the picture you posted of your code (I won't go into my rant about attaching actual code, i.e. VIs, and not pictures). Notice that you are appending a Table to a Report, so if you look at what is being displayed by Excel, it may look OK, but if you now close Excel, you will be left with ... nothing, as you failed to Save Report to File, specifying an output file. Yes, it is a little confusing, and a little different than other I/O, but this isn't I/O, this is interacting with other programs (Excel, Word, etc.) using the Report Generation Toolkit, which has its own set of rules that need to conform to the "partner" routines that are actually generating the Reports ...
Bob Schor
