Worksheet::SetColFormats

SetColFormats

1 Description
2 Syntax
3 Parameters
4 Return
5 Examples
6 Remark
7 See Also
8 header to Include

Description

Sets the column formats in a worksheet.

Syntax

BOOL SetColFormats( LPCSTR lpcszFormats, BOOL bRepeat = TRUE )

Parameters

lpcszFormats: [input] String containing packed numbers indicating column Format for all columns in worksheet
bRepeat: [input] Repeat entire pattern over remaining columns (TRUE) or set designations for the rest of columns to be the last one defined by pattern (FALSE);; default is TRUE.

Return

TRUE on success, FALSE on failure.

Examples

EX1

// the following code will set column formats in a new worksheet
// 1st column - Numeric (0)
// 2nd column - Text    (1)
// 3rd column - Time    (2)
// 4th column - Date    (3)
// 5th column - Text and Numeric (9)
void Worksheet_SetColFormats_Ex1()
{
    Worksheet wks;
    wks.Create("origin", CREATE_VISIBLE);
    wks.AddCol();
    wks.AddCol();
    wks.AddCol();
    string strFormats="01239";
    wks.SetColFormats(strFormats);
}