本文介绍如何使用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);
    }
}