Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical
 
PerlMonks  

Re^3: ungrouping the Textboxes in excell sheets.

by Nkuvu (Priest)
on Mar 20, 2009 at 04:42 UTC ( #751935=note: print w/ replies, xml ) Need Help??


in reply to Re^2: ungrouping the Textboxes in excell sheets.
in thread ungrouping the Textboxes in excell sheets.

You might be able to just use the Ungroup function I referred to. For example, get the address of the cell you want, and do $ws->Range("A1")->Ungroup();

Note that the range is a normal Perl string, so you can easily iterate over a number of cells:

# Pardon the C-ish loop, it's late. for (my $row = 1; $row <= 10; $row++) { $ws->Range("A$row")->Ungroup(); } # or an alternate if you have an area: # (cell addresses off the top of my head) $ws->Range("A1:D46")->Ungroup();

Note that I haven't had to use this function myself, so I'm not 100% positive it's the function you need. But you should be able to do some quick tests -- and look at the help for the function to see what can unmerge cells.


Comment on Re^3: ungrouping the Textboxes in excell sheets.
Select or Download Code
Re^4: ungrouping the Textboxes in excell sheets.
by scratchHead (Initiate) on Mar 20, 2009 at 05:18 UTC
    hey Nkuvu, that worked, (actually the first 1 syntax error,u need to give in range..). thats a great help from from you bro, thanks a lot....
Re^4: ungrouping the Textboxes in excell sheets.
by scratchHead (Initiate) on Mar 20, 2009 at 05:21 UTC
    hey Nkuvu, that worked, (actually the first 1 syntax error,u need to give in range..). thats a great help from from you bro, thanks a lot....

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://751935]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (5)
As of 2015-07-07 04:24 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (87 votes), past polls