【Java】------- Java excel 生成多个二维码（可以添加图标，和文字）

清疚 2024-04-18 08:56 9阅读 0赞

> 1.Java excel 生成多个二维码（java  springboot框架 ）

> （1） 第一步: pom.xml 配置文件配置参数如下：
> 
>     
>     		<dependency>
>     			<groupId>com.google.zxing</groupId>
>     			<artifactId>core</artifactId>
>     			<version>${zxing.version}</version>
>     			<scope>compile</scope>
>     			<optional>true</optional>
>     		</dependency>
> 
>

> （2）第二步： 创建 qcode.java 类（主要代码）
> 
>     package com.imx.qrcode;
>     
>     import com.alibaba.fastjson.JSONArray;
>     import com.alibaba.fastjson.JSONObject;
>     import com.google.zxing.BarcodeFormat;
>     import com.google.zxing.EncodeHintType;
>     import com.google.zxing.MultiFormatWriter;
>     import com.google.zxing.common.BitMatrix;
>     import com.google.zxing.qrcode.decoder.ErrorCorrectionLevel;
>     
>     import com.yd.edb.entity.IMXResponse;
>     import com.yd.edb.ticket.Ticket;
>     //import org.apache.poi.common.usermodel.fonts.FontInfo;
>     import org.apache.poi.hssf.usermodel.*;
>     import org.apache.poi.ss.usermodel.ClientAnchor;
>     
>     import javax.imageio.ImageIO;
>     import java.awt.*;
>     import java.awt.image.BufferedImage;
>     import java.io.ByteArrayOutputStream;
>     import java.io.File;
>     import java.io.FileOutputStream;
>     import java.io.IOException;
>     import java.math.BigDecimal;
>     
>     import java.util.HashMap;
>     
>     
>     /**
>      * Created by liyoubing on 2019-09-03.
>      */
>     public class qrcode {
>     
>         /**
>          * 根据自定义的内容和图片名称生成二维码图片
>          * 参考：https://blog.csdn.net/amberwangfeng/article/details/78657889
>          */
>         public static IMXResponse BAPI_qrcode_sc(Ticket ticket,String data) {
>             IMXResponse ret=new IMXResponse();
>             try {
>     
>     
>                 FileOutputStream fileOut = null;
>     
>                 String content = "";
>                 boolean flag = false;
>                 int width = 300;
>                 int height = 380;
>                 String format = "png";
>                 String text = "";
>                 int font = 10; //字体大小
>                 int fontStyle = 1; //字体风格
>     
>                 //定义二维码的参数
>                 HashMap hashMap = new HashMap();
>                 hashMap.put(EncodeHintType.CHARACTER_SET, "utf-8");
>                 hashMap.put(EncodeHintType.ERROR_CORRECTION, ErrorCorrectionLevel.M);
>                 hashMap.put(EncodeHintType.MARGIN, 4);
>     
>                 HSSFWorkbook wb = new HSSFWorkbook();
>                 HSSFSheet sheet1 = wb.createSheet("二维码");
>                 sheet1.setColumnWidth(0, 45*256);
>     
>                 sheet1.setDefaultRowHeight((short)(24*20/32*400));
>                 //画图的顶级管理器，一个sheet只能获取一个（一定要注意这点）
>                 HSSFPatriarch patriarch = sheet1.createDrawingPatriarch();
>     
>                 try {
>                     JSONArray job=JSONObject.parseArray(data);
>                     if(job.size()>0){
>                         BufferedImage image=null;
>                         for(int i=0;i<job.size();i++){
>     
>                             HSSFRow row = sheet1.createRow(i) ;
>                             //行高32px = 24pt = 480twips
>                             row.setHeight((short)(24*20/32*400));
>                             ByteArrayOutputStream byteArrayOut = new ByteArrayOutputStream();
>     
>                             JSONObject jsonqrcode=job.getJSONObject(i);
>                             content=tool.ConvertHelper.ToString(jsonqrcode.getString("NODE_ID"));
>                             text=tool.ConvertHelper.ToString(jsonqrcode.getString("NODE_NAME"));
>     
>                             BitMatrix bitMatrix = new MultiFormatWriter().encode(content, BarcodeFormat.QR_CODE, width, height, hashMap);
>     
>     
>                             //File logoFile = new File("C:/Users/liyoubing/Desktop/love.png");//logo图片
>                             //开始画二维码
>                             BufferedImage barCodeImage = MatrixToImageWriter.writeToFile(bitMatrix, format);
>     
>                             //在二维码中加入图片
>                             //LogoConfig logoConfig = new LogoConfig(); //LogoConfig中设置Logo的属性
>                             //BufferedImage image = addLogo_QRCode(barCodeImage, logoFile, logoConfig);
>     
>                             //向图片中添加文字
>                             //image =  pressText(text, rootPath, image, fontStyle, Color.black, font, width, height);
>                             image =  pressText(text, "", barCodeImage, fontStyle, Color.black, font, width, height);
>     
>                             ImageIO.write(image, "jpg", byteArrayOut);
>     
>                             HSSFClientAnchor anchor = new HSSFClientAnchor(0, 0, 1020, 255,(short) 0, i, (short) 0, i);
>     
>                             anchor.setAnchorType(ClientAnchor.AnchorType.DONT_MOVE_AND_RESIZE);
>     
>                             //插入图片
>                             patriarch.createPicture(anchor, wb.addPicture(byteArrayOut.toByteArray(), HSSFWorkbook.PICTURE_TYPE_JPEG));
>     
>                         }
>     
>                     }else{
>                         ret.setSuccess(0);
>                         ret.setMessage("没有数据");
>                     }
>     
>                     //excel
>                     File file = new File("D:/二维码Excel.xls");
>                     if (!file.exists()) {
>                     }
>                     if (file.isFile()) {
>                         file.delete();
>                     }
>                     fileOut = new FileOutputStream("D:/二维码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();
>                         }
>                     }
>                 }
>             }catch (Exception e){
>                  e.getMessage();
>             }
>             ret.setMessage("生成成功请在D盘找到：《二维码Excel.xls》文件,文件路径：D:二维码Excel.xls");
>             ret.setSuccess(1);
>             return ret;
>         }
>     
>     
>         /**
>          * 给二维码添加logo
>          */
>         public static BufferedImage addLogo_QRCode(BufferedImage barCodeImage, File logoPic, LogoConfig logoConfig) {
>             try {
>                 if (!logoPic.isFile()) {
>                     System.out.print("file not find !");
>                     throw new IOException("file not find !");
>                 }
>     
>                 // 读取二维码图片，并构建绘图对象
>                 Graphics2D g = barCodeImage.createGraphics();
>     
>                 //读取Logo图片
>                 BufferedImage logo = ImageIO.read(logoPic);
>     
>                 int widthLogo = barCodeImage.getWidth() / logoConfig.getLogoPart();
>                 int heightLogo = barCodeImage.getWidth() / logoConfig.getLogoPart(); //保持二维码是正方形的
>     
>                 // 计算图片放置位置
>                 int x = (barCodeImage.getWidth() - widthLogo) / 2;
>                 int y = (barCodeImage.getHeight() - heightLogo) / 2 - 50;
>     
>                 //开始绘制图片
>                 g.drawImage(logo, x, y, widthLogo, heightLogo, null);
>                 g.drawRoundRect(x, y, widthLogo, heightLogo, 10, 10);
>                 g.setStroke(new BasicStroke(logoConfig.getBorder()));
>                 g.setColor(logoConfig.getBorderColor());
>                 g.drawRect(x, y, widthLogo, heightLogo);
>                 g.dispose();
>                 return barCodeImage;
>             } catch (Exception e) {
>                 e.printStackTrace();
>             }
>             return null;
>         }
>     
>         /**
>          * 给二维码下方附加说明文字
>          *
>          * @param pressText 文字
>          * @param newImg    带文字的图片
>          * @param image     需要添加文字的图片
>          * @为图片添加文字
>          */
>         public static BufferedImage pressText(String pressText, String newImg, BufferedImage image, int fontStyle, Color color, int fontSize, int width, int height) {
>     
>             //计算文字开始的位置
>             //x开始的位置：（图片宽度-字体大小*字的个数）/2
>             int startX = (width - (fontSize * pressText.length())) / 3 - 28;
>             //y开始的位置：图片高度-（图片高度-图片宽度）/2
>             int startY = height - (height - width) / 2 - 30;
>     
>     //        System.out.println("startX: " + startX);
>     //        System.out.println("startY: " + startY);
>     //        System.out.println("height: " + height);
>     //        System.out.println("width: " + width);
>     //        System.out.println("fontSize: " + fontSize);
>     //        System.out.println("pressText.length(): " + pressText.length());
>     
>             try {
>                 int imageW = image.getWidth();
>                 int imageH = image.getHeight();
>                 Graphics g = image.createGraphics();
>                 g.drawImage(image, 0, 0, imageW, imageH, null);
>                 g.setColor(color);
>                 g.setFont(new Font("粗体", Font.BOLD, 18));
>                 g.drawString(pressText, startX, startY);
>                 g.drawString("", startX - 5, startY + 30);
>                 g.dispose();
>     
>     //            FileOutputStream out = new FileOutputStream(newImg);
>     //            ImageIO.write(image, "png", out);
>     //            JPEGImageEncoder encoder = JPEGCodec.createJPEGEncoder(out);
>     //            encoder.encode(image);
>     //            out.close();
>                 //System.out.println("image press success");
>                 return image;
>     
>             } catch (Exception e) {
>                 e.printStackTrace();
>                 System.out.println(e);
>             }
>             return  null;
>         }
>     
>     
>     }
> 
>

> 第三步： 添加图标的类： LoginConfig.java
> 
>     package com.imx.qrcode;
>     
>     import java.awt.*;
>     
>     /**
>      * Created by liyoubing on 2019-09-03.
>      */
>     public class LogoConfig {
>         // logo默认边框颜色
>         public static final Color DEFAULT_BORDERCOLOR = Color.WHITE;
>         // logo默认边框宽度
>         public static final int DEFAULT_BORDER = 2;
>         // logo大小默认为二维码照片的1/6
>         public static final int DEFAULT_LOGOPART = 6;
>     
>         private final int border = DEFAULT_BORDER;
>         private final Color borderColor;
>         private final int logoPart;
>     
>         /**
>          * Creates a default config with on color {@link #BLACK} and off color
>          * {@link #WHITE}, generating normal black-on-white barcodes.
>          */
>         public LogoConfig() {
>             this(DEFAULT_BORDERCOLOR, DEFAULT_LOGOPART);
>         }
>     
>         public LogoConfig(Color borderColor, int logoPart) {
>             this.borderColor = borderColor;
>             this.logoPart = logoPart;
>         }
>     
>         public Color getBorderColor() {
>             return borderColor;
>         }
>     
>         public int getBorder() {
>             return border;
>         }
>     
>         public int getLogoPart() {
>             return logoPart;
>         }
>     
>     }
> 
>

> 3. 二维码生成类：MatrixToImageWriter.java
> 
>     package com.imx.qrcode;
>     
>      import java.awt.image.BufferedImage;
>     
>      import java.io.File;
>      import java.io.IOException;
>      import java.io.OutputStream;
>     
>      import javax.imageio.ImageIO;
>     
>      import java.util.Hashtable;
>     
>      import com.google.zxing.common.BitMatrix;
>      import com.google.zxing.BarcodeFormat;
>      import com.google.zxing.EncodeHintType;
>      import com.google.zxing.MultiFormatWriter;
>     
>      /**
>      * 二维码的生成需要借助MatrixToImageWriter类，该类是由Google提供的，可以将该类直接拷贝到源码中使用
>      */
>     public class MatrixToImageWriter {
>          private static final int BLACK = 0xFF000000;
>          private static final int WHITE = 0xFFFFFFFF;
>     
>          private MatrixToImageWriter() {
>          }
>     
>          public static BufferedImage toBufferedImage(BitMatrix matrix) {
>              int width = matrix.getWidth();
>              int height = matrix.getHeight();
>              BufferedImage image = new BufferedImage(width, height, BufferedImage.TYPE_INT_RGB);
>              for (int x = 0; x < width; x++) {
>                  for (int y = 0; y < height - 50; y++) {
>                      image.setRGB(x, y, matrix.get(x, y + 50) ? BLACK : WHITE);
>                  }
>              }
>              return image;
>          }
>     
>     
>          public static BufferedImage writeToFile(BitMatrix matrix, String format)
>                  throws IOException {
>              BufferedImage image = toBufferedImage(matrix);
>              return image;
>          }
>     
>     
>          public static void writeToStream(BitMatrix matrix, String format, OutputStream stream)
>                  throws IOException {
>              BufferedImage image = toBufferedImage(matrix);
>              if (!ImageIO.write(image, format, stream)) {
>                  throw new IOException("Could not write an image of format " + format);
>              }
>          }
>     
>     
>     //    public static void main(String[] args) throws Exception {
>     //        String text = "http://www.baidu.com"; // 二维码内容
>     //        int width = 300; // 二维码图片宽度
>     //        int height = 300; // 二维码图片高度
>     //        String format = "jpg";// 二维码的图片格式
>     //
>     //        Hashtable<EncodeHintType, String> hints = new Hashtable<EncodeHintType, String>();
>     //        hints.put(EncodeHintType.CHARACTER_SET, "utf-8"); // 内容所使用字符集编码
>     //
>     //        BitMatrix bitMatrix = new MultiFormatWriter().encode(text,
>     //                BarcodeFormat.QR_CODE, width, height, hints);
>     //        // 生成二维码
>     //        File outputFile = new File("d:" + File.separator + "new.jpg");
>     //        MatrixToImageWriter.writeToFile(bitMatrix, format, outputFile);
>     //    }
>     }
> 
>

> 4. 实例效果图：
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4MzY2NjU3_size_16_color_FFFFFF_t_70][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4MzY2NjU3_size_16_color_FFFFFF_t_70]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/17/9b967ece63fc47a68e0221a53545117b.png