Home » Developer & Programmer » Forms » How i can union cells in excel?
How i can union cells in excel? [message #302581] Tue, 26 February 2008 04:11 Go to next message
Joneto
Messages: 13
Registered: February 2008
Location: Portugal
Junior Member
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
Re: How i can union cells in excel? [message #302738 is a reply to message #302581] Tue, 26 February 2008 19:20 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Don't ask new questions on existing threads!

Are you writing a new spreadsheet or updating an existing one?

Why not do the sum in Oracle and then populate the field?

David
Previous Topic: uploading data from excel file thru OLE2
Next Topic: Activex OCX
Goto Forum:
  


Current Time: Fri Sep 27 10:25:29 CDT 2024