POI 超链接

来源：互联网发布：王哲林体测数据编辑：程序博客网时间：2024/05/05 09:43

本章介绍了如何为超链接添加到内容的单元格。超链接通常被用来访问任何网站的网址，电子邮件或外部文件。

下面的代码演示如何创建单元格的超链接。

import java.io.File;import java.io.FileOutputStream;import org.apache.poi.common.usermodel.Hyperlink;import org.apache.poi.hssf.util.HSSFColor;import org.apache.poi.ss.usermodel.CreationHelper;import org.apache.poi.xssf.usermodel.XSSFCell;import org.apache.poi.xssf.usermodel.XSSFCellStyle;import org.apache.poi.xssf.usermodel.XSSFFont;import org.apache.poi.xssf.usermodel.XSSFHyperlink;import org.apache.poi.xssf.usermodel.XSSFSheet;import org.apache.poi.xssf.usermodel.XSSFWorkbook;public class HyperlinkEX {   public static void main(String[] args) throws Exception    {      XSSFWorkbook workbook = new XSSFWorkbook();       XSSFSheet spreadsheet = workbook      .createSheet("Hyperlinks");      XSSFCell cell;      CreationHelper createHelper = workbook      .getCreationHelper();      XSSFCellStyle hlinkstyle = workbook.createCellStyle();      XSSFFont hlinkfont = workbook.createFont();      hlinkfont.setUnderline(XSSFFont.U_SINGLE);      hlinkfont.setColor(HSSFColor.BLUE.index);      hlinkstyle.setFont(hlinkfont);      //URL Link      cell = spreadsheet.createRow(1)      .createCell((short) 1);      cell.setCellValue("URL Link");      XSSFHyperlink link = (XSSFHyperlink)createHelper      .createHyperlink(Hyperlink.LINK_URL);      link.setAddress("http://www.yiibai.com/" );      cell.setHyperlink((XSSFHyperlink) link);      cell.setCellStyle(hlinkstyle);      //Hyperlink to a file in the current directory      cell = spreadsheet.createRow(2)      .createCell((short) 1);      cell.setCellValue("File Link");      link = (XSSFHyperlink)createHelper      .createHyperlink(Hyperlink.LINK_FILE);      link.setAddress("cellstyle.xlsx");      cell.setHyperlink(link);      cell.setCellStyle(hlinkstyle);      //e-mail link      cell = spreadsheet.createRow(3)      .createCell((short) 1);      cell.setCellValue("Email Link");      link = (XSSFHyperlink)createHelper      .createHyperlink(Hyperlink.LINK_EMAIL);      link.setAddress(       "mailto:contact@yiibai.com?"      +"subject=Hyperlink");      cell.setHyperlink(link);      cell.setCellStyle(hlinkstyle);      FileOutputStream out = new FileOutputStream(      new File("hyperlink.xlsx"));      workbook.write(out);      out.close();      System.out.println("hyperlink.xlsx written successfully");   }}

保存上面的代码到文件HyperlinkEX.java。并从命令提示符编译执行它如下。

$javac HyperlinkEX.java$java HyperlinkEX

它会生成一个名为hyperlink.xlsx在当前目录中的Excel文件并显示在命令提示符处输出：

hyperlink.xlsx written successfully

hyperlink.xlsx文件如下所示。

0 0