Reporting

[QUOTE=pdmsc028;105527]!pipes = !!collectallfor('PIPE',||,CE)

!array = object Array()

do !pipe values !pipes

!col[1] = !pipe.Name

!col[2] = !pipe.Type

!col[3] = !pipe.Pspec.Name

!col[4] =  !pipe.ref

!array.Append(!col)

enddo

!header[1] = 'Name'

!header[2] = 'Type'

!header[3] = 'Specification'

!header[4] = 'REE'



!title = 'My Table'

import 'GridControl'

handle (1000,0)

endhandle



using namespace 'Aveva.Pdms.Presentation'

!grid = object NETGRIDCONTROL()

!grid.bindToDataSource(object NETDATASOURCE(!title, !header, !col))

!filename = 'C:\temp\2.xls'

!grid.saveGridToExcel(!filename)



endmethod
[COLOR=#333333]!header[4] = 'REE' is [/COLOR]REF[/U][COLOR=#333333] not REE[/COLOR][COLOR=#ff0000][/COLOR]

[QUOTE=pdmsc028;105527]!pipes = !!collectallfor('PIPE',||,CE)

!array = object Array()

do !pipe values !pipes

!col[1] = !pipe.Name

!col[2] = !pipe.Type

!col[3] = !pipe.Pspec.Name

!col[4] =  !pipe.ref

!array.Append(!col)

enddo

!header[1] = 'Name'

!header[2] = 'Type'

!header[3] = 'Specification'

!header[4] = 'REE'



!title = 'My Table'

import 'GridControl'

handle (1000,0)

endhandle



using namespace 'Aveva.Pdms.Presentation'

!grid = object NETGRIDCONTROL()

!grid.bindToDataSource(object NETDATASOURCE(!title, !header, !col))

!filename = 'C:\temp\2.xls'

!grid.saveGridToExcel(!filename)



endmethod
[COLOR=#333333]!header[4] = 'REE' is [/COLOR]REF[/U][COLOR=#333333] not REE[/COLOR][COLOR=#ff0000][/COLOR]