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
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
Sri 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
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