TableElementToExcel Method |
Copies the values to Excel. The target can be an address, a worksheet or a range.
Namespace: SeleniumAssembly: Selenium (in Selenium.dll) Version: 2.0.9.0 (2.0.9.0)
SyntaxDim instance As TableElement
Dim target As Object
Dim clear As Boolean
Dim firstRowsToSkip As Integer
Dim lastRowsToSkip As Integer
Dim map As String
instance.ToExcel(target, clear, firstRowsToSkip,
lastRowsToSkip, map)
Parameters
- target (Optional)
- Type: SystemObject
Optional - Excel address, worksheet or range. New sheet if null - clear (Optional)
- Type: SystemBoolean
Optional - If true, the cells will be cleared first - firstRowsToSkip (Optional)
- Type: SystemInt32
First row(s) to skip. Ex : 2 will skip the first two rows - lastRowsToSkip (Optional)
- Type: SystemInt32
Last row(s) to skip. Ex : 2 will skip the last two rows - map (Optional)
- Type: SystemString
Optional - Javascript code to scrap each cell. Default: (e)=>e.textContent.trim()
Examples
Dim lst As New List
lst.Add 43
lst.ToExcel [Sheet1!A1]
See Also