Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Language IDEs » Java Development Tools (JDT) » Excel as a data source(Creating a database connection with excel)
Excel as a data source [message #1159718] Mon, 28 October 2013 18:47 Go to next message
Ben Burkett is currently offline Ben BurkettFriend
Messages: 1
Registered: October 2013
Junior Member
I am wondering if it is possible to create a database connection to an excel spreadsheet via something like a Generic JDBC connection. The reasoning behind this is to be able to right click on it and "preview" the data in the sheet. From what I have read I do not think it is possible and I just want to clarify this before I tell my boss?(I am interning) that he can not have it that way.

Would it be beneficial to make a plug-in that could do this? Like for instance when you right click on the excel data source using BIRT that maybe could click "preview" and it would pull in the first 50 rows.

Any help would be appreciated, I have been racking my brain on this for the past couple of days.
Re: Excel as a data source [message #1171442 is a reply to message #1159718] Tue, 05 November 2013 08:29 Go to previous message
Arnav Kumar is currently offline Arnav KumarFriend
Messages: 16
Registered: October 2013
Junior Member
Re: Excel as a data source
Apache POI - the Java API for Microsoft Documents, is an open source for java that can read excel sheet and then you can work on that data as you wish i.e. fill that information in the database.
Hope this reply is helpful for you
TechknowHeights

[Updated on: Tue, 05 November 2013 08:30]

Report message to a moderator

Previous Topic:Eclipse RCP
Next Topic:Changing the workspace of eclipse
Goto Forum:
  


Current Time: Mon Nov 24 08:25:53 GMT 2014

Powered by FUDForum. Page generated in 0.06867 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software