ExcelFile.GetStringFromCell Method
Overloads
- ExcelFile.GetStringFromCell(String)
- ExcelFile.GetStringFromCell(Int32, Int32)
- ExcelFile.GetStringFromCell(Int32, Int32, Boolean)
- ExcelFile.GetStringFromCell(Int32, Int32, Int32, TUIColor)
- ExcelFile.GetStringFromCell(Int32, Int32, Int32, Int32, TUIColor)
- ExcelFile.GetStringFromCell(Int32, Int32, Int32, Int32, TUIColor, Boolean)
ExcelFile.GetStringFromCell(String)
This method will return a rich string that is formatted similar to the way Excel shows it. For example, if you have "1.0" on a cell, and the cell is formatted as exponential, this method will return "1.0e+1" It might also change the color depending on the value and format. (for example, red for negative numbers)
Syntax
Namespace: FlexCel.Core
public TRichString GetStringFromCell(String cellRef)
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
cellRef | String | Cell reference in A1 notation. Something like A3, or Sheet1!$B$5 can be used here. |
Returns
A rich string with the cell value.
See also
ExcelFile.GetStringFromCell(Int32, Int32)
This method will return a rich string that is formatted similar to the way Excel shows it. For example, if you have "1.0" on a cell, and the cell is formatted as exponential, this method will return "1.0e+1" It might also change the color depending on the value and format. (for example, red for negative numbers) Conditional formats are not applied, you need to call ConditionallyModifyFormat(TFlxFormat, Int32, Int32, Boolean, TDrawingConditionalFormat) to the cell style for that.
Syntax
Namespace: FlexCel.Core
public TRichString GetStringFromCell(Int32 row, Int32 col)
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
row | Int32 | Cell Row (1 based). | |
col | Int32 | Cell Column (1 based) |
Returns
A rich string with the cell value.
See also
ExcelFile.GetStringFromCell(Int32, Int32, Boolean)
This method will return a rich string that is formatted similar to the way Excel shows it. For example, if you have "1.0" on a cell, and the cell is formatted as exponential, this method will return "1.0e+1" It might also change the color depending on the value and format. (for example, red for negative numbers) Conditional formats are not applied, you need to call ConditionallyModifyFormat(TFlxFormat, Int32, Int32, Boolean, TDrawingConditionalFormat) to the cell style for that.
Syntax
Namespace: FlexCel.Core
public TRichString GetStringFromCell(Int32 row, Int32 col, Boolean ignorePrintErrors)
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
row | Int32 | Cell Row (1 based). | |
col | Int32 | Cell Column (1 based) | |
ignorePrintErrors | Boolean | If true, the string for an error like #DIV/0 will always by #DIV/0 instead of using the value of PrintErrors. Set it to true when the value is not for printing it. |
Returns
A rich string with the cell value.
See also
ExcelFile.GetStringFromCell(Int32, Int32, Int32, TUIColor)
This method will return a rich string that is formatted similar to the way Excel shows it. For example, if you have "1.0" on a cell, and the cell is formatted as exponential, this method will return "1.0e+1" It might also change the color depending on the value and format. (for example, red for negative numbers) Conditional formats are not applied, you need to call ConditionallyModifyFormat(TFlxFormat, Int32, Int32, Boolean, TDrawingConditionalFormat) to the cell style for that.
Syntax
Namespace: FlexCel.Core
public TRichString GetStringFromCell(Int32 row, Int32 col, ref Int32 XF, ref TUIColor aColor)
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
row | Int32 | Cell Row (1 based). | |
col | Int32 | Cell Column (1 based) | |
ref | XF | Int32 | The resulting XF for the cell. |
ref | aColor | TUIColor | Resulting color of the string. If for example you define red for negative numbers, and the result is red, this will be returned on aColor. If there is not color info on the format, it will remain unchanged. |
Returns
A rich string with the cell value.
See also
ExcelFile.GetStringFromCell(Int32, Int32, Int32, Int32, TUIColor)
This method will return a rich string that is formatted similar to the way Excel shows it. For example, if you have "1.0" on a cell, and the cell is formatted as exponential, this method will return "1.0e+1" It might also change the color depending on the value and format. (for example, red for negative numbers) Conditional formats are not applied, you need to call ConditionallyModifyFormat(TFlxFormat, Int32, Int32, Boolean, TDrawingConditionalFormat) to the cell style for that.
Syntax
Namespace: FlexCel.Core
public TRichString GetStringFromCell(Int32 sheet, Int32 row, Int32 col, ref Int32 XF, ref TUIColor aColor)
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
sheet | Int32 | Sheet where the cell is (1 based). | |
row | Int32 | Cell Row (1 based). | |
col | Int32 | Cell Column (1 based) | |
ref | XF | Int32 | The resulting XF for the cell. |
ref | aColor | TUIColor | Resulting color of the string. If for example you define red for negative numbers, and the result is red, this will be returned on aColor. If there is not color info on the format, it will remain unchanged. |
Returns
A rich string with the cell value.
See also
ExcelFile.GetStringFromCell(Int32, Int32, Int32, Int32, TUIColor, Boolean)
This method will return a rich string that is formatted similar to the way Excel shows it. For example, if you have "1.0" on a cell, and the cell is formatted as exponential, this method will return "1.0e+1" It might also change the color depending on the value and format. (for example, red for negative numbers) Conditional formats are not applied, you need to call ConditionallyModifyFormat(TFlxFormat, Int32, Int32, Boolean, TDrawingConditionalFormat) to the cell style for that.
Syntax
Namespace: FlexCel.Core
public abstract TRichString GetStringFromCell(Int32 sheet, Int32 row, Int32 col, ref Int32 XF, ref TUIColor aColor, Boolean ignorePrintErrors)
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
sheet | Int32 | Sheet where the cell is (1 based). | |
row | Int32 | Cell Row (1 based). | |
col | Int32 | Cell Column (1 based) | |
ref | XF | Int32 | The resulting XF for the cell. |
ref | aColor | TUIColor | Resulting color of the string. If for example you define red for negative numbers, and the result is red, this will be returned on aColor. If there is not color info on the format, it will remain unchanged. |
ignorePrintErrors | Boolean | If true, the string for an error like #DIV/0 will always by #DIV/0 instead of using the value of PrintErrors. Set it to true when the value is not for printing it. |
Returns
A rich string with the cell value.