package org. jeecg. common. util ;
import org. apache. poi. ss. usermodel. * ;
import org. apache. poi. xssf. usermodel. XSSFWorkbook ;
import java. io. FileOutputStream ;
public class Test {
public static void main ( String [ ] args) throws Exception {
Workbook wb = new XSSFWorkbook ( ) ;
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" ) ;
Hyperlink link = createHelper. createHyperlink ( Hyperlink . LINK_FILE) ;
cell = sheet. createRow ( 1 ) . createCell ( ( short ) 5 ) ;
cell. setCellValue ( "pic20210923004607.png" ) ;
link. setAddress ( "pic20210923004607.png" ) ;
cell. setHyperlink ( link) ;
cell. setCellStyle ( hlink_style) ;
FileOutputStream out = new FileOutputStream ( "D:/lecoo/hyperinks2.xlsx" ) ;
wb. write ( out) ;
out. close ( ) ;
}
}
import java. io. FileOutputStream ;
import org. apache. poi. ss. usermodel ;
import org. apache. poi. xssf. usermodel. XSSFWorkbook ;
import org. apache. poi. ss. usermodel. IndexedColors ;
public class HyperlinkExample {
public static void main ( String [ ] args) throws Exception {
Workbook wb = new XSSFWorkbook ( ) ;
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" ) ;
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) ;
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) ;
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) ;
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 ( ) ;
}
}