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)
Syntax Dim 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