Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW
 
PerlMonks  

Re^2: ungrouping the Textboxes in excell sheets.

by scratchHead (Initiate)
on Mar 20, 2009 at 04:25 UTC ( #751934=note: print w/replies, xml ) Need Help??


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

hello Nkuvu, yeah $ws is the worksheet im refering,,, this works,. I just did what u adviced, but even i coudn't see the TextBoxes as u said(excel 2003 in using) (sorry i dont know much abt VB too). anyways thanks for the reply you have given,as im new to the idea given by i ll explore a lot on it.
  • Comment on Re^2: ungrouping the Textboxes in excell sheets.

Replies are listed 'Best First'.
Re^3: ungrouping the Textboxes in excell sheets.
by Nkuvu (Priest) on Mar 20, 2009 at 04:42 UTC

    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.

      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....
      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://751934]
help
Chatterbox?
[Corion]: usemodperl: Why don't you set up your own (http-only) CPAN mirror? Or just fatpack your scripts? I wonder what problem you're trying to solve here.
[usemodperl]: don't worry about that, it's really cool, i promise!
[Corion]: usemodperl: Well, if the world changes and makes your "wonderful" approach not work anymore, you can either change your approach, or change the world. You seem to want to change others instead.
[usemodperl]: no dude i'm just asking how to access meta via http and you are getting defensive for some reason (did you turn off http at meta? :-)
[choroba]: why do you need to access metacpan via http?
[usemodperl]: stop asking why, just say how
usemodperl pulls teeth...
[usemodperl]: change the world? you mean BREAK THE WEB? we will regret this once google starts pulling certs for cursing or something...
Veltro Sees open mouth and feeds troll
[Corion]: usemodperl: Naah, you're just being unreasonable. It's not hard to download https URLs, and we've shown you ways to avoid downloading at all, and ways to keep downloading via http possible. You reject both.

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (9)
As of 2018-06-24 16:33 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Should cpanminus be part of the standard Perl release?



    Results (126 votes). Check out past polls.

    Notices?