📄 of_set_column_format.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> > <a class=hidden_link href=n_xls_worksheet.htm>N_XLS_WORKSHEET</a> > <a class=hidden_link href=of_set_column_format.htm>of_set_column_format</a></td></tr> </table>
<table width=100%><tr><td class=light_line></td></tr></table><p class=head1>
of_set_column_format() method
</p>
<p class=txt>
Set the default format of a single column
</p>
<p class=head2>Syntax</p>
<div class=padding_txt>
<table cellpadding=7><tr class=grey_box><td class=txt>
<i>worksheet.</i><b>of_set_column_format </b><i>( column, format )</i>
</td></tr></table></div>
<p class=head2>Parameters</p>
<div class=padding_txt>
<table cellpadding=3>
<tr class=grey_box><td class=txt><i>column</i></td><td class=txt>The long whose value is the number of column</td></tr>
<tr class=grey_box><td class=txt><i>format</i></td><td class=txt>A <a class=hidden_link href=reference.htm>reference</a> to the <a class=hidden_link href=n_xls_format.htm>n_xls_format</a> object</td></tr>
</table></div>
<p class=head2>
Return value
</p>
<div class=padding_txt> <p class=txt>
Integer. Returns 1 if it succeeds and -1 if an error occurs.</p></div>
<p class=head2>
Description
</p>
<div class=padding_txt><p class=txt>
If you wish to define a column format in this way you should call the method before any calls to <a class=hidden_link href=of_write.htm>of_write()</a>. If you call it afterwards it won't have any effect. <br>
A default row format takes precedence over a default column format. </p></div>
<p class=head2>
Examples
</p>
<pre>
worksheet.<a class=hidden_link href=of_set_column_format.htm>of_set_column_format</a>( format1 ) // Set format for first column
worksheet.<a class=hidden_link href=of_write.htm>of_write</a>( 0, 0, 'Hello world' ) //Defaults to format1
worksheet.<a class=hidden_link href=of_write.htm>of_write</a>( 1, 0, 'Hello world', format2 ) //Keeps format2
worksheet.<a class=hidden_link href=of_set_row_format.htm>of_set_row_format</a>(0, format1) //Set format for first row
worksheet.<a class=hidden_link href=of_set_column_format.htm>of_set_column_format</a>(0, format2) //Set format for first column
worksheet.<a class=hidden_link href=of_write.htm>of_write</a>( 0, 0, 'Hello world') // Defaults to format1
worksheet.<a class=hidden_link href=of_write.htm>of_write</a>( 1, 0, 'Hello world') //Defaults to format2</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">© 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 + -