29 June 2005
| Release 1.6.1 29 June 2005 |
Developer's reference |
|
| Reference > N_XLS_WORKSHEET > of_merge_write |
of_merge_write() method
Write data to the merged cells
Syntax
| worksheet.of_merge_write (first_row, first_col, last_row, last_col{, Value}, format) |
Parameters
| First_row | The unsigned integer whose value is the number of first row in the range |
| First_col | The unsigned integer whose value is the number of first column in the range |
| Last_row | The unsigned integer whose value is the number of last row in the range |
| Last_col | The unsigned integer whose value is the number of last column in the range |
| Value (optional) | 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 |
| Format | A reference to the n_xls_format object |
Return value
Integer. Returns 1 if it succeeds and -1 if an error occurs.
Description
The of_merge_write() method doesn't work with Excel versions before Excel 97. The format object that is used with a of_merge_write() method call is marked internally as being associated with a merged range. As such, it shouldn't be used for other formatting.
Examples
n_cst_unicode lnvo_unicode_srv
worksheet.of_merge_write ( 0, 0, 1, 0, 123, format1 ) //write number to A1:A2 cells
worksheet.of_merge_write ( 0, 1, 0, 3, 'Hello world', format2 ) //write string to B1:D1 cells
//write unicode string to F1:H2 cells
worksheet.of_merge_write ( 0, 5, 1, 7,&
lnvo_unicode_srv.of_ansi2unicode('English value') +&
lnvo_unicode_srv.of_ansi2unicode(ls_greek_value, 1253) +&
lnvo_unicode_srv.of_ansi2unicode(ls_russian_value, 1251),&
format2)
| © 2003-2005 Desta, Ltd. All rights reserved. | SupportDesk |