Hi experts,
Below are the syntax for reading .CSV file. Kindly let me know any syntax for the reading .xlsx file
import 'PMLFileBrowser'
Handle Any
Endhandle
using namespace 'Aveva.Pdms.Presentation'
!filePath = 'C:\Users\shadab.hussainc\Desktop\Project\Loads\Operating' + '.csv'
!file = object FILE(!filePath)
!records = !file.readfile()
handle any
return
endhandle
!recor = !records.SIZE()
!sgdzx = !recor
DO !X FROM 1 TO !sgdzx
!pinna = |$!records[$!X]|
!pina = |$!pinna|
Thanks in advance
Shadab Hussain Chiya
