Poi action Excel 2007 set font style insert Picture

1. http://poi.apache.org/download required jar get Poi-bin-3.9-20121203.zip decompression

2. Import the required Jar:poi-ooxml-3.9-20121203.jar,poi-scratchpad-3.9-20121203.jar, Xmlbeans-2.3.0.jar,

Dom4j-1.6.1.jar,poi-3.9-20121203.jar,poi-ooxml-schemas-3.9-20121203.jar

3.http://wenku.baidu.com/view/b357ccac6bec0975f465e24a.html explanation of the comparative full

4. Solve a variety of different style problems in a cell,

The 第0-6个 character is set to define the font

        xssfrichtextstring richstring = new Xssfrichtextstring ("Hello, world!");
        Richstring.applyfont (0, 6, font);
        Cell.setcellvalue (richstring);

5.//worksheets are hidden, 0 = show 1 = Hide 2 = hidden (not found in Excel). But the program can find it.
Workbook.setsheethidden (Sheettemplateindex, 2);

6.excel operation needs to be clear. Workbook Sheet row Cell hierarchical relationship to find the corresponding operation level of Excel method