This week's book giveaway is in the HTML/CSS/JavaScript forum.
We're giving away four copies of Practical SVG and have Chris Coyier on-line!
See this thread for details.
Win a copy of Practical SVG this week in the HTML/CSS/JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Jakatha poi

 
hamlin stephen
Ranch Hand
Posts: 45
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
HI,
I am using poi HSSF for displaying data in microsoft excel in my application.My requirement is such a way that I need to restrict the cell character size limit to one and also that should be in upper case.
Is it possible to do that?

Please reply ..
thanks in advance.
[ November 20, 2005: Message edited by: hamlin stephen ]
 
Ulf Dittmer
Rancher
Posts: 42970
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
That's not possible in a static Excel file, which is what POI reads and writes. You can use macros to check and restrict the contents of cells, although I'm not sure POI supports those.
The jXLS approach to creating Excel files (through the use of template files) sounds as if it should support macros, but jXLS can only write to XLS files, not read them.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!