Click or drag to resize

ExcelAI ExcelFill Method

Fills the Excel worksheet with data extracted from the specified data range, using the specified description range, column indexes, and keys.

Namespace: Spire.Xls.AI
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
public string ExcelFill(
	CellRange dataRange,
	CellRange descRange,
	bool containTitle,
	List<int> fillColumnIndexs,
	List<string> keys = null
)

Parameters

dataRange
Type: Spire.Xls CellRange
The range of cells containing the data to fill.
descRange
Type: Spire.Xls CellRange
The range of cells containing the description for each column.
containTitle
Type: System Boolean
A boolean value indicating whether the data range contains a title row.
fillColumnIndexs
Type: System.Collections.Generic List Int32
A list of column indexes in the data range to fill.
keys (Optional)
Type: System.Collections.Generic List String
An optional list of keys to extract specific information from the data. If null, the function will extract information based on the description range.

Return Value

Type: String
A string indicating the status of the operation.
Exceptions
Exception Condition
ApiException Thrown when any of the parameters is null or invalid.
See Also