本文整理汇总了Java中org.apache.poi.hssf.usermodel.HSSFHyperlink.setAddress方法的典型用法代码示例。如果您正苦于以下问题:Java HSSFHyperlink.setAddress方法的具体用法?Java HSSFHyperlink.setAddress怎么用?Java HSSFHyperlink.setAddress使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类org.apache.poi.hssf.usermodel.HSSFHyperlink
的用法示例。
在下文中一共展示了HSSFHyperlink.setAddress方法的3个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: createLinkCell
import org.apache.poi.hssf.usermodel.HSSFHyperlink; //导入方法依赖的package包/类
public void createLinkCell(HSSFCell cell, String value, String target, boolean bordered) {
cell.setCellValue(value);
final HSSFHyperlink link = new HSSFHyperlink(HSSFHyperlink.LINK_DOCUMENT);
link.setAddress("'" + normalizeAsLink(target) + "'!A1");
cell.setHyperlink(link);
if (bordered) {
cell.setCellStyle(borderedLinkStyle);
} else {
cell.setCellStyle(linkStyle);
}
}
示例2: createCell
import org.apache.poi.hssf.usermodel.HSSFHyperlink; //导入方法依赖的package包/类
/**
* Create a HSSFCell in row with hyperlink, index and value.
*
* @param row HSSFRow
* @param index int
* @param value String
* @param url String
* @return HSSFCell
*/
public static HSSFCell createCell(HSSFRow row, int index,
HSSFCellStyle cellStyle, String value, String url) {
HSSFCell cell = createCell(row, index, value);
HSSFHyperlink link = new HSSFHyperlink(HSSFHyperlink.LINK_URL);
link.setAddress(url);
cell.setHyperlink(link);
cell.setCellStyle(cellStyle);
return cell;
}
示例3: criarBodyXLS
import org.apache.poi.hssf.usermodel.HSSFHyperlink; //导入方法依赖的package包/类
private void criarBodyXLS(HSSFWorkbook wb, HSSFSheet sheet, int numLinha, PessoaVO pessoa, Set<DadosRetInstVO> listResultados) {
DadosXLSService service = new DadosXLSService();
service.prepareBody(pessoa, listResultados);
List<Column> listBody = service.getValuesBody();
HSSFRow row = sheet.createRow(numLinha);
// tipo de validacao na coluna 0.
int i = 0;
for(Column value: listBody) {
if(value instanceof ColumnLink) {
// cria o link na planilha
HSSFHyperlink link = new HSSFHyperlink(HSSFHyperlink.LINK_URL);
String url = urlPaginaRetorno + NOME_SERVLET + value.getValue();
link.setAddress(url);
HSSFCell cellLink = row.createCell(i++);
cellLink.setHyperlink(link);
ColumnLink columnLink = (ColumnLink) value;
cellLink.setCellValue(new HSSFRichTextString(columnLink.getTextoLink()));
} else {
row.createCell(i++, HSSFCell.CELL_TYPE_STRING).setCellValue(new HSSFRichTextString(value.getValue()));
}
}
// preenchimento da folha de estilo. do mesmo tamanho do cabecalho.
for (int numColuna = 0; numColuna < listBody.size(); numColuna++) {
row.getCell(numColuna).setCellStyle(estiloDadosRetorno(wb));
int tamanhoColuna = row.getCell(numColuna).getRichStringCellValue().getString().length();
autoSizing(sheet, numColuna, tamanhoColuna);
}
}