MS Office Report to Excel Problems formatting Column Headers into report

[pallen]

I know I'm going to feel silly when I get the answer for this one.  But I'm not getting anywhere on my own now.

I'm using the MS Office Report Toolkit to create an Excel report from a table in a LabVIEW application.  

I spent some time figuring out how to create Named Ranges in the Excel Template I created.  That seems to be working, because I can see the inputs to the icon on the LabVIEW block diagram.  

The problem I'm having is with the Table's Column Headers.  

I created a Named Range that is an entire row of my Excel Template.  When I use the property node to send the Column Header values to the template, the data appears as a column in the spreadsheet.  So far, I haven't been able to figure out how to enter this data as a row instead of a column.  

Is there a way?  

 

Suggestions greatly appreciated!  

[Wayne.C]

pallen,

As usual the Express VI has its limitations.  It seems to be setup for a 2D array of info in this case.  The best way I've found is to name range in template and use the Excel Easy Table.vi.