import org.apache.poi.common.usermodel.HyperlinkType; //导入依赖的package包/类
/**
 * セルにハイパーリンクを設定する。
 * 
 * @param cell セル
 * @param type リンクタイプ
 * @param address ハイパーリンクアドレス
 * @see org.apache.poi.common.usermodel.Hyperlink
 */
public static void setHyperlink( Cell cell, HyperlinkType hyperlinkType, String address) {

    Workbook wb = cell.getRow().getSheet().getWorkbook();

    CreationHelper createHelper = wb.getCreationHelper();

    Hyperlink link = createHelper.createHyperlink( hyperlinkType);
    if ( link instanceof HSSFHyperlink) {
        (( HSSFHyperlink) link).setTextMark( address);
    } else if ( link instanceof XSSFHyperlink) {
        (( XSSFHyperlink) link).setAddress( address);
    }

    cell.setHyperlink( link);
}
 

import org.apache.poi.common.usermodel.HyperlinkType; //导入依赖的package包/类
@SuppressWarnings("resource")
@Test
public void testAddRow() {
  Calendar cal = Calendar.getInstance();
  Date date = new Date();
  writer.addRow("def");
  writer
      .addRow(null, true, cal, date, 1.1, new HSSFRichTextString("Hello!"),
          new XSSFRichTextString("World."), new HSSFWorkbook()
              .getCreationHelper().createHyperlink(HyperlinkType.URL),
          123, "abc");
  assertEquals("def", writer.getWorkbook().getSheetAt(0).rowIterator().next()
      .cellIterator().next().getStringCellValue());
  WorkbookWriter.openXLSX().addRow(new HSSFRichTextString("Hello!"),
      new XSSFRichTextString("World."));
  WorkbookWriter.openXLS().addRow(new HSSFRichTextString("Hello!"),
      new XSSFRichTextString("World."));

}
 

import org.apache.poi.common.usermodel.HyperlinkType; //导入依赖的package包/类
private void writeWorkbook() throws java.io.IOException {
    Workbook wb = new XSSFWorkbook();
    try {
        Sheet sheet = wb.createSheet("Sheet1");
        Row row = sheet.createRow(0);
        Cell cell = row.createCell(0);
        cell.setCellValue("cell-1");
        cell = row.createCell(1);
        cell.setCellValue("cell-2");
        cell = row.createCell(2);
        cell.setCellValue("cell-3");

        XSSFCellStyle style = (XSSFCellStyle) wb.createCellStyle();
        style.setFillBackgroundColor(new XSSFColor(new org.apache.poi.java.awt.Color(1, 2, 3)));

        Hyperlink link = wb.getCreationHelper().createHyperlink(HyperlinkType.URL);
        link.setAddress("http://www.google.at");
        link.setLabel("Google");
        cell.setHyperlink(link);

        cell.setCellStyle(style);

        sheet.setPrintGridlines(true);

        OutputStream stream = openFileOutput("test.xlsx", Context.MODE_PRIVATE);
        try {
            wb.write(stream);
        } finally {
            stream.close();
        }
    } finally {
        wb.close();
    }
}
 

import org.apache.poi.common.usermodel.HyperlinkType; //导入依赖的package包/类
private Hyperlink setAttachmentURLLinks(SignupAttachment attach) {
	Hyperlink hsHyperlink = wb.getCreationHelper().createHyperlink(HyperlinkType.URL);
	String link = this.sakaiFacade.getServerConfigurationService().getServerUrl()
			+ attach.getLocation();
	hsHyperlink.setAddress(link);
	hsHyperlink.setLabel(attach.getFilename());
	return hsHyperlink;
}
 

import org.apache.poi.common.usermodel.HyperlinkType; //导入依赖的package包/类
private void addReportSheet(final Workbook workbook) {
    final Sheet reportSheet = workbook.createSheet("Report");
    final CreationHelper creationHelper = workbook.getCreationHelper();

    final int PCODE_COL_NUM = 0;
    final int INCIDENT_COL_NUM = 1;
    final int DATASET_IMPORT_STATUS = 2;
    final int SUPPORTING_DATA_DESC_COL_NUM = 3;
    final int SUPPORTING_DATA_VALUES_COL_NUM = 4;
    final int DATASET_TITLE_COL_NUM = 5;

    final CellStyle headerCellStyle = workbook.createCellStyle();
    final Font headerFont = workbook.createFont();
    headerFont.setBold(true);
    headerCellStyle.setFont(headerFont);
    headerCellStyle.setAlignment(HorizontalAlignment.CENTER);
    headerCellStyle.setVerticalAlignment(VerticalAlignment.TOP);
    headerCellStyle.setFillBackgroundColor(IndexedColors.GREY_40_PERCENT.getIndex());

    final CellStyle labelValueCellStyle = workbook.createCellStyle();
    labelValueCellStyle.setAlignment(RIGHT);


    final AtomicInteger rowNum = new AtomicInteger(0);

    final Row headersRow = reportSheet.createRow(rowNum.getAndAdd(1));
    int headerColumnNum = PCODE_COL_NUM;
    addCell(headersRow, headerColumnNum++, "P-code", headerCellStyle);
    addCell(headersRow, headerColumnNum++, "Incident", headerCellStyle);
    addCell(headersRow, headerColumnNum++, "Impact on\nDataset migration", headerCellStyle);

    addCell(headersRow, headerColumnNum++, "Incident Data Description", headerCellStyle);
    addCell(headersRow, headerColumnNum++, "Incident Data", headerCellStyle);

    addCell(headersRow, headerColumnNum++, "Indicator", headerCellStyle);

    incidentLogEntries.forEach(logEntry -> {
        final Row row = reportSheet.createRow(rowNum.getAndAdd(1));

        int valueColumnNum = 0;

        final Cell pCodeCell = addCell(row, valueColumnNum++, logEntry.getPCode());
        final Hyperlink pCodeHyperlink = creationHelper.createHyperlink(HyperlinkType.URL);
        pCodeHyperlink.setAddress(
            "https://indicators.hscic.gov.uk/webview/velocity?v=2&mode=documentation&submode=ddi&study=http%3A%2F%2F192.168.229.22%3A80%2Fobj%2FfStudy%2F"
                + logEntry.getPCode()
        );
        pCodeCell.setHyperlink(pCodeHyperlink);

        addCell(row, valueColumnNum++, logEntry.getIncidentType().getDescription());
        addCell(row, valueColumnNum++, logEntry.getIncidentType().getDatasetMigrationImpact().getDescription());
        addCell(row, valueColumnNum++, logEntry.getIncidentType().getSupportingDataDescription() +
                (isBlank(logEntry.getIncidentType().getSupportingDataDescription()) ? "" : ":"),
            labelValueCellStyle
        );
        addCell(row, valueColumnNum++, logEntry.getSupportingData().stream().collect(joining("\n")));
        addCell(row, valueColumnNum++, datasetRepository.findById(logEntry.getPCode()).getTitle());
    });

    reportSheet.autoSizeColumn(PCODE_COL_NUM);
    reportSheet.autoSizeColumn(INCIDENT_COL_NUM);
    reportSheet.autoSizeColumn(DATASET_IMPORT_STATUS);
    reportSheet.autoSizeColumn(SUPPORTING_DATA_DESC_COL_NUM);
    reportSheet.autoSizeColumn(SUPPORTING_DATA_VALUES_COL_NUM);
    reportSheet.autoSizeColumn(DATASET_TITLE_COL_NUM);
}
 

import org.apache.poi.common.usermodel.HyperlinkType; //导入依赖的package包/类
private static Optional<PptVariable> parseHyperlinkVariale(Hyperlink<?, ?> link) {
	if(link != null && link.getTypeEnum() == HyperlinkType.URL) {
		return PptParser.parse(link.getAddress());
	}
	return Optional.empty();
}