File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Java in General and the fly likes reading from excel file. Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


JavaRanch » Java Forums » Java » Java in General
Reply Bookmark "reading from excel file." Watch "reading from excel file." New topic
Author

reading from excel file.

felix thomas
Ranch Hand

Joined: Jun 10, 2001
Posts: 89
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
Marshal

Joined: Mar 22, 2005
Posts: 35438
    
    9
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.


Android appsImageJ pluginsJava web charts
magesh karnam
Greenhorn

Joined: Sep 08, 2003
Posts: 14
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

Joined: Sep 08, 2003
Posts: 14
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
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: reading from excel file.
 
Similar Threads
Exporting data to excel file... using java web app
display csv file as an excel in java
reading from a file in real time.
opening excel application in browser
CSV+truncate leading zero solution