PML dataframe

Hi Experts,

I would like to read an excel file like dataframe in PML then,Know how many rows and Columns are existing the excel

Chnage the value of the column with x1.5 times and assign as Attribute in design

Parents
  •   Hi, you can use the netgridcontrol(). 

    Here a simple sample :

    define method .loadFromExcel()
    import 'PMLFileBrowser'
    Handle Any
    Endhandle
    using namespace 'Aveva.Pdms.Presentation'
    !browser = object PMLFileBrowser('OPEN')
    !browser.show('C:\','','Load Grid from Excel',true, 'Excel Documents|*.xls',1)
    !this.grid.clearGrid()
    !nds = object NetDataSource('Grid Control Example', !browser.file())
    !this.grid.BindToDataSource(!nds)
    endmethod

    Tell me if you need more, but idk your programmer level.

  • Im trying to read particular .xlsx  directly  which  will be always stored in below path 

    C:\Users\Desktop\macro\xlsx\lines.xlsx

    above syntax is opening the file browser. is there any syntax

    Thank you for the understanding

Reply Children
No Data