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

📄 example05.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=examples.htm>Examples</a> &gt; <a class=hidden_link href=example05.htm>example05</a></td></tr> </table>
<table width=100%><tr><td class=light_line></td></tr></table><p class=head2>
Example05
</p>
<pre>
n_xls_workbook book
<a class=hidden_link href=n_xls_worksheet.htm>n_xls_worksheet</a> sheet1
<a class=hidden_link href=n_xls_format.htm>n_xls_format</a> format1

//for Excel97:
book = create <a class=hidden_link href=n_xls_workbook_v97.htm>n_xls_workbook_v97</a>

//for Excel5:
//book = create <a class=hidden_link href=n_xls_workbook_v5.htm>n_xls_workbook_v5</a>

book.<a class=hidden_link href=of_create.htm>of_create</a>("<a class=hidden_link href=example05.htm>example05</a>.xls")
book.<a class=hidden_link href=of_set_custom_color.htm>of_set_custom_color</a>(36, 240, 240, 240)

sheet1 = book.<a class=hidden_link href=of_add_worksheet.htm>of_add_worksheet</a>('sheet 1')

sheet1.<a class=hidden_link href=of_set_paper.htm>of_set_paper</a>(11)
sheet1.<a class=hidden_link href=of_set_landscape.htm>of_set_landscape()</a>
sheet1.<a class=hidden_link href=of_set_margins.htm>of_set_margins</a>(2)
sheet1.<a class=hidden_link href=of_set_header.htm>of_set_header</a>('&LLeft header&C&20Center header', 0.5)
sheet1.<a class=hidden_link href=of_set_footer.htm>of_set_footer</a>('&LLeft footer&C&8Center footer', 0.5)
sheet1.<a class=hidden_link href=of_set_print_scale.htm>of_set_print_scale</a>(140)

format1 = book.<a class=hidden_link href=of_add_format.htm>of_add_format()</a>
format1.<a class=hidden_link href=of_set_bg_color.htm>of_set_bg_color</a>(36)

sheet1.<a class=hidden_link href=of_write.htm>of_write</a>(0,0, 'Check  print preview...', format1)
sheet1.<a class=hidden_link href=of_set_column_width.htm>of_set_column_width</a>(0, 60)
book.<a class=hidden_link href=of_close.htm>of_close()</a>
</pre>
<p class=head2>
Screenshot
</p>
<img src="example05.gif" alt="" border="0">
<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 + -