1.图片实现效果:
2.直接上示例代码:
package com.mischen.mapreduce.wordcount;
import com.sun.image.codec.jpeg.JPEGCodec;
import com.sun.image.codec.jpeg.JPEGImageEncoder;
import java.awt.*;
import java.awt.image.BufferedImage;
import java.io.BufferedOutputStream;
import java.io.FileOutputStream;
/**
* @ClassName WordGraphs
* @Description DOTO
* @Author mischen
* @Date 2021/5/16 0016 21:28
* @Version 1.0
**/
public class WordGraphs {
public static void main(String[] args){
WordExcel cg = new WordExcel();
try {
//String tableData1[][] = {{"8月31日","累计用户数","目标值","完成进度","时间进度", "进度差异"}, {"掌厅客户端(户)","469281","1500000","31.2%","33.6%", "-2.4%"}};
String[][] tableData2 = {{"","人员类型","姓名","学号","性别","爱好","手机号","邮箱","年龄"},
{"1年级","√","","","","","","",""},
{"2年级","","","","","√","","",""},
{"3年级","","","mischen","","","","","29"},
{"4年级","学生","","","","","√","",""}};
cg.myGraphicsGeneration(tableData2, "C:\\Users\\Administrator\\Desktop\\docker\\test1.png");
} catch (Exception e) {
e.printStackTrace();
}
}
/**
* 生成图片
* @param cellsValue 以二维数组形式存放 表格里面的值
* @param path 文件保存路径
*/
public void myGraphicsGeneration(String cellsValue[][], String path) {
// 字体大小
int fontTitileSize = 15;
// 横线的行数
int totalrow = cellsValue.length + 1;
// 竖线的行数
int totalcol = 0;
if (cellsValue[0] != null) {
totalcol = cellsValue[0].length;
}
// 图片宽度
int imageWidth = 1024;
// 行高
int rowheight = 40;
// 图片高度
int imageHeight = totalrow * rowheight + 50;
// 起始高度
int startHeight = 10;
// 起始宽度
int startWidth = 10;
// 单元格宽度
int colwidth = (int) ((imageWidth - 20) / totalcol);
BufferedImage image = new BufferedImage(imageWidth, imageHeight, BufferedImage.TYPE_INT_RGB);
Graphics graphics = image.getGraphics();
graphics.setColor(Color.WHITE);
graphics.fillRect(0, 0, imageWidth, imageHeight);
graphics.setColor(new Color(220, 240, 240));
//画横线
for (int j = 0; j < totalrow; j++) {
graphics.setColor(Color.black);
graphics.drawLine(startWidth, startHeight + (j + 1) * rowheight, startWidth + colwidth * totalcol, startHeight + (j + 1) * rowheight);
}
//画竖线
for (int k = 0; k < totalcol + 1; k++) {
graphics.setColor(Color.black);
graphics.drawLine(startWidth + k * colwidth, startHeight + rowheight, startWidth + k * colwidth, startHeight + rowheight * totalrow);
}
//设置字体
Font font = new Font("宋体", Font.BOLD, fontTitileSize);
graphics.setFont(font);
//写标题
String title = "年级学生信息表111";
graphics.drawString(title, startWidth + 4 * colwidth, (startHeight + rowheight) / 2);
//写入内容
for (int n = 0; n < cellsValue.length; n++) {
for (int l = 0; l < cellsValue[n].length; l++) {
if (n == 0) {
font = new Font("宋体", Font.BOLD, fontTitileSize);
graphics.setFont(font);
} else if (n > 0 && l > 0) {
font = new Font("宋体", Font.PLAIN, fontTitileSize);
graphics.setFont(font);
graphics.setColor(Color.RED);
} else {
font = new Font("宋体", Font.PLAIN, fontTitileSize);
graphics.setFont(font);
graphics.setColor(Color.BLACK);
}
graphics.drawString(cellsValue[n][l].toString(), startWidth + colwidth * l + 5, startHeight + rowheight * (n + 2) - 10);
}
}
// 保存图片
createImage(image, path);
}
/**
* 将图片保存到指定位置
* @param image 缓冲文件类
* @param fileLocation 文件位置
*/
public void createImage(BufferedImage image, String fileLocation) {
try {
FileOutputStream fos = new FileOutputStream(fileLocation);
BufferedOutputStream bos = new BufferedOutputStream(fos);
JPEGImageEncoder encoder = JPEGCodec.createJPEGEncoder(bos);
encoder.encode(image);
bos.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}