java导出excel2007

code: 

/**   

     * @Description : 导出excel 

     * @param sheetName

     * @param columnNames

     * @param columnDatas

     * @param response    

     * @throws Exception   

     * @return : OutputStream   

     * @author : leijing   

     * @date : 2016年7月13日 下午5:18:37

     */

    public static OutputStream exportExcel2007(String sheetName ,List<String> columnNames ,List<List<String>>  columnDatas ,HttpServletResponse response ) throws Exception{

   

    String excelName =  sheetName + ".xlsx" ;

    OutputStream out = response .getOutputStream();

   

    renderExportFile( excelName , "application/vnd.ms-excel" , response );

   

    Workbook wb = new SXSSFWorkbook();

   

    CreationHelper createHelper = wb .getCreationHelper();

         Sheet sheet = wb .createSheet( sheetName );

         

          short index = 0;

          while ( index < columnNames .size()) {

              sheet .setColumnWidth( index , 6500);

              index ++;

         }

         

         Row row ;

         Cell cell ;

          row = sheet .createRow(0);

          for ( int j = 0; j < columnNames .size(); j ++){

              cell = row .createCell( j );

              cell .setCellValue( createHelper .createRichTextString( columnNames .get( j )));

         }

          for ( int i = 1; i <= columnDatas .size(); i ++){

              row = sheet .createRow( i );

             List<String> rowData = columnDatas .get( i - 1);

              for ( int j = 0; j < rowData .size(); j ++){

                  cell = row .createCell( j );

                 String value = rowData .get( j );

                  cell .setCellValue( createHelper .createRichTextString( value ));              

             }

         }

         

          wb .write( out );

          out .flush();

         

          return out ;

   

    }

maven:

          < dependency >

              < groupId > org.apache.poi </ groupId >

              < artifactId > poi </ artifactId >

              < version > 3.13 </ version >

          </ dependency >

          < dependency >  

            < groupId > org.apache.poi </ groupId >  

            < artifactId > poi-excelant </ artifactId >  

            < version > 3.13 </ version >  

        </ dependency >

excel还有其他的jar包

<!-- excel 1 -->

          < dependency >

              < groupId > net.sourceforge.jexcelapi </ groupId >

              < artifactId > jxl </ artifactId >

              < version > 2.6.12 </ version >

          </ dependency >