超連結即内容連結,通過給特定對象設定超連結,可實作載體與特定網頁、檔案、郵件、網絡等的連結,點選連結載體可打開連結目标,在文檔進行中是一種比較常用的功能。本文将介紹通過Java程式給Excel文檔添加超連結的方法,這裡支援添加多種不同類型的連結,如URL網頁連結、Workbook工作簿連結、File文檔連結、Unc網絡路徑連結等。
使用工具:Free Spire.XLS for Java (免費版)
注:通過官網下載下傳包,并解壓将lib檔案夾下的jar檔案導入java程式。如下導入效果:
Java代碼示例
import com.spire.xls.*;
public class AddHyperlink {
public static void main(String[] args) {
//加載Excel文檔
Workbook wb = new Workbook();
wb.loadFromFile("test.xlsx");
//擷取工作表
Worksheet sheet = wb.getWorksheets().get(0);
//添加URL連結,連結到網頁位址
HyperLink UrlLink = sheet.getHyperLinks().add(sheet.getCellRange("B3"));
UrlLink.setTextToDisplay(sheet.getCellRange("B3").getText());
UrlLink.getType().compareTo(HyperLinkType.Url);
UrlLink.setAddress("https://www.baidu.com/");
//添加URL連結,連結到郵件位址
HyperLink MailLink = sheet.getHyperLinks().add(sheet.getCellRange("D3"));
MailLink.setTextToDisplay(sheet.getCellRange("D3").getText());
MailLink.getType().compareTo(HyperLinkType.Url);
MailLink.setAddress("mailto: support @ e-iceblue.com");
//添加File文檔連結,連結到指定文檔
HyperLink FileLink = sheet.getHyperLinks().add(sheet.getCellRange("B7"));
FileLink.setTextToDisplay(sheet.getCellRange("B7").getText());
FileLink.getType().compareTo(HyperLinkType.File);
FileLink.setAddress("E:\\IDEA\\sample.docx");
// 添加Workbook文檔連結,連結到工作簿文檔(這裡連結到測試文檔中的指定sheet中的指定單元格)
HyperLink WbLink = sheet.getHyperLinks().add(sheet.getCellRange("D7"));
WbLink.getType().compareTo(HyperLinkType.Workbook);
WbLink.setTextToDisplay(sheet.getCellRange("D7").getText());
WbLink.setAddress("Sheet2!B5");
//添加Unc連結,連結到網絡路徑
HyperLink UncLink = sheet.getHyperLinks().add(sheet.getCellRange("B11"));
UncLink.getType().compareTo(HyperLinkType.Unc);
UncLink.setTextToDisplay(sheet.getCellRange("B11").getText());
UncLink.setAddress("\\192.168.1.108");
//儲存文檔
wb.saveToFile("AddHyperlink.xlsx",ExcelVersion.Version2010);
wb.dispose();
}
}
文檔超連結添加效果: