ue_excel

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
declare=lex=ue_excel
lex=opensheet=myexcelfile.xlsx
lex=visible=0
lex=inplace
   
// Get:
// lex=get=sheet=row=col
 
for ll_loop = 1 to 20
  lex=get=1=ll_loop=2
  dw_1.item.columname:[ll_loop].value=<value>
next
   
// Set:
// set=get=sheet=row=col=value
 
for loop = 1 to 20
  lex=set=1=loop=3=<dw_1.item.columname:[loop].value>
next
 
// Close
 
lex=inplace
lex=quit
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
declare=lex=ue_excel
lex=opensheet=myexcelfile.xlsx
lex=visible=0
lex=inplace
lex=quit
destroy=lex

quit

quit the object

save

save excel-sheet

saveas

save as the excel-sheet

disconnect, destroy

destroy the object