You can use VBA and the CC API to accomplish that. I use it in spreadsheets that create reports on branches, streams, baselines etc. Note: you want to do A LOT of error checking. No matter what goes wrong, Excel alway pops up the same generic error message. See example commands below.
Set ccObj = CreateObject("ClearCase.Application")
Set ctObj = CreateObject("ClearCase.ClearTool")
Set viewObj = ccObj.View(viewName)
Set vobObj = ccObj.VOB(vobTag)
If Err.Number <> 0 Then
MsgBox ("Cannot create a VOB Object for " & vobTag & ". " & vbCrLf & vbCrLf & Err.Description)
Exit Sub
End If
If Not vobObj.IsMounted Then
rCode = ctObj("mount " & vobTag)
If Err.Number <> 0 Then
MsgBox ("Cannot mount Vob " & vobTag & ". " & vbCrLf & vbCrLf & Err.Description)
Exit Sub
End If
End If
' Store all the branches in an array
branchArray = Split(ctObj("lstype -fmt ""%n\n"" -kind brtype -invob " & vobTag), vbCrLf)
If Err.Number <> 0 Then
MsgBox ("[GBR_020] Error with command: " & "cleartool lstype -fmt ""%n\n"" -kind brtype -invob " & vobTag & vbCrLf & vbCrLf & Err.Description)
Exit Sub
End If
Jozef