直接上代码：

官网上的抄的api例子：

package com.test;import java.io.File;import java.io.FileInputStream;import java.io.FileNotFoundException;import java.io.FileOutputStream;import java.io.IOException;import java.io.InputStream;import java.util.Calendar;import java.util.Date;import org.apache.poi.EncryptedDocumentException;import org.apache.poi.hssf.extractor.ExcelExtractor;import org.apache.poi.hssf.usermodel.HSSFWorkbook;import org.apache.poi.hssf.usermodel.HeaderFooter;import org.apache.poi.openxml4j.exceptions.InvalidFormatException;import org.apache.poi.openxml4j.opc.OPCPackage;import org.apache.poi.poifs.filesystem.NPOIFSFileSystem;import org.apache.poi.poifs.filesystem.POIFSFileSystem;import org.apache.poi.ss.usermodel.Cell;import org.apache.poi.ss.usermodel.CellStyle;import org.apache.poi.ss.usermodel.CreationHelper;import org.apache.poi.ss.usermodel.DataFormat;import org.apache.poi.ss.usermodel.DateUtil;import org.apache.poi.ss.usermodel.Font;import org.apache.poi.ss.usermodel.Footer;import org.apache.poi.ss.usermodel.IndexedColors;import org.apache.poi.ss.usermodel.PrintSetup;import org.apache.poi.ss.usermodel.Row;import org.apache.poi.ss.usermodel.Sheet;import org.apache.poi.ss.usermodel.Workbook;import org.apache.poi.ss.usermodel.WorkbookFactory;import org.apache.poi.ss.util.CellRangeAddress;import org.apache.poi.ss.util.CellReference;import org.apache.poi.ss.util.CellUtil;import org.apache.poi.ss.util.RegionUtil;import org.apache.poi.ss.util.WorkbookUtil;import org.apache.poi.xssf.usermodel.XSSFCell;import org.apache.poi.xssf.usermodel.XSSFCellStyle;import org.apache.poi.xssf.usermodel.XSSFColor;import org.apache.poi.xssf.usermodel.XSSFRow;import org.apache.poi.xssf.usermodel.XSSFSheet;import org.apache.poi.xssf.usermodel.XSSFWorkbook;import org.junit.Test;/** * 根据api一些简单操作 * @author Administrator * */public class CreateExcel {    String str="C:\\Users\\Administrator.PMIMP83HWNIKWOV\\Desktop\\poi\\create workbook";    public static void main(String[] args) {        CreateExcel ce=new CreateExcel();//        String str="C:\\Users\\Administrator.PMIMP83HWNIKWOV\\Desktop\\poi\\create workbook";//        ce.createSheet(new HSSFWorkbook(), str+"\\demo0.xls");//        ce.createCell();        ce.createDateCell();    }        /**     * 创建Workbook     */    public void createWorkbook(){                Workbook wb=null;        FileOutputStream fileOut=null;        try {            wb=new HSSFWorkbook();            fileOut=new FileOutputStream(str+"\\demo.xls");            wb.write(fileOut);            fileOut.close();                        wb=new XSSFWorkbook();            fileOut=new FileOutputStream(str+"\\demo1.xlsx");            wb.write(fileOut);            fileOut.close();        } catch (IOException e) {            e.printStackTrace();        }    }        //建表，不要问我为什么注释有些是英文的，官网上扣下来的    public void createSheet(Workbook wb,String filename){        Sheet sheet1=wb.createSheet("sheet1");        // Note that sheet name is Excel must not exceed 31 characters        // and must not contain any of the any of the following characters:        // 0x0000        // 0x0003        // colon (:)        // backslash (\)        // asterisk (*)        // question mark (?)        // forward slash (/)        // opening square bracket ([)        // closing square bracket (])        // You can use org.apache.poi.ss.util.WorkbookUtil#createSafeSheetName(String nameProposal)}        // for a safe way to create valid names, this utility replaces invalid characters with a space (' ')                String safeName=WorkbookUtil.createSafeSheetName("[O'Briend's sales*?]");//这个方法会去除名称字符串中的不合法字符        Sheet sheet3=wb.createSheet(safeName);        try {            FileOutputStream fileOut=new FileOutputStream(filename, true);            wb.write(fileOut);            fileOut.close();        } catch (FileNotFoundException e) {            e.printStackTrace();        } catch (IOException e) {            e.printStackTrace();        }    }        /**     * 创建细胞，也就是创建格子     */    public void createCell(){        Workbook wb=new HSSFWorkbook();//xsl        //Workbook wb=new XSSFWorkbook();        CreationHelper createHelper=wb.getCreationHelper();        Sheet sheet=wb.createSheet("sheet3");                //create a row and put some cells in it.Rows are 0 based        Row row=sheet.createRow((short)0);        //create a cell and put a value in it        Cell cell=row.createCell(0);//不填写类型的话，默认的类型是this.createCell(column,HSSFCell.CELL_TYPE_BLANK);        cell.setCellValue(1);                //or do it on one line        row.createCell(1).setCellValue(1.2);//创建和赋值连成一行        row.createCell(2).setCellValue(createHelper.createRichTextString("This is a string"));        row.createCell(3).setCellValue(true);        row.createCell(4).setCellValue("nihao");                //write the output to a file        try {                        FileOutputStream fileOut=new FileOutputStream("C:\\Users\\Administrator.PMIMP83HWNIKWOV\\Desktop\\poi\\create workbook\\demo.xls",true);            wb.write(fileOut);            fileOut.close();        } catch (FileNotFoundException e) {            e.printStackTrace();        } catch (IOException e) {            e.printStackTrace();        }    }        //创建日期类型cell    public void createDateCell(){        Workbook wb=new HSSFWorkbook();        //Workbook wb=new XSSFWorkbook();        CreationHelper createHelper=wb.getCreationHelper();        Sheet sheet=wb.createSheet("new sheet");                Row row=sheet.createRow(0);        //create a row and put a date value in it.The first cell is not styled as a date.        Cell cell=row.createCell(0);        cell.setCellValue(new Date());                //we style the second cell as a date (and time).It is important to create a new         //cell style from the workbook oterwise you can end up modifying the builting in style and effecting not only this cell but other cells        //设置日期的格式是分厂重要的        CellStyle cellStyle=wb.createCellStyle();        cellStyle.setDataFormat(                createHelper.createDataFormat().getFormat("m/d/yy h:mm")        )    ;        cell=row.createCell(1);        cell.setCellValue(new Date());        cell.setCellStyle(cellStyle);                //write the output to a file        FileOutputStream fileOut;        try {                        fileOut = new FileOutputStream(str+"\\demo4.xls");            wb.write(fileOut);            fileOut.close();        } catch (FileNotFoundException e) {            e.printStackTrace();        } catch (IOException e) {            e.printStackTrace();        }            }        //使用不同类型的cell    @Test    public void useOtherTypeCell(){        Workbook wb=new HSSFWorkbook();        Sheet sheet=wb.createSheet("new sheet");        Row row=sheet.createRow((short)2);        row.createCell(0).setCellValue(1.1);        row.createCell(1).setCellValue(new Date());        row.createCell(2).setCellValue(Calendar.getInstance());        row.createCell(3).setCellValue("a string");        row.createCell(4).setCellValue(true);        row.createCell(5).setCellType(Cell.CELL_TYPE_ERROR);                //write the output to a file        FileOutputStream fileOut;        try {                        fileOut = new FileOutputStream(str+"\\demo5.xls");            wb.write(fileOut);            fileOut.close();        } catch (FileNotFoundException e) {            e.printStackTrace();        } catch (IOException e) {            e.printStackTrace();        }    }        //文件VS输入流    @Test    public void FileVSStream(){        //打开工作薄时，要么.xsl HSSFWorkbook或.xlsx XSSFWorkbook,可以从一个工作薄 文件 或者一个InputStream，使用一个文件对象允许更低的        //内存消耗，而一个InputStream需要更多的内存缓冲区                //使用WorkbookFactory获取Workbook        try {            Workbook wb=WorkbookFactory.create(new File(str+"\\MyExcel.xlsx"));        } catch (EncryptedDocumentException e) {            e.printStackTrace();        } catch (InvalidFormatException e) {            e.printStackTrace();        } catch (IOException e) {            e.printStackTrace();        }                //使用InputStream获取Workbook对象        try {            Workbook wb=WorkbookFactory.create(new FileInputStream(str+"\\MyExcel.xlsx"));                    } catch (EncryptedDocumentException e) {            e.printStackTrace();        } catch (InvalidFormatException e) {            e.printStackTrace();        } catch (FileNotFoundException e) {            e.printStackTrace();        } catch (IOException e) {            e.printStackTrace();        }                //如果使用HSSFWorkbook或者XSSFWorkbook直接，通常应该使用NPOIFSFileSystem或OPCPackage 有完全控制的生命周期（包括完成后关闭该文件）        try {            NPOIFSFileSystem fs=new NPOIFSFileSystem(new File(str+"\\MyExcel.xls"));            HSSFWorkbook wb=new HSSFWorkbook(fs.getRoot(),true);            //...            fs.close();        } catch (IOException e) {            e.printStackTrace();        }        try {            NPOIFSFileSystem fs=new NPOIFSFileSystem(new FileInputStream(str+"\\MyExcel.xls"));            HSSFWorkbook wb=new HSSFWorkbook(fs.getRoot(),true);            //...            fs.close();        } catch (IOException e) {            e.printStackTrace();        }        //XXSFWorkbook        try {            OPCPackage pkg=OPCPackage.open(new File(str+"\\MyExcel.xlsx"));            XSSFWorkbook wb=new XSSFWorkbook(pkg);            //...            pkg.close();        } catch (InvalidFormatException e) {            e.printStackTrace();        } catch (IOException e) {            e.printStackTrace();        }        try {            OPCPackage pkg=OPCPackage.open(new FileInputStream(str+"\\MyExcel.xlsx"));            XSSFWorkbook wb=new XSSFWorkbook(pkg);            //...            pkg.close();        } catch (InvalidFormatException e) {            e.printStackTrace();        } catch (IOException e) {            e.printStackTrace();        }    }        //演示各种对齐选项    @Test    public void alignTest(){        Workbook wb=new XSSFWorkbook();                Sheet sheet=wb.createSheet();        Row row=sheet.createRow((short)2);        row.setHeightInPoints(30);//设置行高                createCell(wb,row,(short)0,CellStyle.ALIGN_CENTER,CellStyle.VERTICAL_BOTTOM);        createCell(wb,row,(short)1,CellStyle.ALIGN_CENTER_SELECTION,CellStyle.VERTICAL_BOTTOM);        createCell(wb,row,(short)2,CellStyle.ALIGN_FILL,CellStyle.VERTICAL_CENTER);        createCell(wb,row,(short)3,CellStyle.ALIGN_GENERAL, CellStyle.VERTICAL_CENTER);        createCell(wb, row, (short) 4, CellStyle.ALIGN_JUSTIFY, CellStyle.VERTICAL_JUSTIFY);        createCell(wb, row, (short) 5, CellStyle.ALIGN_LEFT, CellStyle.VERTICAL_TOP);        createCell(wb, row, (short) 6, CellStyle.ALIGN_RIGHT, CellStyle.VERTICAL_TOP);                //write the output to a file        FileOutputStream fileOut;        try {            fileOut = new FileOutputStream(str+"\\xssf-align.xlsx");             wb.write(fileOut);             fileOut.close();        } catch (FileNotFoundException e) {            e.printStackTrace();        } catch (IOException e) {            e.printStackTrace();        }           }    public void createCell(Workbook wb,Row row,short column,short halign,short valign){        Cell cell=row.createCell(column);        cell.setCellValue("Align It");        CellStyle cellStyle=wb.createCellStyle();        cellStyle.setAlignment(halign);        cellStyle.setVerticalAlignment(valign);        cell.setCellStyle(cellStyle);    }        //使用边界    @Test    public void usrBorder(){        Workbook wb=new HSSFWorkbook();        Sheet sheet=wb.createSheet("new sheet");                Row row=sheet.createRow(1);                Cell cell=row.createCell(1);        cell.setCellValue(4);                //style the cell with borders all around        CellStyle style=wb.createCellStyle();        style.setBorderBottom(CellStyle.BORDER_THIN);        style.setBottomBorderColor(IndexedColors.BLACK.getIndex());        style.setBorderLeft(CellStyle.BORDER_THIN);        style.setLeftBorderColor(IndexedColors.GREEN.getIndex());        style.setBorderRight(CellStyle.BORDER_THIN);        style.setRightBorderColor(IndexedColors.BLUE.getIndex());        style.setBorderTop(CellStyle.BORDER_MEDIUM_DASHED);        style.setTopBorderColor(IndexedColors.BLACK.getIndex());        cell.setCellStyle(style);                FileOutputStream fileOut;        try {            fileOut = new FileOutputStream(str+"\\demo7.xls");             wb.write(fileOut);             fileOut.close();        } catch (FileNotFoundException e) {            e.printStackTrace();        } catch (IOException e) {            e.printStackTrace();        }    }        @Test    public void IteratorRowAndCell(){        //有时候，你想遍历workbook，一个表中的所有行或者所有的cell        /*         *workbook.sheetIterator(),sheet.rowIterator(),row.cellIterator() ,或者隐式地使用forEach         *注意使用迭代器等遍历注意间隔和空缝隙         */    }        public void IteratorWhiteCell(Sheet sheet){        int rowStart=Math.min(15,sheet.getFirstRowNum());        int rowEnd=Math.max(1400, sheet.getLastRowNum());                for(int rowNum=rowStart;rowNum

简单解析excel：

package com.test;import java.io.File;import java.io.IOException;import org.apache.poi.EncryptedDocumentException;import org.apache.poi.openxml4j.exceptions.InvalidFormatException;import org.apache.poi.ss.usermodel.Cell;import org.apache.poi.ss.usermodel.Row;import org.apache.poi.ss.usermodel.Sheet;import org.apache.poi.ss.usermodel.Workbook;import org.apache.poi.ss.usermodel.WorkbookFactory;/*  static int     CELL_TYPE_BLANK          Blank Cell type (3)static int     CELL_TYPE_BOOLEAN          Boolean Cell type (4)static int     CELL_TYPE_ERROR          Error Cell type (5)static int     CELL_TYPE_FORMULA          Formula Cell type (2)static int     CELL_TYPE_NUMERIC          Numeric Cell type (0)static int     CELL_TYPE_STRING          String Cell type (1) */public class ParseexcelDemo {    public static void main(String[] args) {        ParseexcelDemo pxd=new ParseexcelDemo();        pxd.parseXml("C:\\Users\\Administrator.PMIMP83HWNIKWOV\\Desktop\\poi\\create workbook\\学员烧烤通讯录表.xlsx");    }    public void parseXml(String filename){        Workbook wb=null;        try {            wb=WorkbookFactory.create(new File(filename));            Sheet sheet=wb.getSheetAt(0);                        for(Row row:sheet){                                for(Cell cell:row){                    System.out.print(getCellValue(cell)+"---");                }                System.out.println();            }        } catch (EncryptedDocumentException e) {            e.printStackTrace();        } catch (InvalidFormatException e) {            e.printStackTrace();        } catch (IOException e) {            e.printStackTrace();        }    }        public Object getCellValue(Cell cell){        int type=cell.getCellType();        String show=null;        switch(type){        case Cell.CELL_TYPE_BLANK:            show=null;break;        case Cell.CELL_TYPE_BOOLEAN:            show= String.valueOf(cell.getBooleanCellValue());break;        case Cell.CELL_TYPE_ERROR:            show=String.valueOf(cell.getErrorCellValue());break;        case Cell.CELL_TYPE_FORMULA:            show=cell.getCellFormula();break;        case Cell.CELL_TYPE_NUMERIC:            show=String.valueOf(cell.getNumericCellValue());break;        case Cell.CELL_TYPE_STRING:            show=cell.getStringCellValue();break;        default:            show=null;        }        return show;    }}

简单创建excel：

package com.listenerVedio;import java.io.FileNotFoundException;import java.io.FileOutputStream;import java.io.IOException;import org.apache.poi.hssf.usermodel.HSSFWorkbook;import org.apache.poi.ss.usermodel.Cell;import org.apache.poi.ss.usermodel.CellStyle;import org.apache.poi.ss.usermodel.Row;import org.apache.poi.ss.usermodel.Sheet;import org.apache.poi.ss.usermodel.Workbook;import org.junit.Test;public class PotTest1 {    @Test    public void TestWrite01(){        Workbook wb=new HSSFWorkbook();        FileOutputStream fos=null;        try {            fos=new FileOutputStream("d:/test/poi/w1.xls");            Sheet sheet=wb.createSheet("测试01");            Row row=sheet.createRow(0);            row.setHeightInPoints(30);//设置行高            CellStyle cs=wb.createCellStyle();//新建单元格样式对象            //我们可以使用CellStyle设置单元格的一些关于美化方向的属性，比如颜色，边框，背景等            cs.setAlignment(CellStyle.ALIGN_CENTER);//设置水平居中            cs.setVerticalAlignment(CellStyle.VERTICAL_CENTER);//设置垂直居中            /*            cs.setBorderBottom((short)1);//设置边框样式 这里发现边框设置样式失败。原来设置边框中使用的是样式的常量            cs.setBorderTop((short)1);            cs.setBorderLeft((short)1);            cs.setBorderRight((short)1);            */            cs.setBorderBottom(CellStyle.BORDER_DASH_DOT);            cs.setBorderLeft(CellStyle.BORDER_MEDIUM_DASH_DOT_DOT);            Cell c=row.createCell(0);            c.setCellStyle(cs);//给单元格设置样式            c.setCellValue("标识");            c=row.createCell(1);            c.setCellStyle(cs);            c.setCellValue("用户名");            wb.write(fos);            wb.close();        } catch (FileNotFoundException e) {            e.printStackTrace();        } catch (IOException e) {            e.printStackTrace();        }                /**         * 发现这样写是不现实的，因为设置一个单元格样式太过麻烦。虽然使用for、循环可以达到效果         * 我 们习惯于创建一个模板，模板里面将样式定好，然后我们填充模板里面的元素，然后用来完成数据的导出         * 能够根据excel转换成对象，能够将对象导成excel，能够带模板的方式导出excel。终极目标         *         * 一些思路：如何将对象导出成excel，首先需要有对象，对象一般不是你的实体类而是专门用来导出的自定义对象，应为导出对象的列应该不是所有的         * 如何确定顶部的标题：使用注解实现。创建Annotation，在其中说明这是excel的resource，顺序也是使用注解实现         *          */    }}

使用模板简单创建excel：

package com.util;import java.io.File;import java.io.FileNotFoundException;import java.io.FileOutputStream;import java.io.IOException;import java.io.OutputStream;import java.util.Calendar;import java.util.Date;import java.util.HashMap;import java.util.Map;import org.apache.poi.openxml4j.exceptions.InvalidFormatException;import org.apache.poi.ss.usermodel.Cell;import org.apache.poi.ss.usermodel.CellStyle;import org.apache.poi.ss.usermodel.RichTextString;import org.apache.poi.ss.usermodel.Row;import org.apache.poi.ss.usermodel.Sheet;import org.apache.poi.ss.usermodel.Workbook;import org.apache.poi.ss.usermodel.WorkbookFactory;/** * Excel模板 * @author Administrator * */public class ExcelTemplate {    private static ExcelTemplate et=new ExcelTemplate();    public final static String DATA_LINE="datas";    public final static String DEFAULT_STYLE="defaultStyle";    public final static String OWNSTYLE="style";    private Workbook wb;    private Sheet sheet;    /**     * 数据的初始化列     */    private int initColIndex;    /**     * 数据的初始化行     */    private int initRowIndex;    /**     * 数据的当前列     */    private int curColIndex;    /**     * 数据的当前行     */    private int curRowIndex;    /**     * 数据的最后一行     */    private int lastRowIndex;    /**     * 当前行对象     */    private Row curRow;    /**     * 默认样式     */    private CellStyle defaultStyle;    /**     * 自定义的样式的集合     */    private Map
      
        styles;    /**     * 数据列行高     */    private float dataLineHeight;    /**     * 单例获取et     * @return     */    public static ExcelTemplate getInstance(){        return et;    }    /**     * 根据classPath读取模板     * @param classPath     * @return     */    public ExcelTemplate readTemplateByClasspath(String classPath){        try {            wb=WorkbookFactory.create(ExcelTemplate.class.getResourceAsStream(classPath));        } catch (InvalidFormatException e) {            e.printStackTrace();            throw new RuntimeException("取读模板格式有误！请检查");        } catch (IOException e) {            e.printStackTrace();            throw new RuntimeException("取读的模板不存在！请检查");        }        initTemp();        return et;    }    /**     * 根据filePath读取模板     * @param filePath     * @return     */    public ExcelTemplate  readTemplateByFilepath(String filePath){        try {            wb=WorkbookFactory.create(new File(filePath));        }catch (InvalidFormatException e) {            e.printStackTrace();            throw new RuntimeException("取读模板格式有误！请检查");        } catch (IOException e) {            e.printStackTrace();            throw new RuntimeException("取读的模板不存在！请检查");        }        initTemp();        return et;    }    /**     * 将Workbook写入文件     * @param filePath     */    public void writeToFile(String filePath){        FileOutputStream fos=null;        try {            fos=new FileOutputStream(filePath);            wb.write(fos);        } catch (FileNotFoundException e) {            e.printStackTrace();            throw new RuntimeException("写入的文件不存在！"+e.getMessage());        } catch (IOException e) {            e.printStackTrace();            throw new RuntimeException("写入数据失败！"+e.getMessage());        }finally{            try {                if(fos!=null){                    fos.close();                }            } catch (IOException e) {                e.printStackTrace();            }        }    }    /**     * 将Workbook写入输出流     * @param os     */    public void writeToStream(OutputStream os){        try {            wb.write(os);        } catch (IOException e) {            e.printStackTrace();            throw new RuntimeException("写入流失败！"+e.getMessage());        }    }    /**     * 初始化模板     */    public void initTemp(){        sheet=wb.getSheetAt(0);        initConfigData();        curRow=sheet.getRow(initRowIndex);    }    /**     * 获取初始化配置数据     */    private void initConfigData() {        lastRowIndex=sheet.getLastRowNum();        styles=new HashMap
       
        ();        int styleinRow=0;        for(Row row:sheet){            for(Cell cell:row){                if(cell.getCellType()!=Cell.CELL_TYPE_STRING) continue;                String str=cell.getStringCellValue().trim();                if(str.equals(DATA_LINE)){                    curColIndex=initColIndex=cell.getColumnIndex();                    curRowIndex=initRowIndex=cell.getRowIndex();                    dataLineHeight=row.getHeightInPoints();                }                if(str.equals(DEFAULT_STYLE)){                    defaultStyle=cell.getCellStyle();                    styleinRow=cell.getRowIndex();                }                if(str.equals(OWNSTYLE)){                    styles.put(cell.getColumnIndex(), cell.getCellStyle());                    styleinRow=cell.getRowIndex();                }                                /**                 * 后面可以附加好多其他东西                 */                            }        }        //sheet.removeRow(sheet.getRow(styleinRow));//这里将设置样式的一行删除，样式已经完成了        /*直接删除不能实现下面的行自动往上顶，使用移动下面的行将前面的行覆盖实现*/        sheet.shiftRows(styleinRow+1,lastRowIndex--, -1, true, true);    }    /**     * 创建新行     */    public void createNewRow(){        moveData();        curRow=sheet.createRow(++curRowIndex);        curRow.setHeightInPoints(dataLineHeight);        curColIndex=initColIndex;    }    /**     * 创建新列并为新列赋值     * @param value     */    public void createCell(String value){        Cell c=curRow.createCell(curColIndex);        if(styles.containsKey(curColIndex))            c.setCellStyle(styles.get(curColIndex));        else            c.setCellStyle(defaultStyle);        c.setCellValue(value);        curColIndex++;    }    public void createCell(int value){        Cell c=curRow.createCell(curColIndex);        if(styles.containsKey(curColIndex))            c.setCellStyle(styles.get(curColIndex));        else            c.setCellStyle(defaultStyle);        c.setCellValue(value);        curColIndex++;    }    public void createCell(double value){        Cell c=curRow.createCell(curColIndex);        if(styles.containsKey(curColIndex))            c.setCellStyle(styles.get(curColIndex));        else            c.setCellStyle(defaultStyle);        c.setCellValue(value);        curColIndex++;    }    public void createCell(boolean value){        Cell c=curRow.createCell(curColIndex);        if(styles.containsKey(curColIndex))            c.setCellStyle(styles.get(curColIndex));        else            c.setCellStyle(defaultStyle);        c.setCellValue(value);        curColIndex++;    }    public void createCell(Date value){        Cell c=curRow.createCell(curColIndex);        if(styles.containsKey(curColIndex))            c.setCellStyle(styles.get(curColIndex));        else            c.setCellStyle(defaultStyle);        c.setCellValue(value);        curColIndex++;    }    public void createCell(Calendar value){        Cell c=curRow.createCell(curColIndex);        if(styles.containsKey(curColIndex))            c.setCellStyle(styles.get(curColIndex));        else            c.setCellStyle(defaultStyle);        c.setCellValue(value);        curColIndex++;    }    public void createCell(RichTextString value){        Cell c=curRow.createCell(curColIndex);        if(styles.containsKey(curColIndex))            c.setCellStyle(styles.get(curColIndex));        else            c.setCellStyle(defaultStyle);        c.setCellValue(value);        curColIndex++;    }        /**     * 将excel尾部描述列往后移动     */    private void moveData(){        sheet.shiftRows(curRowIndex+1, lastRowIndex++, 1,true, true);        }    /**     * 设置序号 可选     */    public void insertSerial(){        int serialRow=-1;        int serialCol=-1;        boolean findSerial=false;        for(Row row:sheet){            if(findSerial) break;            for(Cell cell:row){                if(cell.getCellType()!=Cell.CELL_TYPE_STRING) continue;                String str=cell.getStringCellValue().trim();                if(str.equals("serial")){                    serialRow=cell.getRowIndex();                    serialCol=cell.getColumnIndex();                    findSerial=true;                    break;                }            }        }        if(serialRow==-1 || serialCol==-1){            return;        }        int count=curRowIndex-initRowIndex+1;        for(int i=1;i<=count;i++){            Cell c=sheet.getRow(serialRow++).createCell(serialCol);            c.setCellValue(i);        }    }    /**     * 为一些变量赋值     * @param datas     */    public void replaceVariable(Map
        
          datas){        for(Row row:sheet){            for(Cell cell:row){                if(cell.getCellType()!=Cell.CELL_TYPE_STRING) continue;                String str=cell.getStringCellValue().trim();                if(!str.startsWith("#")) continue;                if(datas.containsKey(str.substring(1))){                    cell.setCellValue(datas.get(str.substring(1)));                }            }        }    }}
        
       
      

实现excel和对象之间的转换：

package com.ann;import java.lang.annotation.ElementType;import java.lang.annotation.Retention;import java.lang.annotation.RetentionPolicy;import java.lang.annotation.Target;@Retention(RetentionPolicy.RUNTIME)@Target({ElementType.FIELD})public @interface Column {    String title();    int order() default 9999;}package com.entity;import com.ann.Column;/** * 用户类 * @author Administrator * */public class User{    @Column(title="编号",order=1)    private int id;    @Column(title="姓名",order=2)    private String name;    @Column(title="年龄",order=3)    private int age;    @Column(title="邮箱",order=4)    private String email;    public int getId() {        return id;    }    public void setId(int id) {        this.id = id;    }    public String getName() {        return name;    }    public void setName(String name) {        this.name = name;    }    public int getAge() {        return age;    }    public void setAge(int age) {        this.age = age;    }    public String getEmail() {        return email;    }    public void setEmail(String email) {        this.email = email;    }    public User() {        super();    }    public User(int id, String name, int age, String email) {        super();        this.id = id;        this.name = name;        this.age = age;        this.email = email;    }    @Override    public String toString() {        return "User [id=" + id + ", name=" + name + ", age=" + age                + ", email=" + email + "]";    }        }package com.util;/** * 列标题列顺序和对应对象字段组成的自定义对象 * excel和Object的中间对象 * @author Administrator * */public class ExcelHeader implements Comparable
      
       {    /**     * excel的标题名     */    private String title;    /**     * 每一个标题的顺序     */    private int order;    /**     * 每一个列对应的字段名     * @return     */    private String fieldName;    public String getTitle() {        return title;    }    public void setTitle(String title) {        this.title = title;    }    public ExcelHeader(String title, int order,String filedName) {        super();        this.title = title;        this.order = order;        this.fieldName=filedName;    }    public ExcelHeader() {        super();            }        @Override    public String toString() {        return "ExcelHeader [title=" + title + ", order=" + order                + ", fieldName=" + fieldName + "]";    }    public int getOrder() {        return order;    }    public void setOrder(int order) {        this.order = order;    }    @Override    public int compareTo(ExcelHeader o) {        return order>o.order?1:(order==o.order?0:-1);    }    public void setFieldName(String fieldName) {        this.fieldName = fieldName;    }    public String getFieldName() {        return fieldName;    }    }package com.util;import java.io.File;import java.io.FileNotFoundException;import java.io.FileOutputStream;import java.io.IOException;import java.io.OutputStream;import java.util.Calendar;import java.util.Date;import java.util.HashMap;import java.util.Map;import org.apache.poi.openxml4j.exceptions.InvalidFormatException;import org.apache.poi.ss.usermodel.Cell;import org.apache.poi.ss.usermodel.CellStyle;import org.apache.poi.ss.usermodel.RichTextString;import org.apache.poi.ss.usermodel.Row;import org.apache.poi.ss.usermodel.Sheet;import org.apache.poi.ss.usermodel.Workbook;import org.apache.poi.ss.usermodel.WorkbookFactory;/** * Excel模板 * @author Administrator * */public class ExcelTemplate {    private static ExcelTemplate et=new ExcelTemplate();    public final static String DATA_LINE="datas";    public final static String DEFAULT_STYLE="defaultStyle";    public final static String OWNSTYLE="style";    private Workbook wb;    private Sheet sheet;    /**     * 数据的初始化列     */    private int initColIndex;    /**     * 数据的初始化行     */    private int initRowIndex;    /**     * 数据的当前列     */    private int curColIndex;    /**     * 数据的当前行     */    private int curRowIndex;    /**     * 数据的最后一行     */    private int lastRowIndex;    /**     * 当前行对象     */    private Row curRow;    /**     * 默认样式     */    private CellStyle defaultStyle;    /**     * 自定义的样式的集合     */    private Map
       
         styles;    /**     * 数据列行高     */    private float dataLineHeight;    /**     * 单例获取et     * @return     */    public static ExcelTemplate getInstance(){        return et;    }    /**     * 根据classPath读取模板     * @param classPath     * @return     */    public ExcelTemplate readTemplateByClasspath(String classPath){        try {            wb=WorkbookFactory.create(ExcelTemplate.class.getResourceAsStream(classPath));        } catch (InvalidFormatException e) {            e.printStackTrace();            throw new RuntimeException("取读模板格式有误！请检查");        } catch (IOException e) {            e.printStackTrace();            throw new RuntimeException("取读的模板不存在！请检查");        }        initTemp();        return et;    }    /**     * 根据filePath读取模板     * @param filePath     * @return     */    public ExcelTemplate  readTemplateByFilepath(String filePath){        try {            wb=WorkbookFactory.create(new File(filePath));        }catch (InvalidFormatException e) {            e.printStackTrace();            throw new RuntimeException("取读模板格式有误！请检查");        } catch (IOException e) {            e.printStackTrace();            throw new RuntimeException("取读的模板不存在！请检查");        }        initTemp();        return et;    }    /**     * 将Workbook写入文件     * @param filePath     */    public void writeToFile(String filePath){        FileOutputStream fos=null;        try {            fos=new FileOutputStream(filePath);            wb.write(fos);        } catch (FileNotFoundException e) {            e.printStackTrace();            throw new RuntimeException("写入的文件不存在！"+e.getMessage());        } catch (IOException e) {            e.printStackTrace();            throw new RuntimeException("写入数据失败！"+e.getMessage());        }finally{            try {                if(fos!=null){                    fos.close();                }            } catch (IOException e) {                e.printStackTrace();            }        }    }    /**     * 将Workbook写入输出流     * @param os     */    public void writeToStream(OutputStream os){        try {            wb.write(os);        } catch (IOException e) {            e.printStackTrace();            throw new RuntimeException("写入流失败！"+e.getMessage());        }    }    /**     * 初始化模板     */    public void initTemp(){        sheet=wb.getSheetAt(0);        initConfigData();        curRow=sheet.getRow(initRowIndex);    }    /**     * 获取初始化配置数据     */    private void initConfigData() {        lastRowIndex=sheet.getLastRowNum();        styles=new HashMap
        
         ();        int styleinRow=0;        for(Row row:sheet){            for(Cell cell:row){                if(cell.getCellType()!=Cell.CELL_TYPE_STRING) continue;                String str=cell.getStringCellValue().trim();                if(str.equals(DATA_LINE)){                    curColIndex=initColIndex=cell.getColumnIndex();                    curRowIndex=initRowIndex=cell.getRowIndex();                    dataLineHeight=row.getHeightInPoints();                }                if(str.equals(DEFAULT_STYLE)){                    defaultStyle=cell.getCellStyle();                    styleinRow=cell.getRowIndex();                }                if(str.equals(OWNSTYLE)){                    styles.put(cell.getColumnIndex(), cell.getCellStyle());                    styleinRow=cell.getRowIndex();                }                                /**                 * 后面可以附加好多其他东西                 */                            }        }        //sheet.removeRow(sheet.getRow(styleinRow));//这里将设置样式的一行删除，样式已经完成了        /*直接删除不能实现下面的行自动往上顶，使用移动下面的行将前面的行覆盖实现*/        sheet.shiftRows(styleinRow+1,lastRowIndex--, -1, true, true);    }    /**     * 创建新行     */    public void createNewRow(){        moveData();        curRow=sheet.createRow(++curRowIndex);        curRow.setHeightInPoints(dataLineHeight);        curColIndex=initColIndex;    }    /**     * 创建新列并为新列赋值     * @param value     */    public void createCell(String value){        Cell c=curRow.createCell(curColIndex);        if(styles.containsKey(curColIndex))            c.setCellStyle(styles.get(curColIndex));        else            c.setCellStyle(defaultStyle);        c.setCellValue(value);        curColIndex++;    }    public void createCell(int value){        Cell c=curRow.createCell(curColIndex);        if(styles.containsKey(curColIndex))            c.setCellStyle(styles.get(curColIndex));        else            c.setCellStyle(defaultStyle);        c.setCellValue(value);        curColIndex++;    }    public void createCell(double value){        Cell c=curRow.createCell(curColIndex);        if(styles.containsKey(curColIndex))            c.setCellStyle(styles.get(curColIndex));        else            c.setCellStyle(defaultStyle);        c.setCellValue(value);        curColIndex++;    }    public void createCell(boolean value){        Cell c=curRow.createCell(curColIndex);        if(styles.containsKey(curColIndex))            c.setCellStyle(styles.get(curColIndex));        else            c.setCellStyle(defaultStyle);        c.setCellValue(value);        curColIndex++;    }    public void createCell(Date value){        Cell c=curRow.createCell(curColIndex);        if(styles.containsKey(curColIndex))            c.setCellStyle(styles.get(curColIndex));        else            c.setCellStyle(defaultStyle);        c.setCellValue(value);        curColIndex++;    }    public void createCell(Calendar value){        Cell c=curRow.createCell(curColIndex);        if(styles.containsKey(curColIndex))            c.setCellStyle(styles.get(curColIndex));        else            c.setCellStyle(defaultStyle);        c.setCellValue(value);        curColIndex++;    }    public void createCell(RichTextString value){        Cell c=curRow.createCell(curColIndex);        if(styles.containsKey(curColIndex))            c.setCellStyle(styles.get(curColIndex));        else            c.setCellStyle(defaultStyle);        c.setCellValue(value);        curColIndex++;    }        /**     * 将excel尾部描述列往后移动     */    private void moveData(){        sheet.shiftRows(curRowIndex+1, lastRowIndex++, 1,true, true);        }    /**     * 设置序号 可选     */    public void insertSerial(){        int serialRow=-1;        int serialCol=-1;        boolean findSerial=false;        for(Row row:sheet){            if(findSerial) break;            for(Cell cell:row){                if(cell.getCellType()!=Cell.CELL_TYPE_STRING) continue;                String str=cell.getStringCellValue().trim();                if(str.equals("serial")){                    serialRow=cell.getRowIndex();                    serialCol=cell.getColumnIndex();                    findSerial=true;                    break;                }            }        }        if(serialRow==-1 || serialCol==-1){            return;        }        int count=curRowIndex-initRowIndex+1;        for(int i=1;i<=count;i++){            Cell c=sheet.getRow(serialRow++).createCell(serialCol);            c.setCellValue(i);        }    }    /**     * 为一些变量赋值     * @param datas     */    public void replaceVariable(Map
         
           datas){        for(Row row:sheet){            for(Cell cell:row){                if(cell.getCellType()!=Cell.CELL_TYPE_STRING) continue;                String str=cell.getStringCellValue().trim();                if(!str.startsWith("#")) continue;                if(datas.containsKey(str.substring(1))){                    cell.setCellValue(datas.get(str.substring(1)));                }            }        }    }}package com.util;import java.io.File;import java.io.FileNotFoundException;import java.io.FileOutputStream;import java.io.IOException;import java.io.InputStream;import java.io.OutputStream;import java.lang.reflect.Field;import java.lang.reflect.InvocationTargetException;import java.util.ArrayList;import java.util.Collections;import java.util.HashMap;import java.util.List;import java.util.Map;import java.util.Properties;import java.util.Set;import org.apache.commons.beanutils.BeanUtils;import org.apache.poi.EncryptedDocumentException;import org.apache.poi.hssf.usermodel.HSSFWorkbook;import org.apache.poi.openxml4j.exceptions.InvalidFormatException;import org.apache.poi.ss.usermodel.Cell;import org.apache.poi.ss.usermodel.Row;import org.apache.poi.ss.usermodel.Sheet;import org.apache.poi.ss.usermodel.Workbook;import org.apache.poi.ss.usermodel.WorkbookFactory;import org.apache.poi.xssf.usermodel.XSSFWorkbook;import com.ann.Column;/** * 对象和excel之间的互相转换 * 使用模板写入excel与不使用模板写入 * 读取excel数据到对象集合 * @author Administrator * */@SuppressWarnings({
     "rawtypes","unchecked"})public class ExcelUtil {    private static ExcelUtil eu=new ExcelUtil();    /**     * 单例     */    private ExcelUtil(){}    /**     * excel字段内容对象集合     */    private List
          
            headers;        public static ExcelUtil getInstance(){        return eu;    }    /**     * 模板对象     */    private ExcelTemplate et;    /**     * excel工作薄对象     */    private Workbook wb;    /**     * 将对象插入到excel表格中，使用模板，目标是文件     * @param datas     * @param alertableValues     * @param objectClassType     * @param path     * @param isFilePath     * @param outPath     */    public void Obj2ExcelUseTemplate(List