Duplicating a workbook with internal links - which become broken

[Aram Mirzadeh]

Hi,

I have a xls file with a ton of internal hyperlinks (one cell to 
another) or from sheet to sheet.  

I'm using this file as a "template" in my code, so the first thing I do 
is duplicate the workbook and than go ahead and fill in what I need using:

       POIFSFileSystem fs = null;
       FileOutputStream output=new FileOutputStream(inputExcelDir + 
inputExcelFileName);
       HSSFWorkbook wb = null;
      
       try {
           fs = new POIFSFileSystem(new FileInputStream(outputExcelDir 
+ outputExcelFileName));
           wb = new HSSFWorkbook(fs);
       } catch (Exception e) {
           System.err.println("ERROR: " + e);
       }
    
       wb.write(output);
       output.close();

But now I'm seeing that all of the hyperlinks are broken, as they point 
back to the template file.  My question is, is there an easy way to fix 
this or do I need to write a method to go through even sheet, every row, 
every cell and check to see if a hyperlink exists, and if it exists, 
modify it if its internal?

Thanks.

Aram

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscr...@poi.apache.org
For additional commands, e-mail: user-h...@poi.apache.org