wood burning stoves 2.0*
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


Win a copy of Java 8 in Action this week in the Java 8 forum!
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: 39576
    
  27
The Jakarta POI library can read and write XLS files. Its documentation contains plenty of examples.


Ping & DNS - updated with new look and Ping home screen widget
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: 39576
    
  27
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
Problem in retrieving Cell values from Excel file.
importing data from jsp to excel to generate image in Excel
Write Data to Excel
merge first row of excel sheet by javascript
Upload Data in Excel file