使用 jxl for java 指定 WritableHyperlink 的单元格格式

发布于 2024-10-27 04:39:18 字数 403 浏览 5 评论 0原文

我正在使用 jxl（用于 MS Excel 文件操作的基于 Java 的 API）来创建 Excel 报告。我插入这样的超链接

//sheet is WritableSheet
//adding hyperlink to cell 0,0 of the sheet
WritableHyperlink hl = new WritableHyperlink(0, 0, "http://www.google.com", "home page");
sheet.addHyperlink(hl);

这工作正常，但它以默认单元格格式显示数据，即白色单元格和蓝色字体。有什么方法可以为这个超链接指定单元格格式，就像为标签或数字所做的那样。这很重要，因为此超链接会打开错误屏幕截图，因此根据规范，单元格应为红色。

谢谢

原文

I'm using jxl(a Java based API for MS excel file manipulation) to create excel reports. I'm inserting the hyperlink like this

//sheet is WritableSheet
//adding hyperlink to cell 0,0 of the sheet
WritableHyperlink hl = new WritableHyperlink(0, 0, "http://www.google.com", "home page");
sheet.addHyperlink(hl);

This works fine, but it displays the data in default cell format, which is white colored cell and blue font. Is there any way by which I can specify cell format for this hyperlink like it is done for a label or number. This is important because this hyperlink opens the error screenshot, so as per the specification the cell should be in Red color.

Thanks

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

一百个冬季 2024-11-03 04:39:18

为与超链接相同的单元格设置一个您想要的格式的标签，例如：

    WritableHyperlink hl = new WritableHyperlink(0, 0, 
            new URL("http://www.google.com"));
    sheet.addHyperlink(hl);

    WritableFont redFont = new WritableFont(WritableFont.ARIAL);
    redFont.setColour(Colour.RED);
    WritableCellFormat cellFormat = new WritableCellFormat(redFont);
    Label label = new Label(0, 0, "home page", cellFormat);
    sheet.addCell(label);

Set a label formatted how you'd like for the same cell as the hyperlink, e.g.:

    WritableHyperlink hl = new WritableHyperlink(0, 0, 
            new URL("http://www.google.com"));
    sheet.addHyperlink(hl);

    WritableFont redFont = new WritableFont(WritableFont.ARIAL);
    redFont.setColour(Colour.RED);
    WritableCellFormat cellFormat = new WritableCellFormat(redFont);
    Label label = new Label(0, 0, "home page", cellFormat);
    sheet.addCell(label);

回复收藏 0 原文

~没有更多了~