In fact, setting the column width to zero is the same as making the column
invisible. The width of the column is not changed by those operations: this
allows Excel to keep the original width when you mask/unmask a column.
Using BiffViewer, you can see that the only diff you get after setting
Hello!
Fill the cell where you want to have your link with:
cell.setCellFormula("HYPERLINK(\"#" + __TheNameOfTheDestSheet__
+ "!" + __TheNameOfTheDestCell__ + "\", \"" +
__LinkLabel__ + "\")");
In the Excel workbook, you will find for example:
=HYPERLINK("#Sheet1