Table of Contents

XlsFile.GetCellFormat Method

Overloads

XlsFile.GetCellFormat(Int32, Int32)

Cell Format for a given cell This method gets the Format number (XF) of a cell. You can create new formats using the ExcelFile.AddFormat function.

Remarks

This method DOES NOT return the format for an empty cell, even if it has a column or a row format. For the visible format of the cell, see ExcelFile.GetCellVisibleFormat(Int32, Int32)

Syntax

Namespace: FlexCel.XlsAdapter

public override Int32 GetCellFormat(Int32 row, Int32 col)

Parameters

<-> Parameter Type Description
row Int32 Row Index (1 based)
col Int32 Column Index (1 based)

Returns

XF for the cell.

Examples

To copy the format on cell A1 to B2 you should write:

    xls.SetCellFormat(2, 2, xls.GetCellFormat(1, 1));

See also

XlsFile.GetCellFormat(Int32, Int32, Int32)

Cell Format for a given cell This method gets the Format number (XF) of a cell. You can create new formats using the ExcelFile.AddFormat function.

Remarks

This method DOES NOT return the format for an empty cell, even if it has a column or a row format. For the visible format of the cell, see ExcelFile.GetCellVisibleFormat(Int32, Int32)

Syntax

Namespace: FlexCel.XlsAdapter

public override Int32 GetCellFormat(Int32 sheet, Int32 row, Int32 col)

Parameters

<-> Parameter Type Description
sheet Int32 Sheet index (1 based).
row Int32 Row Index (1 based)
col Int32 Column Index (1 based)

Returns

XF for the cell.

Examples

To copy the format on cell A1 to B2 you should write:

    xls.SetCellFormat(2, 2, xls.GetCellFormat(1, 1));

See also