poi导出Excel中插入网络图片的问题||给定URL得到实际地址

[章耿(余淮)]

我主要是用poi往Excel中导入图片
在普通的Excel中,我们可以直接插入网络图片
可是poi导出的Excel不行 而且图片的地址是类似于上述URL的 是 /down.jsp?filename=aaa.gif
并不是实际地址 所以 我想实现下面的功能

例如
给定义一个URL类似于
http://count.greendown.cn/view_down.asp?downd_id=16&downd=4&ID=14448&down=yes

但是其实我要下载的文件是这个地址跳转后的WinFlip-v0.42.rar

所以现在如何那java代码得到这个URL跳转的后的实际地址,
或者把文件下载下来到本地临时文件夹 得到本地的地址!

各位java高手帮帮忙!
要是有人帮忙指导实现直接导出图片的更加谢谢!!

[mengzulin]

邮件中还好办，excel就不好办，试了几次不成功。

[mengzulin]

用jawin试试

[timbear]

学习中~~

[zhb_821012]

这个还真没弄过
有空试试看

[章耿(余淮)]

package cn.ujjboy.TestMateril;

import java.io.ByteArrayOutputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.net.MalformedURLException;
import java.net.URL;
import java.net.URLConnection;
import org.apache.poi.hssf.usermodel.HSSFClientAnchor;
import org.apache.poi.hssf.usermodel.HSSFPatriarch;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

/**
 * Title: 导出图片 <br>
 * Description: <br>
 * QQ: 247799110 <br>
 * 
 * @author <a href=mailto:[e-mail]>ujjboy</a>
 */
public class ExportImg2Xls {

	/**
	 * @param args
	 * @throws IOException
	 */
	public static void main(String[] args) throws IOException {
		HSSFWorkbook workbook = new HSSFWorkbook();
		HSSFSheet sheet = workbook.createSheet("1111");

		String localPath = "d://";
		// 尽管是带 /down.jsp?filename=aaa.gif 类型的 也会自动跳转
		String romotePath = "http://www.baidu.com/img/logo.gif";
		// String romotePath = "http://192.168.93.1:8010/jsp/portal/lib/default/images/logo99.jpg";
		System.out.println("下载地址" + romotePath);
		String path = getFile(romotePath, localPath);// 得到图片的本地地址
		System.out.println("本地地址" + path);

		// 创建一个图片区域
		HSSFPatriarch patriarch = sheet.createDrawingPatriarch();
		HSSFClientAnchor anchor;
		// 加载图片
		anchor = new HSSFClientAnchor(0, 0, 255, 255, (short) 0,0, (short) 2, 2);
		// 0 = Move and size with Cells, 2 = Move but don't size with cells, 3 = Don't move or size with cells.
		anchor.setAnchorType(0);
		patriarch.createPicture(anchor, loadPicture(path, workbook));

		FileOutputStream fileOut = new FileOutputStream("ExportImg2Xls.xls");
		workbook.write(fileOut);
		fileOut.close();
		System.out.println("Export OK~~");
	}

	/**
	 * 通过地址把文件下载下来保存到本地
	 * 
	 * @param srcUrl
	 * @return 本地实际地址
	 * @throws IOException
	 */
	public static String getFile(String srcUrl, String localPath) throws IOException {
		URL url = new URL(srcUrl);
		String srcFliename = "logo.gif";// 自己用方法得到filename
		String realFilePath = localPath + srcFliename;
		System.out.println("正在下载" + realFilePath);
		try {
			URLConnection conn = url.openConnection();
			InputStream in = conn.getInputStream();
			FileOutputStream out = new FileOutputStream(new File(realFilePath));
			byte buffer[] = new byte[1024];
			int count = 0;
			while ((count = in.read(buffer)) != -1) {
				out.write(buffer, 0, count);
			}
			out.flush();
		} catch (MalformedURLException e) {
			e.printStackTrace();
		} catch (IOException e) {
			e.printStackTrace();
		}
		System.out.println("下载完成");
		return realFilePath;
	}

	/**
	 * 通过图片路径得到图片
	 * 
	 * @param path
	 * @param wb
	 * @return
	 * @throws IOException
	 */
	private static int loadPicture(String path, HSSFWorkbook wb) throws IOException {
		int pictureIndex;
		FileInputStream fis = null;
		ByteArrayOutputStream bos = null;
		try {
			fis = new FileInputStream(path);
			bos = new ByteArrayOutputStream();
			int c;
			while ((c = fis.read()) != -1)
				bos.write(c);
			pictureIndex = wb.addPicture(bos.toByteArray(), HSSFWorkbook.PICTURE_TYPE_PNG);
		} finally {
			if (fis != null)
				fis.close();
			if (bos != null)
				bos.close();
		}
		return pictureIndex;
	}
}