Poi operation Excel Summary

Because poi is used in the work process, problems encountered during use and major poi classes are recorded.

 

Common poi classes include hssfworkbook, hssfsheet, hssfrow, and hssfcell.

 

Hssfworkbook: as its name implies, it is a workbook class.

Hssfsheet: a tab class.

Hssfrow: it is a row class.

Hssfcell: column Class.

 

The operation sequence is hssfworkbook ---> hssfsheet ---> hssfrow ---> hssfcell

Hssfsheet can control cell merging.

Note the following when setting the column width or Row Height for hssfsheet: setcolumnwidth ("column Index", "width"), the unit of width is 1/256 characters, therefore, when creating a column with 50 characters to display, set the width to 50*256.

Hssfrow # setheight ("height") when setting the row height. The unit of height is 1/20 characters.