엑셀추출
- BitoB
define function !!OutputCe()
VAR !BANNER BANNER
Import 'PMLFileBrowser'
handle Any
endhandle
if ( Match ( !BANNER , 'AVEVA PDMS Design' ) GT 0 ) then
using namespace 'Aveva.Pdms.Presentation'
!Browser = object PMLFileBrowser('OPEN')
!Browser.Show( 'C:\' , '' , 'File Path' , False , 'All files (*.*)|*.*' , 1 )
handle Any
return
endhandle
else
using namespace 'Aveva.Core.Presentation'
!Browser = object PMLFileBrowser('OPEN')
!Browser.Show( 'C:\' , '' , 'File Path' , False , 'All files (*.*)|*.*' , 1 )
handle Any
return
endhandle
endif
!File = Object File( !Browser.File() )
FILE $!FILE OVER
OUTPUT CE
TERM
syscom |$!FILE &|
define function !!OutputList(!TYPE IS ARRAY)
ONERROR continue
VAR !BANNER BANNER
Import 'PMLFileBrowser'
handle Any
endhandle
if ( Match ( !BANNER , 'AVEVA PDMS Design' ) GT 0 ) then
using namespace 'Aveva.Pdms.Presentation'
!Browser = object PMLFileBrowser('OPEN')
!Browser.Show( 'C:\' , '' , 'File Path' , False , 'All files (*.*)|*.*' , 1 )
handle Any
return
endhandle
else
using namespace 'Aveva.Core.Presentation'
!Browser = object PMLFileBrowser('OPEN')
!Browser.Show( 'C:\' , '' , 'File Path' , False , 'All files (*.*)|*.*' , 1 )
handle Any
return
endhandle
endif
!File = Object File( !Browser.File() )
FILE $!FILE OVER
!ITEM = OBJECT ARRAY()
$* EQUI 와 STRU 가져오기
DO !A VALUES !TYPE
VAR !ITEM APPEND COLL ALL $!A FOR CE
ENDDO
DO !A INDEX !ITEM
OUTPUT NOUDA $!ITEM[$!A]
--OUTPUT OLDFORMAT NOUDA $!ITEM[$!A]
ENDDO
term
syscom |C:\TTEMP.txt &|