total pipe length

.csv it will generate not .xls or .xlsx

if you want excel file use grid function, don't know you are using E3D or PDMS.

!pipes = !!collectallfor(|PIPE|,||,!!ce)
!output = array()
do !pipe values !pipes
!len = 0
!branches = !!collectallfor(|BRAN|,||,!pipe)
do !bran values !branches
!len = !len + !bran.cllen
enddo
!output.append(!pipe.name & | Length: | & !len )
enddo
!file = object file(|%PDMSUSER%\length.csv|)
!file.writefile(|OVERWRITE|,!output)
!file.close()
syscom 'start excel.exe $!file&'

.csv it will generate not .xls or .xlsx

if you want excel file use grid function, don't know you are using E3D or PDMS.

!pipes = !!collectallfor(|PIPE|,||,!!ce)
!output = array()
do !pipe values !pipes
!len = 0
!branches = !!collectallfor(|BRAN|,||,!pipe)
do !bran values !branches
!len = !len + !bran.cllen
enddo
!output.append(!pipe.name & | Length: | & !len )
enddo
!file = object file(|%PDMSUSER%\length.csv|)
!file.writefile(|OVERWRITE|,!output)
!file.close()
syscom 'start excel.exe $!file&'