设置列标题提示
Contents
[
Hide
]
可能的使用场景
在工作表中创建表格时,您可能需要为自定义列设置工具提示。Aspose.Cells.GridWeb允许您重命名列标题并为列设置工具提示,这样用户就可以轻松理解列的作用。
设置列标题提示
下面提供了完整的示例以演示如何更改列标题并应用工具提示文本。执行示例代码后,当您将鼠标光标放在指定列的标题上时,工具提示文本将弹出显示。
示例代码
以下是test.jsp文件的示例代码。
<%@ page language="java" contentType="text/html; charset=UTF-8"
import="com.aspose.gridweb.*" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="X-UA-Compatible" content="IE=EmulateIE9"/>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Setting Column Header ToolTip</title>
<%
ExtPage BeanManager=ExtPage.getInstance();
GridWebBean gridweb=BeanManager.getBean(request);
out.println(gridweb.getHTMLHead());
%>
</head>
<BODY>
<%
gridweb.setReqRes(request, response);
gridweb.setEnableAsync(false);
//Access the first worksheet
GridWorksheet gridSheet = gridweb.getWorkSheets().get(0);
//Input data into the cells of the first worksheet.
gridSheet.getCells().get("A1").putValue("Product1");
gridSheet.getCells().get("A2").putValue("Product2");
gridSheet.getCells().get("A3").putValue("Product3");
gridSheet.getCells().get("A4").putValue("Product4");
gridSheet.getCells().get("B1").putValue(100);
gridSheet.getCells().get("B2").putValue(200);
gridSheet.getCells().get("B3").putValue(300);
gridSheet.getCells().get("B4").putValue(400);
//Set the caption of the first two columns.
gridSheet.setColumnCaption(0, "Product Name");
gridSheet.setColumnCaption(1, "Price");
//Set the column width of the first column.
gridSheet.getCells().setColumnWidth(0, 20);
//Set the second column header's tip.
gridSheet.setColumnHeaderToolTip(1, "Unit Price of Products");
gridweb.prepareRender();
out.println(gridweb.getHTMLBody());
%>
<br>
</BODY>
</html>