Apache POI(6):超链接(HyperLink)

最新推荐文章于 2024-04-15 18:58:54 发布

个人知识管理布道师

最新推荐文章于 2024-04-15 18:58:54 发布

阅读量8.7k

点赞数

本文链接：https://blog.csdn.net/u010689306/article/details/52091123

版权

Apache POI 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

public static void hyperLink() throws Exception{
		XSSFWorkbook workbook = new XSSFWorkbook();
		XSSFSheet sheet = workbook.createSheet("Hyper Links");
		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 = sheet.createRow(1).createCell((short)1);
		cell.setCellValue("URL Link");
		XSSFHyperlink  hyperLink = (XSSFHyperlink) createHelper.createHyperlink(Hyperlink.LINK_URL);
		hyperLink.setAddress("http://www.yiibai.com");
		cell.setHyperlink(hyperLink);
		cell.setCellStyle(hlinkstyle);
		//Hyperlink to a file in the current directory
		cell = sheet.createRow(2).createCell(1);
		cell.setCellValue("File Link");
		hyperLink = (XSSFHyperlink) createHelper.createHyperlink(Hyperlink.LINK_FILE);
		hyperLink.setAddress("cellstyle.xlsx");
		cell.setHyperlink(hyperLink);
		cell.setCellStyle(hlinkstyle);
		//e-mail link
		cell = sheet.createRow(3).createCell((short) 1);
		cell.setCellValue("Email Link");
		hyperLink = (XSSFHyperlink) createHelper.createHyperlink(Hyperlink.LINK_EMAIL);
		hyperLink.setAddress("mailto:contact@yiibai.com?"
			      +"subject=Hyperlink");
		cell.setHyperlink(hyperLink);
		cell.setCellStyle(hlinkstyle);
		FileOutputStream fos = new FileOutputStream(new File("hyperLink.xlsx"));
		workbook.write(fos);
		fos.close();
		System.out.println("hyperlink.xlsx written successfully");
	}