[Is there a tutorial for a Excel Datasource made report?]

Hi

I have a related question.  I am trying out iReport for the first time, and I am trying to use a subdataset with an Excel spreadsheet as data source. (Some report elements such as 'Table' seem to require a subdataset)

My Excel spreadsheet looks like this:

 

Soda	Respondents
Coke	100
Pepsi	100
7-Up	33
Sunkist	20
Welches Grape	10

My xml code for the subdataset looks like this:

    <subDataset name="Dataset_1" uuid="0ed8ae74-6ddf-4e05-afba-dda8894f0c25">
        <field name="Soda" class="java.lang.String"/>
        <field name="Respondents" class="java.lang.Number"/>
    </subDataset>

Must I set up a query to get hold of the actual Soda and Respondents data? What must this query look like? 

Any feedback would be appreciated.