• Replies 29 replies
  • Subscribers 1 subscriber
  • Views 126 views
  • Users 0 members are here
Options
Related

Reporting

Shrivallabha Sharad Redij
 
Parents
  • !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)
Reply
  • !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)
Children
No Data