• Post Reply Bookmark Topic Watch Topic
  • New Topic

reading from excel file.  RSS feed

 
felix thomas
Ranch Hand
Posts: 89
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi,

I want to read a excel file and display its data in a jsp. But my problem is that i have to read only those data that are in bold. is there any packages that support this kind of reading. I foung many excel reading packages but they are read simple format.

 
Ulf Dittmer
Rancher
Posts: 42972
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Looking through the POI API, you can retrieve the font index from a cell via HSSFCell.getCellStyle().getFontIndex(), and then retrieve the corresponding HSSFFont via HSSFWorkbook.getFontAt(short). That object tells you whether a cell is in bold or not.
 
magesh karnam
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
Did u try jxl.jar (http://jspwiki.org/wiki/ExcelToHTMLPlugin) this is very usefull when you are working around with excel sheet.

hope this is of some help to you.

Regards
 
magesh karnam
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
Did u try jxl.jar (http://jspwiki.org/wiki/ExcelToHTMLPlugin) this is very usefull when you are working around with excel sheet.

hope this is of some help to you.

Regards
Magesh
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!