Hi,
Others questions:
How i can union cells in excel?
range(A1:H1)?
Sample:
Before:
A B C D E F G H I
-----------------------------------
1 | | | | | | | | | |
-----------------------------------
After
A B C D E F G H I
-----------------------------------
1 | Title | |
-----------------------------------
It's no whorks...
ARGS := OLE2.CREATE_ARGLIST;
OLE2.ADD_ARG(ARGS, 1);
OLE2.ADD_ARG(ARGS, 1);
MyRange := OLE2.GET_OBJ_PROPERTY(MySheet, 'CELLS', ARGS);
OLE2.DESTROY_ARGLIST(ARGS);
ARGS := OLE2.CREATE_ARGLIST;
OLE2.ADD_ARG(ARGS, 1);
OLE2.ADD_ARG(ARGS, 9);
MyRange2 := OLE2.GET_OBJ_PROPERTY(MySheet, 'CELLS', ARGS);
OLE2.DESTROY_ARGLIST(ARGS);
OLE2.SET_PROPERTY(MySheet, 'UNION', MyRange,MyRange2);
Any idea?
Regards
Joneto