CODEWITHSUNDEEP
excelgrailsimportapache-poi
Ashwath
Ashwath

Reputation: 23

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

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.

Upvotes: 0

Views: 2808

Answers (1)

vegadoom
vegadoom

Reputation: 471

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.

Upvotes: 1

Related Questions