Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Appending data to Excel sheets

 
Ayyappan Selvaraj
Ranch Hand
Posts: 63
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Rancher
Pie
Posts: 42967
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The Jakarta POI library can read and write XLS files. Its documentation contains plenty of examples.
 
Ayyappan Selvaraj
Ranch Hand
Posts: 63
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Rancher
Pie
Posts: 42967
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic