Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 366908

Summary:	Excel as an OOTB BIRT Data Source
Product:	z_Archived	Reporter:	Mihail Mihaylov <mmihaylov>
Component:	BIRT	Assignee:	Linda Chan <lchan>
Status:	RESOLVED FIXED	QA Contact:
Severity:	enhancement
Priority:	P3	CC:	kkazmierczyk+eclipse, lchan
Version:	3.7.2
Target Milestone:	4.2.0 RC2
Hardware:	PC
OS:	Windows 7
Whiteboard:
Bug Depends on:	361443
Bug Blocks:

Description Mihail Mihaylov

2011-12-15 19:34:04 EST

Build Identifier: Eclipse BIRT 3.7.1

This project calls for adding Excel as an OOTB data source for BIRT. It will provide developers (or any users) with a quick and easy way for to try BIRT against their own data. It will also allow power users access data they have in Excel without having to figure out how to get it into a db

Reproducible: Always

Comment 1 Linda Chan

2012-05-30 19:09:36 EDT

Enhancements have been made by Actuate contributors to the initial community contribution (bug 361443), and added in BIRT 4.2 RC2 milestone release.

Enhancements made include: 
* Performance tuning in xlsx and xls file data processing
* Support Timestamp, Datetime, Time, and Date data types
* Support either Absolute/Relative File Path or URL for the Excel input file defined in a data source design
* Support Read-only mode in Data Source UI page when referencing a connection profile
* Improved UI usability, manages changed state in edit session, etc.