Hi All,
I need to extend the MS Excel VBO action "Get worksheet as collection"to get only specific columns , which can be specified either as comma separated string or collection. Can you please assist me with the code stage for the same?
Regards
Copy the action "Get worksheet as Collection" action and make new one named "Get specific column as collection"
In code stage copy below code:
Dim ws as Object = GetWorksheet( _
handle, workbookname, worksheetname)
Dim r as Object
r = ws.ListObjects("myTable").ListColumns([Header Name]).Range
r.Select()
r.Copy()
Dim data As String = GetClipboardText()
worksheetCollection = ParseDelimSeparatedVariables( _
data, vbTab, Nothing, Use_Header)
Inputs in start stage of page would be:
Workbook name:
Worksheet Name:
Handle:
Header Name:
Use_Header:
Input for the code stage will be:
Workbook name:
Worksheet Name:
Header Name:
Handle:
Use_Header:
O/P will be ->
Worksheetcollection.