⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 headerandfooterstring.htm

📁 pbto execel 使用控件将powerbuilder 中数据窗口内容导出excel文件中
💻 HTM
字号:
🔍 
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<html>
<head>

<title>Pb2xls developer's reference</title>
<link rel="STYLESHEET" href="style.css" type="text/css">
</head>

<body bgcolor="#FFFFFF">

<!-- Reference header -->
<table width="100%" cellpadding=0 cellspacing=0>
  <tr>
    <td class=footer_text width=20%>Release 1.6<br>15 September 2004</td>
    <td class=doc_header align="center">Developer's reference</td>
    <td width=20% align="right">
      <a class=hidden_link href="http://desta.com.ua/pb2xls/"><img src=pb2xls_logo.gif alt="PB2XLS for PowerBuilder" border=0></a></td>
  </tr>
</table>
<hr>



<table cellspacing=0 cellpadding=0 class=path_table> <tr><td><a class=hidden_link href=reference.htm>Reference</a> &gt; <a class=hidden_link href=n_xls_worksheet.htm>N_XLS_WORKSHEET</a> &gt; <a class=hidden_link href=headerandfooterstring.htm>Header and footer string</a></td></tr> </table>
<table width=100%><tr><td class=light_line></td></tr></table><p class=head1>
Header and footer string
</p>
<p class=txt>
The header and footer is a combination of plain text and control characters.
</p>
<div class=padding_txt><table border="1" bordercolor="#c0c0c0" cellspacing="0" cellpadding="0">
<tr><td class=msa><b>Control</b></td><td class=msa><b>Description</b></td></tr>
<tr><td class=msa>&L</td><td class=msa>Left justification</td></tr>
<tr><td class=msa>&C</td><td class=msa>Center justification</td></tr>
<tr><td class=msa>&R</td><td class=msa>Right justification</td></tr>
<tr><td class=msa>&P</td><td class=msa>Page number</td></tr>
<tr><td class=msa>&N</td><td class=msa>Total number of pages</td></tr>
<tr><td class=msa>&D</td><td class=msa>Date</td></tr>
<tr><td class=msa>&T</td><td class=msa>Time</td></tr>
<tr><td class=msa>&F</td><td class=msa>File name</td></tr>
<tr><td class=msa>&A</td><td class=msa>Worksheet name</td></tr>
<tr><td class=msa>&fontsize</td><td class=msa>Font size</td></tr>
<tr><td class=msa>&"font,style"</td><td class=msa>Font name and style</td></tr>
<tr><td class=msa>&U</td><td class=msa>Single underline</td></tr>
<tr><td class=msa>&E</td><td class=msa>Double underline</td></tr>
<tr><td class=msa>&S</td><td class=msa>Strikethrough</td></tr>
<tr><td class=msa>&X</td><td class=msa>Superscript</td></tr>
<tr><td class=msa>&Y</td><td class=msa>Subscript</td></tr>
<tr><td class=msa>&&</td><td class=msa>Literal ampersand &</td></tr>
</table></div>
<p class=txt>
Text in headers and footers can be justified (aligned) to the left, center and right by prefixing the text with the control characters &L, &C and &R.<br>
For example:
</p>
<pre>
worksheet1.of_set_header( '&RHeader', 0.50 ) //Header justified to the right    
worksheet2.of_set_header( '&LHeader', 0.50 ) //Header justified to the left    
worksheet3.of_set_header( '&CHeader', 0.50 ) //Header justified to the center    </pre>
<p class=txt>
For simple text, if you do not specify any justification the text will be centred. However, you must prefix the text with &C if you specify a font name or any other formatting.<br>
You can have text in each of the justification regions:
</p>
<pre>
worksheet.of_set_header( '&Rright text&Ccenter text&Lleft text', 0.50 )</pre>
<p class=txt>
You can specify the font size of a section of the text by prefixing it with the control character &n where n is the font size:    
</p>
<pre>
worksheet1.of_set_header('&L&40Big header', 0.50 )
worksheet2.of_set_header('&L&9Small header', 0.50 )</pre>
<p class=txt>
You can specify the font of a section of the text by prefixing it with the control sequence &"font,style" where font is a font name such as "Arial" or "Times New Roman" and style is one of the standard Windows font descriptions: "Regular", "Bold" , "Italic"or "Bold Italic":
</p>
<pre>
worksheet.of_set_header('&L&"Arial,Bold"Header', 0.50 )</pre>

<table border=0 width="100%" cellpadding=0 cellspacing=0>
  <tr><td colspan=2 class=empty_line></td></tr>
  <tr><td colspan=2 class=line></td></tr>
  <tr>
    <td class=footer_text align="left">&copy; 2003, 2004 <a class=hidden_link href="http://desta.com.ua">Desta, Ltd.</a> All rights reserved.</td>
    <td class=footer_text align="right">
      <a class=hidden_link href="mailto:pb2xls_support@Desta.com.ua">SupportDesk</a></td>
  </tr>
</table>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -