生成条形码并将条形码插入进excel中代码,Java代码库,德仔网

代码语言
代码分类
【Java】生成条形码并将条形码插入进excel中
作者:恺哥 / 发布于2013/10/11/ 612
动态生成条形码并将条形码插入进excel中；条形码生成利用barcode4j；操作excel利用poi；

	package k.barcode;

	import java.awt.image.BufferedImage;
	import java.io.File;
	import java.io.FileInputStream;
	import java.io.FileNotFoundException;
	import java.io.FileOutputStream;
	import java.io.IOException;
	import java.io.InputStream;
	import java.io.OutputStream;

	import org.apache.poi.hssf.usermodel.HSSFRow;
	import org.apache.poi.hssf.usermodel.HSSFSheet;
	import org.apache.poi.hssf.usermodel.HSSFWorkbook;
	import org.apache.poi.poifs.filesystem.POIFSFileSystem;
	import org.apache.poi.ss.usermodel.ClientAnchor;
	import org.apache.poi.ss.usermodel.CreationHelper;
	import org.apache.poi.ss.usermodel.Drawing;
	import org.apache.poi.ss.usermodel.Picture;
	import org.apache.poi.ss.usermodel.Workbook;
	import org.apache.poi.util.IOUtils;
	import org.krysalis.barcode4j.impl.code39.Code39Bean;
	import org.krysalis.barcode4j.output.bitmap.BitmapCanvasProvider;
	import org.krysalis.barcode4j.tools.UnitConv;

	public class InsExcel {

	private POIFSFileSystem fs;
	private HSSFWorkbook wb;
	private HSSFSheet sheet;
	private HSSFRow row;
	private FileInputStream input;
	private String[] excleTitle;

	public static void main(String[] args) {
	 //生成条码
	 String bcVal = InsExcel.makeBarcodeValue();
	 //生成条码图片
	 String bcPath = InsExcel.makeBarcode(bcVal);
	 //插入excel
	 InsExcel.insBarcodeInExcel(bcPath);
	}
	
	//生成条码值
	public static String makeBarcodeValue(){
	 return "A"+System.currentTimeMillis();
	}
	
	//生成条码文件至临时目录，并返回生成图片的路径信息
	public static String makeBarcode(final String barcodeValue){
	 //存放条码图片的路径
	 final String barcodePicPath = "d:\\barcode\\";
	 try {
	 //Create the barcode bean
	 Code39Bean bean = new Code39Bean();
	
	 final int dpi = 150;
	
	 //Configure the barcode generator
	 bean.setModuleWidth(UnitConv.in2mm(1.0f / dpi)); //makes the narrow bar
	 //width exactly one pixel
	 bean.setWideFactor(3);
	 bean.doQuietZone(false);
	
	 //Open output file
	 File outputFile = new File(barcodePicPath+barcodeValue+".png");
	 OutputStream out = new FileOutputStream(outputFile);
	 try {
	 //Set up the canvas provider for monochrome JPEG output
	 BitmapCanvasProvider canvas = new BitmapCanvasProvider(
	 out, "image/png", dpi, BufferedImage.TYPE_BYTE_BINARY, false, 0);
	
	 //Generate the barcode
	 bean.generateBarcode(canvas, barcodeValue);
	
	 //Signal end of generation
	 canvas.finish();
	 } finally {
	 out.close();
	 }
	 } catch (Exception e) {
	 e.printStackTrace();
	 }
	
	 return barcodePicPath+barcodeValue+".png";
	}
	
	public static void insBarcodeInExcel(String barcodePic){
	 FileInputStream input = null;
	 try {
	 input = new FileInputStream(new File("d:\\base.xls"));// excelPath,Excel
	 // 文件 的绝对路径
	 POIFSFileSystem fs = new POIFSFileSystem(input);
	 HSSFWorkbook wb = new HSSFWorkbook(fs);
	 HSSFSheet sheet = wb.getSheetAt(1);
	 HSSFRow row = sheet.getRow(0);// 得到标题的内容对象。
	 System.out.println(row.getCell(15).toString());

	 InputStream inputStream = new FileInputStream(barcodePic);
	 byte[] bytes = IOUtils.toByteArray(inputStream);
	 int pictureIdx = wb.addPicture(bytes, Workbook.PICTURE_TYPE_PNG);
	 inputStream.close();
	 CreationHelper helper = wb.getCreationHelper();
	 Drawing drawing = sheet.createDrawingPatriarch();
	 ClientAnchor anchor = helper.createClientAnchor();
	 anchor.setCol1(15);
	 anchor.setRow1(0);
	 Picture pict = drawing.createPicture(anchor, pictureIdx);
	 pict.resize();
	 FileOutputStream fileOut = new FileOutputStream("d:\\base.xls");
	 wb.write(fileOut);
	 fileOut.close();

	 } catch (FileNotFoundException e) {
	 e.printStackTrace();
	 } catch (IOException e) {
	 e.printStackTrace();
	 } finally {
	 try {
	 if (input != null) {
	 input.close();
	 }
	 } catch (IOException e) {
	 e.printStackTrace();
	 }
	 }
	}

	}
试试其它关键字
同语言下
可能有用的
恺哥贡献的其它代码(5)