my dog learned polymorphism*
The moose likes Java in General and the fly likes Appending data to Excel sheets Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Java in General
Bookmark "Appending data to Excel sheets" Watch "Appending data to Excel sheets" New topic
Author

Appending data to Excel sheets

Ayyappan Selvaraj
Ranch Hand

Joined: Sep 20, 2004
Posts: 63
I have a requirement that I need to append rows, cells and data in the cells to an already existing excel sheet. How could this be done. Pls suggest me with code snippets asap. Thanks in advance.
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41096
    
  44
The Jakarta POI library can read and write XLS files. Its documentation contains plenty of examples.


Ping & DNS - my free Android networking tools app
Ayyappan Selvaraj
Ranch Hand

Joined: Sep 20, 2004
Posts: 63
thanks I got much from the link. But I could not find one thing.. I want to set Hyperlink to an external resource on a text in the excel sheet through Java.. How can this be done?
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41096
    
  44
Hyperlinks are formulas with the syntax:

=HYPERLINK( "target", "label")

You can even link to particular cells in a workbook:

=HYPERLINK( "#'My sheet'!A1", "label")

You may have to use semi-colons between parameters instead of commas, depending on your local settings.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Appending data to Excel sheets
 
Similar Threads
Upload Data in Excel file
merge first row of excel sheet by javascript
importing data from jsp to excel to generate image in Excel
Problem in retrieving Cell values from Excel file.
Write Data to Excel