📄 of_set_num_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_format.htm>N_XLS_FORMAT</a> > <a class=hidden_link href=of_set_num_format.htm>of_set_num_format</a></td></tr> </table>
<table width=100%><tr><td class=light_line></td></tr></table><p class=head1>
of_set_num_format() method
</p>
<p class=txt>
Define the numerical format of a number in Excel. It controls whether a number is displayed as an integer, a floating point number, a date, a currency value or some other user defined format
</p>
<p class=head2>Syntax</p>
<div class=padding_txt>
<table cellpadding=7><tr class=grey_box><td class=txt>
<i>format.</i><b>of_set_num_format </b><i>( 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>Format</i></td><td class=txt>A string or a blob (unicode string) whose value is the numerical format or an integer whose value is the index of built-in format</td></tr>
</table></div>
<div class=padding_txt> <p class=txt>
Excel's built-in formats are shown in the following table: </p></div>
<div class=padding_txt><table border="1" bordercolor="#c0c0c0" cellspacing="0" cellpadding="0">
<tr><td class=msa><b>Index</b></td><td class=msa><b>Format String</b></td></tr>
<tr><td class=msa>0</td><td class=msa>General</td></tr>
<tr><td class=msa>1</td><td class=msa>0</td></tr>
<tr><td class=msa>2</td><td class=msa>0.00</td></tr>
<tr><td class=msa>3</td><td class=msa>#,##0</td></tr>
<tr><td class=msa>4</td><td class=msa>#,##0.00</td></tr>
<tr><td class=msa>5</td><td class=msa>($#,##0_);($#,##0)</td></tr>
<tr><td class=msa>6</td><td class=msa>($#,##0_);[Red]($#,##0)</td></tr>
<tr><td class=msa>7</td><td class=msa>($#,##0.00_);($#,##0.00)</td></tr>
<tr><td class=msa>8</td><td class=msa>($#,##0.00_);[Red]($#,##0.00)</td></tr>
<tr><td class=msa>9</td><td class=msa>0%</td></tr>
<tr><td class=msa>10</td><td class=msa>0.00%</td></tr>
<tr><td class=msa>11</td><td class=msa>0.00E+00</td></tr>
<tr><td class=msa>12</td><td class=msa># ?/?</td></tr>
<tr><td class=msa>13</td><td class=msa># ??/??</td></tr>
<tr><td class=msa>14</td><td class=msa>m/d/yy</td></tr>
<tr><td class=msa>15</td><td class=msa>d-mmm-yy</td></tr>
<tr><td class=msa>16</td><td class=msa>d-mmm</td></tr>
<tr><td class=msa>17</td><td class=msa>mmm-yy</td></tr>
<tr><td class=msa>18</td><td class=msa>h:mm AM/PM</td></tr>
<tr><td class=msa>19</td><td class=msa>h:mm:ss AM/PM</td></tr>
<tr><td class=msa>20</td><td class=msa>h:mm</td></tr>
<tr><td class=msa>21</td><td class=msa>h:mm:ss</td></tr>
<tr><td class=msa>22</td><td class=msa>m/d/yy h:mm</td></tr>
<tr><td class=msa>..</td><td class=msa>...........</td></tr>
<tr><td class=msa>37</td><td class=msa>(#,##0_);(#,##0)</td></tr>
<tr><td class=msa>38</td><td class=msa>(#,##0_);[Red](#,##0)</td></tr>
<tr><td class=msa>39</td><td class=msa>(#,##0.00_);(#,##0.00)</td></tr>
<tr><td class=msa>40</td><td class=msa>(#,##0.00_);[Red](#,##0.00)</td></tr>
<tr><td class=msa>41</td><td class=msa>_(* #,##0_);_(* (#,##0);_(* "-"_);_(@_)</td></tr>
<tr><td class=msa>42</td><td class=msa>_($* #,##0_);_($* (#,##0);_($* "-"_);_(@_)</td></tr>
<tr><td class=msa>43</td><td class=msa>_(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_)</td></tr>
<tr><td class=msa>44</td><td class=msa>_($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_)</td></tr>
<tr><td class=msa>45</td><td class=msa>mm:ss</td></tr>
<tr><td class=msa>46</td><td class=msa>[h]:mm:ss</td></tr>
<tr><td class=msa>47</td><td class=msa>mm:ss.0</td></tr>
<tr><td class=msa>48</td><td class=msa>##0.0E+0</td></tr>
<tr><td class=msa>49</td><td class=msa>@</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. If argument value is NULL, of_create returns NULL.</p></div>
<p class=head2>
Description
</p>
<div class=padding_txt><p class=txt>
Default format is General.<br>
You should ensure that the format string is valid in Excel prior to using it in WriteExcel.</p></div>
<p class=head2>
Examples
</p>
<pre>
format1.<a class=hidden_link href=of_set_num_format.htm>of_set_num_format</a> ( 'd mmm yyyy' ) // Format string
format2.<a class=hidden_link href=of_set_num_format.htm>of_set_num_format</a> ( 15 ) //built-in format
format3.<a class=hidden_link href=of_set_num_format.htm>of_set_num_format</a> ( '0.000' )
format4.<a class=hidden_link href=of_set_num_format.htm>of_set_num_format</a> ( '#,##0' )
format5.<a class=hidden_link href=of_set_num_format.htm>of_set_num_format</a> ( '#,##0.00' )
format6.<a class=hidden_link href=of_set_num_format.htm>of_set_num_format</a> ( '$0.00' )
format7.<a class=hidden_link href=of_set_num_format.htm>of_set_num_format</a> ( 'mm/dd/yy' )</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 + -