object ue_excel
Work with a excel-sheet in a ole-object
Property / Method |
Description |
---|---|
opensheet |
open a sheet |
load |
load a sheet and display the excel-sheet |
visible |
make excel-sheet visible/unvisible |
inplace |
set object-display inplace |
offsite |
set object-display to offsite |
get |
return a value from excel-sheet excel=get=sheet=row=col or <excel=get=sheet=row=col> or excel=get=<sheet-variable>=<row-variable>=<col-variable> return in Variable <value>
destroy=lex |
set |
set a value in excel-sheet excel=set=sheet=row=col=value |
close |
close excel-sheet
to close a excel-object: destroy=lex |
quit |
quit the object |
save |
save excel-sheet |
saveas |
save as the excel-sheet |
disconnect, destroy |
destroy the object |