import
java.io.File;
import
java.io.FileOutputStream;
import
org.apache.poi.common.usermodel.Hyperlink;
import
org.apache.poi.hssf.util.HSSFColor;
import
org.apache.poi.ss.usermodel.CreationHelper;
import
org.apache.poi.xssf.usermodel.XSSFCell;
import
org.apache.poi.xssf.usermodel.XSSFCellStyle;
import
org.apache.poi.xssf.usermodel.XSSFFont;
import
org.apache.poi.xssf.usermodel.XSSFHyperlink;
import
org.apache.poi.xssf.usermodel.XSSFSheet;
import
org.apache.poi.xssf.usermodel.XSSFWorkbook;
public
class
HyperLink {
public
static
void
addLink()
{
XSSFWorkbook myWorkbook =
new
XSSFWorkbook();
XSSFSheet newSpreadsheet
= myWorkbook.createSheet(
"Custom Links"
);
XSSFCell cell;
CreationHelper helper
= myWorkbook.getCreationHelper();
XSSFCellStyle linkStyle
= myWorkbook.createCellStyle();
XSSFFont linkFont = myWorkbook.createFont();
linkFont.setUnderline(XSSFFont.U_SINGLE);
linkFont.setColor(HSSFColor.BLUE.index);
linkStyle.setFont(linkFont);
cell = newSpreadsheet.createRow(
1
).createCell(
(
short
)
2
);
cell.setCellValue(
"Link"
);
XSSFHyperlink link
= (XSSFHyperlink)helper.createHyperlink(
Hyperlink.LINK_URL);
cell.setHyperlink((XSSFHyperlink)link);
cell.setCellStyle(linkStyle);
FileOutputStream output =
new
FileOutputStream(
new
File(
"C:/HyperLink.xlsx"
));
myWorkbook.write(output);
output.close();
}
public
static
void
main(String[] args)
throws
Exception
{
addLink();
}
}