<p>HI, I am using open source BIRT and trying define a data source from an Excel workbook with multiple worksheets. I can setup a data source for a single worksheet but I would like to somehow use the worksheet names as a report parameter to select the worksheet for report processing. The data in each worksheet has the same column layout and same data type for each column.</p>
<p> </p>
<p>In addition to processing an individual excel workbook, I have new excel workbooks being created weekly and would like to find a way to select the workbook to be used as the data source.</p>
<p> </p>
<p>I have only been working with BIRT for a few weeks. I have some experience programming in python, ruby and php but not java.</p>
<p> </p>
<p>Can someone please help this novice?</p>
<p> </p>
<p>Thanks,</p>
<p>Paul</p>
