📄 of_merge_write.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_merge_write.htm>of_merge_write</a></td></tr> </table>
<table width=100%><tr><td class=light_line></td></tr></table><p class=head1>
of_merge_write() method
</p>
<p class=txt>
Write data to the merged cells
</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_merge_write </b><i>(first_row, first_col, last_row, last_col{, Value}, 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>First_row</i></td><td class=txt>The unsigned integer whose value is the number of first row in the range</td></tr>
<tr class=grey_box><td class=txt><i>First_col</i></td><td class=txt>The unsigned integer whose value is the number of first column in the range</td></tr>
<tr class=grey_box><td class=txt><i>Last_row</i></td><td class=txt>The unsigned integer whose value is the number of last row in the range</td></tr>
<tr class=grey_box><td class=txt><i>Last_col</i></td><td class=txt>The unsigned integer whose value is the number of last column in the range</td></tr>
<tr class=grey_box><td class=txt><i>Value (optional)</i></td><td class=txt>The value to which you want to set the data at the specified location. The data type of the value must be: integer, long, double, decimal, string, blob (unicode string), datetime, date or time</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>
The <a class=hidden_link href=of_merge_write.htm>of_merge_write()</a> method doesn't work with Excel versions before Excel 97. The format object that is used with a <a class=hidden_link href=of_merge_write.htm>of_merge_write()</a> method call is marked internally as being associated with a merged range. As such, it shouldn't be used for other formatting.</p></div>
<p class=head2>
Examples
</p>
<pre>
<a class=hidden_link href=n_cst_unicode.htm>n_cst_unicode</a> lnvo_unicode_srv
worksheet.<a class=hidden_link href=of_merge_write.htm>of_merge_write</a> ( 0, 0, 1, 0, 123, format1 ) //write number to A1:A2 cells
worksheet.<a class=hidden_link href=of_merge_write.htm>of_merge_write</a> ( 0, 1, 0, 3, 'Hello world', format2 ) //write string to B1:D1 cells
//write unicode string to F1:H2 cells
worksheet.<a class=hidden_link href=of_merge_write.htm>of_merge_write</a> ( 0, 5, 1, 7,&
lnvo_unicode_srv.<a class=hidden_link href=of_ansi2unicode.htm>of_ansi2unicode</a>('English value') +&
lnvo_unicode_srv.<a class=hidden_link href=of_ansi2unicode.htm>of_ansi2unicode</a>(ls_greek_value, 1253) +&
lnvo_unicode_srv.<a class=hidden_link href=of_ansi2unicode.htm>of_ansi2unicode</a>(ls_russian_value, 1251),&
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 + -