ffhelly
ffhelly
2014-05-12 15:06

poi操作execl如何在cell里做一个超链接访问当前路径文件夹或文件

已采纳

求例子。。。

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享
  • 邀请回答

1条回答

  • leehuat leehuat 7年前

    [code="java"]
    这个是设置一个超链接弹出email地址, 其他类似
    import java.io.FileOutputStream;

    import org.apache.poi.ss.usermodel;
    import org.apache.poi.xssf.usermodel.XSSFWorkbook;
    import org.apache.poi.ss.usermodel.IndexedColors;

    /**

    • @author lance
      */
      public class HyperlinkExample {

      public static void main(String[]args) throws Exception{
      Workbook wb = new XSSFWorkbook(); //or new HSSFWorkbook();
      CreationHelper createHelper = wb.getCreationHelper();

      CellStyle hlink_style = wb.createCellStyle();
      Font hlink_font = wb.createFont();
      hlink_font.setUnderline(Font.U_SINGLE);
      hlink_font.setColor(IndexedColors.BLUE.getIndex());
      hlink_style.setFont(hlink_font);

      Cell cell;
      Sheet sheet = wb.createSheet("Hyperlinks");
      //URL
      cell = sheet.createRow(0).createCell((short)0);
      cell.setCellValue("URL Link");

      Hyperlink link = createHelper.createHyperlink(Hyperlink.LINK_URL);
      link.setAddress("http://poi.apache.org/");
      cell.setHyperlink(link);
      cell.setCellStyle(hlink_style);

      //link to a file in the current directory
      cell = sheet.createRow(1).createCell((short)0);
      cell.setCellValue("File Link");
      link = createHelper.createHyperlink(Hyperlink.LINK_FILE);
      link.setAddress("link1.xls");
      cell.setHyperlink(link);
      cell.setCellStyle(hlink_style);

      //e-mail link
      cell = sheet.createRow(2).createCell((short)0);
      cell.setCellValue("Email Link");
      link = createHelper.createHyperlink(Hyperlink.LINK_EMAIL);
      //设置路径
      link.setAddress("mailto:poi@apache.org?subject=Hyperlinks");
      cell.setHyperlink(link);
      cell.setCellStyle(hlink_style);

      //create a target sheet and cell
      Sheet sheet2 = wb.createSheet("Target Sheet");
      sheet2.createRow(0).createCell((short)0).setCellValue("Target Cell");

      cell = sheet.createRow(3).createCell((short)0);
      cell.setCellValue("Worksheet Link");
      Hyperlink link2 = createHelper.createHyperlink(Hyperlink.LINK_DOCUMENT);
      link2.setAddress("'Target Sheet'!A1");
      cell.setHyperlink(link2);
      cell.setCellStyle(hlink_style);

      FileOutputStream out = new FileOutputStream("hyperinks.xlsx");
      wb.write(out);
      out.close();

      }
      }
      [/code]

    点赞 评论 复制链接分享

相关推荐