Getting Started with POI

POI Quick Start

Seven steps required for POI development:

1. Create a workbook Workbook object

Workbook wb = new Hssfworkbook (); // It is the operation of the Excel 2003 version

2. Create a worksheet Sheet object

Sheet Sheet = Wb.createsheet ();

3. Create a Row object

Row Nrow = sheet.createrow (number of rows);

4. Create a Cell object

Cell NCell = Nrow.createcell (number of columns);

5. Write content

Ncell.setcellvalue (the content to write );

6. Retouching

Create Style objects

font font = wb.createfont (); // Create Font object

font.setfontname (font set font

font.setfontheightinpoints (font size); set font size

bound font

ncell.setcellstyle (style); Apply Style

7. Save, close

OutputStream OS = new FileOutputStream (the path where the file is stored);

Wb.write (OS);

Os.flush ();

os.close ();

Getting Started with POI