TXlsFile.SetCellValue Method
Overloads
- TXlsFile.SetCellValue(Integer, Integer, TCellValue, Integer)
- TXlsFile.SetCellValue(Integer, Integer, string, Integer)
- TXlsFile.SetCellValue(Integer, Integer, TRichString, Integer)
- TXlsFile.SetCellValue(Integer, Integer, TDateTime, Integer)
- TXlsFile.SetCellValue(Integer, Integer, Double, Integer)
- TXlsFile.SetCellValue(Integer, Integer, Single, Integer)
- TXlsFile.SetCellValue(Integer, Integer, Integer, Integer)
- TXlsFile.SetCellValue(Integer, Integer, Int64, Integer)
- TXlsFile.SetCellValue(Integer, Integer, Integer, TCellValue, Integer)
- TXlsFile.SetCellValue(Integer, Integer, Integer, string, Integer)
- TXlsFile.SetCellValue(Integer, Integer, Integer, Double, Integer)
- TXlsFile.SetCellValue(Integer, Integer, Integer, Integer, Integer)
TXlsFile.SetCellValue(Integer, Integer, TCellValue, Integer)
Sets the value and format on a cell.
Remarks
This method will enter the datatype of the object you pass to it. For example, if you set value="1" the string "1" will be entered on the cell. To convert a string to the best representation (on this case a number), use TExcelFile.SetCellFromString(Integer, Integer, TRichString, Integer) To enter a HTML formatted string, use TExcelFile.SetCellFromHtml(Integer, Integer, string, Integer)
Syntax
Unit: FlexCel.XlsAdapter
procedure TXlsFile.SetCellValue(const row: Integer; const col: Integer; const value: TCellValue; const XF: Integer = -1); overload; override;
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
const | row | Integer | Row, 1 based. |
const | col | Integer | Column, 1 based. |
const | value | TCellValue | Value to set. |
const | XF | Integer | Optional: Default value is -1 Format to Set. You normally get this number with TExcelFile.AddFormat function. Use -1 (the default) to keep format unchanged. |
See also
TXlsFile.SetCellValue(Integer, Integer, string, Integer)
Sets the value on a cell to a string.
Remarks
This method will enter the datatype of the object you pass to it. For example, if you set value="1" the string "1" will be entered on the cell. To convert a string to the best representation (on this case a number), use TExcelFile.SetCellFromString(Integer, Integer, TRichString, Integer). To enter a HTML formatted string, use TExcelFile.SetCellFromHtml(Integer, Integer, string, Integer)
Syntax
Unit: FlexCel.XlsAdapter
procedure TXlsFile.SetCellValue(const row: Integer; const col: Integer; const value: string; const XF: Integer = -1); overload; override;
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
const | row | Integer | Row, 1 based. |
const | col | Integer | Column, 1 based. |
const | value | string | Value to set. |
const | XF | Integer | Optional: Default value is -1 Format to Set. You normally get this number with TExcelFile.AddFormat function. Use -1 (the default) to keep format unchanged. |
See also
TXlsFile.SetCellValue(Integer, Integer, TRichString, Integer)
Sets the value on a cell to a string.
Remarks
This method will enter the datatype of the object you pass to it. For example, if you set value="1" the string "1" will be entered on the cell. To convert a string to the best representation (on this case a number), use TExcelFile.SetCellFromString(Integer, Integer, TRichString, Integer). To enter a HTML formatted string, use TExcelFile.SetCellFromHtml(Integer, Integer, string, Integer)
Syntax
Unit: FlexCel.XlsAdapter
procedure TXlsFile.SetCellValue(const row: Integer; const col: Integer; const value: TRichString; const XF: Integer = -1); overload; override;
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
const | row | Integer | Row, 1 based. |
const | col | Integer | Column, 1 based. |
const | value | TRichString | Value to set. |
const | XF | Integer | Optional: Default value is -1 Format to Set. You normally get this number with TExcelFile.AddFormat function. Use -1 (the default) to keep format unchanged. |
See also
TXlsFile.SetCellValue(Integer, Integer, TDateTime, Integer)
Sets the value on a cell to a datetime.
Remarks
This method will enter the datatype of the object you pass to it. For example, if you set value="1" the string "1" will be entered on the cell. To convert a string to the best representation (on this case a number), use TExcelFile.SetCellFromString(Integer, Integer, TRichString, Integer). To enter a HTML formatted string, use TExcelFile.SetCellFromHtml(Integer, Integer, string, Integer)
Syntax
Unit: FlexCel.XlsAdapter
procedure TXlsFile.SetCellValue(const row: Integer; const col: Integer; const value: TDateTime; const XF: Integer = -1); overload; override;
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
const | row | Integer | Row, 1 based. |
const | col | Integer | Column, 1 based. |
const | value | TDateTime | Value to set. |
const | XF | Integer | Optional: Default value is -1 Format to Set. You normally get this number with TExcelFile.AddFormat function. Use -1 (the default) to keep format unchanged. |
See also
TXlsFile.SetCellValue(Integer, Integer, Double, Integer)
Sets the value on a cell to a number.
Remarks
This method will enter the datatype of the object you pass to it. For example, if you set value="1" the string "1" will be entered on the cell. To convert a string to the best representation (on this case a number), use TExcelFile.SetCellFromString(Integer, Integer, TRichString, Integer). To enter a HTML formatted string, use TExcelFile.SetCellFromHtml(Integer, Integer, string, Integer)
Syntax
Unit: FlexCel.XlsAdapter
procedure TXlsFile.SetCellValue(const row: Integer; const col: Integer; const value: Double; const XF: Integer = -1); overload; override;
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
const | row | Integer | Row, 1 based. |
const | col | Integer | Column, 1 based. |
const | value | Double | Value to set. |
const | XF | Integer | Optional: Default value is -1 Format to Set. You normally get this number with TExcelFile.AddFormat function. Use -1 (the default) to keep format unchanged. |
See also
TXlsFile.SetCellValue(Integer, Integer, Single, Integer)
Sets the value on a cell to a number.
Remarks
This method will enter the datatype of the object you pass to it. For example, if you set value="1" the string "1" will be entered on the cell. To convert a string to the best representation (on this case a number), use TExcelFile.SetCellFromString(Integer, Integer, TRichString, Integer). To enter a HTML formatted string, use TExcelFile.SetCellFromHtml(Integer, Integer, string, Integer)
Syntax
Unit: FlexCel.XlsAdapter
procedure TXlsFile.SetCellValue(const row: Integer; const col: Integer; const value: Single; const XF: Integer = -1); overload; override;
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
const | row | Integer | Row, 1 based. |
const | col | Integer | Column, 1 based. |
const | value | Single | Value to set. |
const | XF | Integer | Optional: Default value is -1 Format to Set. You normally get this number with TExcelFile.AddFormat function. Use -1 (the default) to keep format unchanged. |
See also
TXlsFile.SetCellValue(Integer, Integer, Integer, Integer)
Sets the value on a cell to a number.
Remarks
This method will enter the datatype of the object you pass to it. For example, if you set value="1" the string "1" will be entered on the cell. To convert a string to the best representation (on this case a number), use TExcelFile.SetCellFromString(Integer, Integer, TRichString, Integer). To enter a HTML formatted string, use TExcelFile.SetCellFromHtml(Integer, Integer, string, Integer)
Syntax
Unit: FlexCel.XlsAdapter
procedure TXlsFile.SetCellValue(const row: Integer; const col: Integer; const value: Integer; const XF: Integer = -1); overload; override;
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
const | row | Integer | Row, 1 based. |
const | col | Integer | Column, 1 based. |
const | value | Integer | Value to set. |
const | XF | Integer | Optional: Default value is -1 Format to Set. You normally get this number with TExcelFile.AddFormat function. Use -1 (the default) to keep format unchanged. |
See also
TXlsFile.SetCellValue(Integer, Integer, Int64, Integer)
Sets the value on a cell to a number.
Remarks
This method will enter the datatype of the object you pass to it. For example, if you set value="1" the string "1" will be entered on the cell. To convert a string to the best representation (on this case a number), use TExcelFile.SetCellFromString(Integer, Integer, TRichString, Integer). To enter a HTML formatted string, use TExcelFile.SetCellFromHtml(Integer, Integer, string, Integer)
Syntax
Unit: FlexCel.XlsAdapter
procedure TXlsFile.SetCellValue(const row: Integer; const col: Integer; const value: Int64; const XF: Integer = -1); overload; override;
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
const | row | Integer | Row, 1 based. |
const | col | Integer | Column, 1 based. |
const | value | Int64 | Value to set. |
const | XF | Integer | Optional: Default value is -1 Format to Set. You normally get this number with TExcelFile.AddFormat function. Use -1 (the default) to keep format unchanged. |
See also
TXlsFile.SetCellValue(Integer, Integer, Integer, TCellValue, Integer)
Sets the value on a cell.
Remarks
This method will enter the datatype of the object you pass to it. For example, if you set value="1" the string "1" will be entered on the cell. To convert a string to the best representation (on this case a number), use TExcelFile.SetCellFromString(Integer, Integer, TRichString, Integer). To enter a HTML formatted string, use TExcelFile.SetCellFromHtml(Integer, Integer, string, Integer)
Syntax
Unit: FlexCel.XlsAdapter
procedure TXlsFile.SetCellValue(const sheet: Integer; const row: Integer; const col: Integer; const value: TCellValue; const XF: Integer); overload; override;
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
const | sheet | Integer | Sheet number, 1 based |
const | row | Integer | Row, 1 based. |
const | col | Integer | Column, 1 based. |
const | value | TCellValue | Value to set. |
const | XF | Integer | Format to Set. You normally get this number with TExcelFile.AddFormat function. Use -1 to keep format unchanged. |
See also
TXlsFile.SetCellValue(Integer, Integer, Integer, string, Integer)
Sets the value on a cell.
Remarks
This method will enter the datatype of the object you pass to it. For example, if you set value="1" the string "1" will be entered on the cell. To convert a string to the best representation (on this case a number), use TExcelFile.SetCellFromString(Integer, Integer, TRichString, Integer). To enter a HTML formatted string, use TExcelFile.SetCellFromHtml(Integer, Integer, string, Integer)
Syntax
Unit: FlexCel.XlsAdapter
procedure TXlsFile.SetCellValue(const sheet: Integer; const row: Integer; const col: Integer; const value: string; const XF: Integer); overload; override;
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
const | sheet | Integer | Sheet number, 1 based |
const | row | Integer | Row, 1 based. |
const | col | Integer | Column, 1 based. |
const | value | string | Value to set. |
const | XF | Integer | Format to Set. You normally get this number with TExcelFile.AddFormat function. Use -1 to keep format unchanged. |
See also
TXlsFile.SetCellValue(Integer, Integer, Integer, Double, Integer)
Sets the value on a cell.
Remarks
This method will enter the datatype of the object you pass to it. For example, if you set value="1" the string "1" will be entered on the cell. To convert a string to the best representation (on this case a number), use TExcelFile.SetCellFromString(Integer, Integer, TRichString, Integer). To enter a HTML formatted string, use TExcelFile.SetCellFromHtml(Integer, Integer, string, Integer)
Syntax
Unit: FlexCel.XlsAdapter
procedure TXlsFile.SetCellValue(const sheet: Integer; const row: Integer; const col: Integer; const value: Double; const XF: Integer); overload; override;
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
const | sheet | Integer | Sheet number, 1 based |
const | row | Integer | Row, 1 based. |
const | col | Integer | Column, 1 based. |
const | value | Double | Value to set. |
const | XF | Integer | Format to Set. You normally get this number with TExcelFile.AddFormat function. Use -1 to keep format unchanged. |
See also
TXlsFile.SetCellValue(Integer, Integer, Integer, Integer, Integer)
Sets the value on a cell.
Remarks
This method will enter the datatype of the object you pass to it. For example, if you set value="1" the string "1" will be entered on the cell. To convert a string to the best representation (on this case a number), use TExcelFile.SetCellFromString(Integer, Integer, TRichString, Integer). To enter a HTML formatted string, use TExcelFile.SetCellFromHtml(Integer, Integer, string, Integer)
Syntax
Unit: FlexCel.XlsAdapter
procedure TXlsFile.SetCellValue(const sheet: Integer; const row: Integer; const col: Integer; const value: Integer; const XF: Integer); overload; override;
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
const | sheet | Integer | Sheet number, 1 based |
const | row | Integer | Row, 1 based. |
const | col | Integer | Column, 1 based. |
const | value | Integer | Value to set. |
const | XF | Integer | Format to Set. You normally get this number with TExcelFile.AddFormat function. Use -1 to keep format unchanged. |