excel java 实例

POIFSFileSystem fs=new POIFSFileSystem(new   FileInputStream(cfname));  
                 HSSFWorkbook   wb   =   new   HSSFWorkbook(fs);  
               //  wb.removeSheetAt(2);  
                 HSSFSheet   sheet   =   wb.getSheetAt(0);  
                // sheet.setColumnWidth((short)200,(short)500);  
                 sheet.setColumnWidth((short)1, (short)4000);  //设置物料编号列的宽度
                 sheet.setColumnWidth((short)2, (short)12000); //设置物料描述列的宽度
                 sheet.setColumnWidth((short)4, (short)4000); // 设置图号列的宽度
                
                 HSSFFont hf=wb.createFont();
                 hf.setColor((short)4); //1:白色,2:红色,3:绿色,4:蓝色,5:黄色,6:紫色
                
                 HSSFCellStyle cs = wb.createCellStyle();              
    &