Reading cell styles along with data-Excel sheet reading using apache POI

0
votes

folks, I am able to read the excel sheet using apache POI in grails using this I am inserting the cell values into different tables of mysql, My problem is, I am not able to get the cell style like, bold or italic etc along with the data. generally text area will automatically give the style of text while inserting into database. I need to insert the data along with its style from each cell, please help me in solving it.

1
excelgrailsimportapache-poi
How are you expecting to be able to store this style information in your database? Especially given that one string in excel can have different styles applied to different parts of it? – Gagravarr

1 Answers

1
votes

http://poi.apache.org/apidocs/org/apache/poi/hssf/usermodel/HSSFCell.html#getCellStyle()

This should get the CellStyle from the cell, which then you can use to get the information you want.