CFSPREADSHEET read in Excel file to query can't access columns in result
<p>I'm trying to automate processing of spreadsheets using ColdFusion 10 and CFSpreadSheet.  So far I can read the file in and dump the query object without any issue.</p>

<pre><code>&lt;cfspreadsheet action="read" src="#theFile#" query="qData" headerrow="1" columns="1,8,9,11,33"/&gt;
&lt;cfdump var="#qData#"/&gt;  
</code></pre>

<p><a href="https://i.stack.imgur.com/Mpx7M.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Mpx7M.png" alt="cfdumpoutput"></a></p>

<p>The issue comes when I try to work with the data.  If I do something like:</p>

<pre><code>&lt;cfoutput query="qData" maxrows="#qData.RecordCount#"&gt;
    #qData.GROUP#&lt;br /&gt;
    #qData.DOB#&lt;br /&gt;
&lt;/cfoutput&gt;
</code></pre>

<p>I immediately get an error: "Element GROUP is undefined in QDATA."</p>

<p>If I dump the qData.ColumnList I get a column list:</p>

<pre><code>BTBN(002),DOB ,GROUP ,MEMBER/DEPENDENT NAME ,REL
</code></pre>

<p>Is it the spaces and ( )s messing it up?  If so, how can I get rid of those and update the column names either when reading in the file or immediately thereafter?</p>