ExcelFile.GetCellFormat Method
Overloads
ExcelFile.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 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 GetCellVisibleFormat(Int32, Int32)
Syntax
Namespace: FlexCel.Core
public abstract 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
ExcelFile.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 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 GetCellVisibleFormat(Int32, Int32)
Syntax
Namespace: FlexCel.Core
public abstract 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));