import org.apache.batik.transcoder.TranscoderException;
import org.apache.batik.transcoder.TranscoderInput;
import org.apache.batik.transcoder.TranscoderOutput;
import org.apache.batik.transcoder.image.PNGTranscoder;
import java.io.*;
/**
*@Description: 將svg轉(zhuǎn)換為png格式的圖片
*/
public class SvgPngConverter {
/**
*@Description: 將svg字符串轉(zhuǎn)換為png
*@Author:
*@param svgCode svg代碼
*@param pngFilePath 保存的路徑
*@throws IOException io異常
*@throws TranscoderException svg代碼異常
*/
public static void convertToPng(String svgCode,String pngFilePath) throws IOException,TranscoderException {
File file = new File (pngFilePath);
FileOutputStream outputStream = null;
try {
file.createNewFile ();
outputStream = new FileOutputStream (file);
convertToPng (svgCode, outputStream);
} finally {
if (outputStream != null) {
try {
outputStream.close ();
} catch (IOException e) {
e.printStackTrace ();
}
}
}
}
/**
*@Description: 將svgCode轉(zhuǎn)換成png文件，直接輸出到流中
*@param svgCode svg代碼
*@param outputStream 輸出流
*@throws TranscoderException 異常
*@throws IOException io異常
*/
public static void convertToPng(String svgCode,OutputStream outputStream) throws TranscoderException,IOException{
try {
byte[] bytes = svgCode.getBytes ("UTF-8");
PNGTranscoder t = new PNGTranscoder ();
ByteArrayInputStream byteArrayInputStream = new ByteArrayInputStream(bytes);
TranscoderInput input = new TranscoderInput (byteArrayInputStream);
TranscoderOutput output = new TranscoderOutput (outputStream);
t.transcode (input, output);
outputStream.flush ();
} finally {
if (outputStream != null) {
try {
outputStream.close ();
} catch (IOException e) {
e.printStackTrace ();
}
}
}
}
public static void main(String[] args) {
StringBuilder svgStr = ""; // 圖表的svg字符串，一般較長，此處省略
String path = "H:\\svg1.png";
try {
convertToPng(svgStr, path);
} catch (IOException e) {
e.printStackTrace();
} catch (TranscoderException e) {
e.printStackTrace();
}
}
}

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;
import javax.imageio.ImageIO;
import java.awt.image.BufferedImage;
import java.io.ByteArrayOutputStream;
import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
/**
*@Description: 讀取磁盤中圖片到excel
*/
public class ExcelImageTest {
public static void main(String[] args) {
FileOutputStream fileOut = null;
BufferedImage bufferImg = null;
//先把讀進(jìn)來的圖片放到一個(gè)ByteArrayOutputStream中，以便產(chǎn)生ByteArray
try {
ByteArrayOutputStream byteArrayOut = new ByteArrayOutputStream();
bufferImg = ImageIO.read(new File("H:/svg1.png"));
ImageIO.write(bufferImg, "png", byteArrayOut);
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet1 = wb.createSheet("test picture");
//畫圖的頂級(jí)管理器，一個(gè)sheet只能獲取一個(gè)（一定要注意這點(diǎn)）
HSSFPatriarch patriarch = sheet1.createDrawingPatriarch();
//anchor主要用于設(shè)置圖片的屬性
HSSFClientAnchor anchor = new HSSFClientAnchor(0, 0, 255, 255,(short) 1, 1, (short) 7, 10);
anchor.setAnchorType(3);
//插入圖片
patriarch.createPicture(anchor, wb.addPicture(byteArrayOut.toByteArray(), HSSFWorkbook.PICTURE_TYPE_JPEG));
fileOut = new FileOutputStream("H:/測試Excel.xls");
// 寫入excel文件
wb.write(fileOut);
System.out.println("----Excle文件已生成------");
} catch (Exception e) {
e.printStackTrace();
}finally{
if(fileOut != null){
try {
fileOut.close();
} catch (IOException e) {
e.printStackTrace();
}
}
}
}
}

import org.apache.batik.transcoder.TranscoderInput;
import org.apache.batik.transcoder.TranscoderOutput;
import org.apache.batik.transcoder.image.PNGTranscoder;
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;
import java.io.*;
/**
*@Description: 直接將svg信息轉(zhuǎn)為圖片添加至excel
*/
public class SvgToExcelPng {
public static void main(String[] args) {
FileOutputStream fileOut;
try {
String svgStr = ""; // 圖表的svg字符串，一般較長，此處省略
byte[] bytes = svgStr.getBytes ("UTF-8");
ByteArrayOutputStream byteArrayOut = new ByteArrayOutputStream();
PNGTranscoder t = new PNGTranscoder ();
TranscoderInput input = new TranscoderInput (new ByteArrayInputStream(bytes));
TranscoderOutput output = new TranscoderOutput (byteArrayOut);
t.transcode (input, output);
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet1 = wb.createSheet("test picture");
//畫圖的頂級(jí)管理器，一個(gè)sheet只能獲取一個(gè)（一定要注意這點(diǎn)）
HSSFPatriarch patriarch = sheet1.createDrawingPatriarch();
//anchor主要用于設(shè)置圖片的屬性
HSSFClientAnchor anchor = new HSSFClientAnchor(0, 0, 255, 255,(short) 1, 1, (short) 7, 10);
anchor.setAnchorType(3);
//插入圖片
patriarch.createPicture(anchor, wb.addPicture(byteArrayOut.toByteArray(), HSSFWorkbook.PICTURE_TYPE_JPEG));
fileOut = new FileOutputStream("H:/測試Excel2.xls");
// 寫入excel文件
wb.write(fileOut);
System.out.println("----Excle文件已生成------");
} catch (Exception e) {
e.printStackTrace();
}
}
}