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
)
Public Function ExcelFill (
dataRange As CellRange,
descRange As CellRange,
containTitle As Boolean,
fillColumnIndexs As List(Of Integer),
Optional keys As List(Of String) = Nothing
) As String
public:
String^ ExcelFill(
CellRange^ dataRange,
CellRange^ descRange,
bool containTitle,
List<int>^ fillColumnIndexs,
List<String^>^ keys = nullptr
)
member ExcelFill :
dataRange : CellRange *
descRange : CellRange *
containTitle : bool *
fillColumnIndexs : List<int> *
?keys : List<string>
(* Defaults:
let _keys = defaultArg keys null
*)
-> string
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