java操作excel 插入读取超链接

最新推荐文章于 2024-08-09 02:30:56 发布

转载最新推荐文章于 2024-08-09 02:30:56 发布 · 4.6k 阅读

1 Java面向对象高级编程专栏收录该内容

26 篇文章

订阅专栏

本文介绍使用Java通过SmartXLS库来实现Excel文件中插入及读取超链接的方法。包括如何添加URL链接和文件路径链接，并展示如何从Excel中读取这些链接。

java操作excel 插入读取超链接需要smartxls jar包

import com.smartxls.HyperLink;
import com.smartxls.WorkBook;

public class HyperlinkReadSample
{

 public static void main(String args[])
{

 WorkBook workBook = new WorkBook();
 String version = workBook.getVersionString();
 System.out.println("Ver:"+ version);
try
{
workBook.read("..\template\book.xls");

 // get the first index from the current sheet
 HyperLink hyperLink = workBook.getHyperlink(0);
 if(hyperLink != null)
{
System.out.println(hyperLink.getType());
System.out.println(hyperLink.getLinkURLString());
System.out.println(hyperLink.getLinkShowString());
System.out.println(hyperLink.getToolTipString());
System.out.println(hyperLink.getRange());
}
}
 catch (Exception e)
{
e.printStackTrace();
}
}
}

import com.smartxls.HyperLink;
import com.smartxls.WorkBook;

public class HyperlinkWriteSample
{

 public static void main(String args[])
{
 WorkBook workBook = new WorkBook();
try
{
 //add a url link to F6
 workBook.addHyperlink(5,5,5,5,"http://www.smartxls.com/", HyperLink.kURLAbs,"Hello,web url hyperlink!");

 //add a file link to F7
 workBook.addHyperlink(6,5,6,5,"c:\",HyperLink.kFileAbs,"file link");

workBook.write(".\link.xls");
}
 catch (Exception e)
{
e.printStackTrace();
}
}
}

http://www.thinksaas.cn/topics/0/83/83309.html