本文介绍如何使用Spire.XLS for Java添加图片到Excel单元格并设置超链接。
import com.spire.xls.*;
public class InsertImageHyperlink {
public static void main(String[] args) {
//创建Workbook对象并获取第一个工作表
Workbook wb = new Workbook();
Worksheet sheet = wb.getWorksheets().get(0);
//在单元格A1中添加文字
sheet.getCellRange("A1").setText(" 图片超链接");
sheet.getCellRange("A1").getStyle().setVerticalAlignment(VerticalAlignType.Top);
//添加图片到单元格A1
String picPath = "C:\\Users\\Administrator\\Desktop\\logo.png";
ExcelPicture picture = sheet.getPictures().add(1,1,picPath);
//为图片设置超链接
picture.setHyperLink("Http://www.e-iceblue.cn", true);
//设置行高和列宽
sheet.getColumns()[0].setColumnWidth(22);
sheet.getRows()[0].setRowHeight(140);
picture.setTopRowOffset(25);
//保存文档
wb.saveToFile("ImageHyperlink.xlsx", ExcelVersion.Version2016);
}
}