• Replies 15 replies
  • Subscribers 17 subscribers
  • Views 343 views
  • Users 0 members are here
Options
Related

Row read

Sgar Saha
 
Parents
  • [QUOTE=rhel;117585]Excel (*.xls) data can be read through .Net API, see the sample macro code:

    import 'GridControl'
    handle any
    endhandle
    using namespace 'Aveva.Pdms.Presentation'
    !netDataSource  = object NETDATASOURCE('Excel Data', 'C:\Temp\Source-Data.xls')
    !netGridControl = object NETGRIDCONTROL()
    !netGridControl.bindtodatasource(!netDataSource)

    -- Get all grid column header titles
    !gridColDatas = !netGridControl.getColumns()
    -- Get All Grid Row Datas
    !gridRowDatas = !netGridControl.getRows()

    -- Query column header titles
    q var !gridColDatas

    -- Loop through all row-column contents
    do !rowData values !gridRowDatas
       q var !rowData
    enddo


    Hey thanks! works fine. only to work in E3D use


    using namespace 'Aveva.Core.Presentation'
Reply
  • [QUOTE=rhel;117585]Excel (*.xls) data can be read through .Net API, see the sample macro code:

    import 'GridControl'
    handle any
    endhandle
    using namespace 'Aveva.Pdms.Presentation'
    !netDataSource  = object NETDATASOURCE('Excel Data', 'C:\Temp\Source-Data.xls')
    !netGridControl = object NETGRIDCONTROL()
    !netGridControl.bindtodatasource(!netDataSource)

    -- Get all grid column header titles
    !gridColDatas = !netGridControl.getColumns()
    -- Get All Grid Row Datas
    !gridRowDatas = !netGridControl.getRows()

    -- Query column header titles
    q var !gridColDatas

    -- Loop through all row-column contents
    do !rowData values !gridRowDatas
       q var !rowData
    enddo


    Hey thanks! works fine. only to work in E3D use


    using namespace 'Aveva.Core.Presentation'
Children
No Data