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