aspose file tools*
The moose likes JDBC and the fly likes handling excel sheet with java Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "handling excel sheet with java" Watch "handling excel sheet with java" New topic
Author

handling excel sheet with java

sonia arora
Ranch Hand

Joined: Mar 10, 2010
Posts: 31
i need to open a excel sheet on click of a button.
and retrive some data from excel sheet and store it in access database.
need help.
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41508
    
  53
Is the problem the opening and reading of an Excel file, or the storing of data in a DB? What do you have so far?


Ping & DNS - my free Android networking tools app
sonia arora
Ranch Hand

Joined: Mar 10, 2010
Posts: 31
i have created JDBC connection .
i am able to select (read) data from excel sheet
but i need to open a new Excel sheet on click of a button from gui,
displaying the attributes i select that is the checkboxes i select.
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41508
    
  53
So the code already reads and displays some values from an Excel sheet, and now the problem is that you need to add a button to the GUI that causes a different Excel sheet (or file) to be opened, and the currently displayed values are replaced by values of this newly opened sheet/file - is that correct? If so, since you already know how to open an Excel file, read values from it and display them, where is the problem in implementing this?
sonia arora
Ranch Hand

Joined: Mar 10, 2010
Posts: 31
i need the code to open , create a excel sheet on click of button.
i.e how to create new excel sheet?
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41508
    
  53
A very capable library for handling (including creating) Excel files is Apache POI; its web site has numerous examples of how to accomplish all kinds of tasks.

But you said that you're able to read values from an Excel sheet, for which you are presumably using some library; care to tell us how you're doing that?
sonia arora
Ranch Hand

Joined: Mar 10, 2010
Posts: 31
i have used sql query i.e. "select * from [sheet$]" to read data values.
but nt able to create.
nowi wud visit apache and see if it works.
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2495
    
    8

Hi Sonia,

sonia arora wrote:nowi wud visit apache and see if it works.
Please UseRealWords.


OCUP UML fundamental and ITIL foundation
youtube channel
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: handling excel sheet with java