—T100 POI导出EXCEL添加超链接
1.引入jar包里面的方法
IMPORT JAVA org.apache.poi.hssf.usermodel.HSSFHyperlink
IMPORT JAVA org.apache.poi.ss.usermodel.CreationHelper
IMPORT JAVA org.apache.poi.ss.usermodel.Hyperlink
IMPORT JAVA org.apache.poi.hssf.usermodel.HSSFCreationHelper
2.定义变量2个
DEFINE link HSSFHyperlink
DEFINE createHelper HSSFCreationHelper
3字段上面超链接
LET cell = row.createCell(0)
LET createHelper = workbook.getCreationHelper()
LET link =createHelper.createHyperlink(Hyperlink.LINK_URL)
call link.setAddress(“http:// www.baidu.com”)
CALL cell.setHyperlink(link)
CALL cell.setCellValue(“税前金额”)
CALL cell.setCellStyle(style_cell) #可以在单独做一个style 这个超链接没有自带颜色
—POI导出excel锁定表头
CALL sheet.createFreezePane(6,2) //从第六列第二行开始锁定
转载请注明:赫非域 » TIPTOP T100导出EXCEL加超链接