Atom Feed SITE FEED   ADD TO GOOGLE READER

POI, hyperlinks, and 2^7

As I mentioned earlier, I am using Jakarta POI to create Excel files.

Earlier I warned:
  • don't use space characters (or commas or pretty much anything else)
  • limit sheet names to 31 characters

    Well today I discovered another unpleasant limitation. The link label must be 127 characters or fewer. If not, POI may throw an exception or create an unreadable file.

    I get the feeling that the formula support in POI is still fresh. Hopefully these limitations won't be permanent!