POI问题

Workbook workBook = Util.createWorkBook("E:/test2.xls");

		Sheet sheet = workBook.getSheetAt(0);

		sheet.setDefaultColumnWidth(8);

		

		CellRangeAddress range = Util.getRange(sheet)[0];

		

		int startRow = range.getFirstRow();

		int endRow = range.getLastRow();

		

		double rowHeight = 0;

		Row row;

		for(int i = startRow;i <= endRow;i ++){

			row = sheet.getRow(i);

			rowHeight += row.getHeightInPoints();

		}

		rowHeight *= 1.33;

		int height = Double.valueOf(rowHeight).intValue();

		

		int startColumn = range.getFirstColumn();

		int endColumn = range.getLastColumn();

		double columnWidth = 0;

		for(int i = startColumn;i <= endColumn;i ++){

			columnWidth += sheet.getColumnWidth(i);

		}

		columnWidth /= 256;

		columnWidth *= 8;

		columnWidth *= 1.13;

		int width = Double.valueOf(columnWidth).intValue();

//		

//		System.out.println("height:" + height + ",width:" + width);

		

//		Workbook workBook = new HSSFWorkbook();

//		Sheet sheet = workBook.createSheet();

		CreationHelper helper = workBook.getCreationHelper();

		ClientAnchor anchor = helper.createClientAnchor();

		

		anchor.setAnchorType(ClientAnchor.DONT_MOVE_AND_RESIZE);

		anchor.setCol1(3);

		anchor.setRow1(4);

		Drawing draw = sheet.createDrawingPatriarch();

		Picture pic = draw.createPicture(anchor, workBook.addPicture(createPic(800, 600), Workbook.PICTURE_TYPE_PNG));

		pic.resize();

		

		OutputStream out = new FileOutputStream("E:/test1.xls");

		workBook.write(out);

		out.close();

public static void main(String[] args) {   

            FileOutputStream fileOut = null;   

            BufferedImage bufferImg =null;   

            BufferedImage bufferImg1 = null;   

            try{   

          //先把读进来的图片放到一个ByteArrayOutputStream中，以便产生ByteArray   

          ByteArrayOutputStream byteArrayOut = new ByteArrayOutputStream();   

          ByteArrayOutputStream byteArrayOut1 = new ByteArrayOutputStream();   

          bufferImg = ImageIO.read(new File("C:/Documents and Settings/dingqi/Desktop/clip_image002.jpg"));   

          bufferImg1 = ImageIO.read(new File("C:/Documents and Settings/dingqi/Desktop/clip_image002.jpg"));   

          ImageIO.write(bufferImg,"jpg",byteArrayOut);   

          ImageIO.write(bufferImg1,"jpg",byteArrayOut1);   



        //创建一个工作薄   

       HSSFWorkbook wb = new HSSFWorkbook();   

       HSSFSheet sheet1 = wb.createSheet("poi picT");   

       HSSFPatriarch patriarch = sheet1.createDrawingPatriarch();   

       HSSFClientAnchor anchor = new HSSFClientAnchor(0,0,512,255,(short) 1,1,(short)10,20);   

       HSSFClientAnchor anchor1 = new HSSFClientAnchor(0,0,512,255,(short) 2,30,(short)10,60);   

       anchor1.setAnchorType(2);  

       //插入图片  

       patriarch.createPicture(anchor , wb.addPicture(byteArrayOut.toByteArray(),HSSFWorkbook.PICTURE_TYPE_JPEG));   

       patriarch.createPicture(anchor1 , wb.addPicture(byteArrayOut1.toByteArray(),HSSFWorkbook.PICTURE_TYPE_JPEG));   

           fileOut = new FileOutputStream("c:/workbook.xls");   

           //写入excel文件  

           wb.write(fileOut);   

           fileOut.close();   

            }catch(IOException io){   

                    io.printStackTrace();   

                    System.out.println("io erorr : "+ io.getMessage());   

            } finally  

            {   

               if (fileOut != null)   

               {  

                   try {   

                              fileOut.close();   

                         }   

                   catch (IOException e)  

                   {   

                            // TODO Auto-generated catch block   

                            e.printStackTrace();   

                     }   

               }   

            }  

    }  

补充：Java ,  Java SE

上一个：魔兽争霸-真三国无双
下一个：求大神帮忙哈。实现网上多线程下载但是出现问题？