Page 1 of 1
Custom ODA to use Microsoft Excel files as data source
Posted by
Megha Nidhi Dahal 
, 15 September 2011 - 07:14 AM
Hello Community,
A custom ODA plugin for eclipse BIRT that supports using Microsoft excel files (xls, xlsx) as data source, has been developed and hosted at eclipse labs.
The user interface for configuration is simple and intuitive and is at par with the Flatfile ODA.
The ODA can read data from multiple worksheets in the excel workbook (similar data of course). To make the ODA read from multiple sheets, the data set property Worksheets has to supplied with semi colon (;) delimited sheet names.
Note: The control information like the header, and type names should be only on the first sheet passed in the sequence. Control information (if any) in other sheets might be considered as data and might cause type inconsistency.
More information about the plugin and the deployment instructions can be found at the DevShare.
Feel free to evaluate and leave a feedback.
Best Regards,
Megha Nidhi Dahal
A custom ODA plugin for eclipse BIRT that supports using Microsoft excel files (xls, xlsx) as data source, has been developed and hosted at eclipse labs.
The user interface for configuration is simple and intuitive and is at par with the Flatfile ODA.
The ODA can read data from multiple worksheets in the excel workbook (similar data of course). To make the ODA read from multiple sheets, the data set property Worksheets has to supplied with semi colon (;) delimited sheet names.
Note: The control information like the header, and type names should be only on the first sheet passed in the sequence. Control information (if any) in other sheets might be considered as data and might cause type inconsistency.
More information about the plugin and the deployment instructions can be found at the DevShare.
Feel free to evaluate and leave a feedback.
Best Regards,
Megha Nidhi Dahal
Page 1 of 1
Recent Entries
My Blog Links
Recent Comments
- ognloguet on BIRT-Talk, A collaboratively edited question and answer site for BIRT
- ognloguet on BIRT-Talk, A collaboratively edited question and answer site for BIRT
- cooccomarc on BIRT-Talk, A collaboratively edited question and answer site for BIRT
- Megha Nidhi Dahal on Custom ODA to use Microsoft Excel files as data source
My Picture
0 user(s) viewing
0 Guests
0 member(s)
0 anonymous member(s)
0 member(s)
0 anonymous member(s)
