Poi set Column Style

Recently done in the project with the POI export Excel file template, some of the columns need to be set to text format, check the data found are to set the style of the cell, because it is not the content of the template cell, so can not set the format of the cell style operation, the Internet has the argument is not set column style, rather disappointed.

I did not expect to find this by accident in sheet's Lenovo list:

Try it now, the problem is solved ~

Hssfcellstyle Idnostyle == workbook.createdataformat (); Idnostyle.setdataformat (Format.getformat ( "@"); Idnostyle.setborderbottom (Hssfcellstyle.border_thin); Sheet.setdefaultcolumnstyle (1, Idnostyle);

Poi set Column Style