[python-win32] RE: Python-win32 digest, Vol 1 #171 - 2 msgs

Thu, 4 Jul 2002 17:35:09 +0100

Subtle but:

wkb.Sheets(2).Select()                    # show me sheet 2

works for me. Notice the Select().

Rgds

Mark Ainsworth
Quality Manager
Sundance Multiprocessor Technology Ltd.
Chiltern House, Waterside, Chesham, Bucks HP5 1PS
Tel. +44 1494 793167 Fax. +44 1494 793168
MarkA@sundance.com http://www.sundance.com

 -----Original Message-----
From: 	python-win32-request@python.org
[mailto:python-win32-request@python.org] 
Sent:	04 July 2002 17:00
To:	python-win32@python.org
Subject:	Python-win32 digest, Vol 1 #171 - 2 msgs

Send Python-win32 mailing list submissions to
	python-win32@python.org

To subscribe or unsubscribe via the World Wide Web, visit
	http://mail.python.org/mailman/listinfo/python-win32
or, via email, send a message with subject or body 'help' to
	python-win32-request@python.org

You can reach the person managing the list at
	python-win32-admin@python.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Python-win32 digest..."

Today's Topics:

   1. RE: empty variants (Jorgensen, Jens)
   2. Showing/Selecting Excel sheets (Colin Campbell)

--__--__--

Message: 1
Subject: RE: [python-win32] empty variants
Date: Wed, 3 Jul 2002 13:17:26 -0400
From: "Jorgensen, Jens" <jjorgensen@Tallan.com>
To: "M Shah Din" <msdin@rpoptions.com>
Cc: <python-win32@python.org>

V2VsbCwgaXQgbWF5IG5vdCBiZSBlYXN5IHRvIGNoYW5nZSB0aGUgcHl0aG9uIHNpZGUuIEl0IHdv
dWxkIGJlIGVhc2llciB0byB3cml0ZSBhIHB5dGhvbiBleHRlbnNpb24gbW9kdWxlIGluIEMrKyB0
aGF0IGRvZXMgZXhhY3RseSB3aGF0IHlvdSBuZWVkIGFuZCB1c2UgdGhhdC4gVGhhdCdzIHRoZSBh
cHByb2FjaCBJIHdvdWxkIHByb2JhYmx5IHRha2UgYXQgdGhpcyBwb2ludC4NCg0KCS0tLS0tT3Jp
Z2luYWwgTWVzc2FnZS0tLS0tIA0KCUZyb206IE0gU2hhaCBEaW4gW21haWx0bzptc2RpbkBycG9w
dGlvbnMuY29tXSANCglTZW50OiBXZWQgNy8zLzIwMDIgMTA6MzEgQU0gDQoJVG86IEpvcmdlbnNl
biwgSmVucyANCglDYzogcHl0aG9uLXdpbjMyQHB5dGhvbi5vcmcgDQoJU3ViamVjdDogUkU6IFtw
eXRob24td2luMzJdIGVtcHR5IHZhcmlhbnRzDQoJDQoJDQoNCglIaSBKZW5zLA0KCQ0KCVVuZm9y
dHVuYXRlbHksIEkgY2Fubm90IGNoYW5nZSB0aGUgY29kZS4gIEl0cyBhbm90aGVyIHBhcnR5J3Mg
Q09NDQoJb2JqZWN0LCBhbmQgSSBoYXZlIHRvIHVzZSBpdC4gDQoJDQoJVGhhbmtzLA0KCVNoYWgN
CgkNCgkNCglPbiBXZWQsIDIwMDItMDctMDMgYXQgMDc6MjcsIEpvcmdlbnNlbiwgSmVucyB3cm90
ZToNCgk+IFNoYWgsDQoJPiANCgk+IEknbSBub3QgZmFtaWxpYXIgd2l0aCB0aGUgYWN0dWFsIGNv
ZGUgYnV0IEkgY2FuIGVhc2lseSBzZWUgaG93IHRoaXMNCgk+IHdvdWxkIGhhcHBlbiBzaW5jZSBh
IEJ5UmVmIGFyZ3VtZW50IHdpbGwgcGFzcyBhIHBvaW50ZXIgdG8gYSBWQVJJQU5UDQoJPiBzbyBQ
eXRob24gd291bGQganVzdCBpbnRlcnByZXQgcGFzc2luZyBOb25lIGFzIHBhc3Npbmcgbm8gcG9p
bnRlci4NCgk+IElzIGl0IG5lY2Vzc2FyeSB0aGF0IHRoZSBmdW5jdGlvbiB0YWtlIHRoZSBWQVJJ
QU5UIEJ5UmVmPyBDb3VsZCBpdA0KCT4gaW5zdGVhZCB0YWtlIGl0IEJ5VmFsIGFuZCB0aGVuIHJl
dHVybiB0aGUgdmFyaWFudD8gSWYgeW91IGRpZCBpdCB0aGlzDQoJPiB3YXkgaXQgc2hvdWxkIHdv
cmsgaWYgeW91IHBhc3MgTm9uZS4NCgk+DQoJPiAgICAgICAtLS0tLU9yaWdpbmFsIE1lc3NhZ2Ut
LS0tLQ0KCT4gICAgICAgRnJvbTogTSBTaGFoIERpbiBbbWFpbHRvOm1zZGluQHJwb3B0aW9ucy5j
b21dDQoJPiAgICAgICBTZW50OiBUdWUgNy8yLzIwMDIgNjozOSBQTQ0KCT4gICAgICAgVG86IHB5
dGhvbi13aW4zMkBweXRob24ub3JnDQoJPiAgICAgICBDYzoNCgk+ICAgICAgIFN1YmplY3Q6IFtw
eXRob24td2luMzJdIGVtcHR5IHZhcmlhbnRzDQoJPiAgICAgIA0KCT4gICAgICANCgk+DQoJPiAg
ICAgICBIaSwNCgk+ICAgICAgDQoJPiAgICAgICBJIG5lZWQgdG8gcGFzcyBhbiBlbXB0eSB2YXJp
YW50IHRvIGEgQ09NIG9iamVjdHMgbWV0aG9kIGJ1dCBJIGNhbid0DQoJPiAgICAgICBmaWd1cmUg
b3V0IGhvdyB0byBkbyBpdC4gIEkgYXNrZWQgdGhlIHNhbWUgcXVlc3Rpb24gYSB3aGlsZSBhZ28s
IGJ1dCB0aGUNCgk+ICAgICAgIHByb3Bvc2VkIHNvbHV0aW9uIGRpZCBub3Qgd29yay4gIEkgaGF2
ZSBzb21lIG1vcmUgZGV0YWlscyBub3cuLi4NCgk+ICAgICAgDQoJPiAgICAgICBUaGUgQ09NIG9i
amVjdCBoYXMgYSBtZXRob2QgdGhhdCBsb29rcyBsaWtlIHRoaXM6DQoJPiAgICAgIA0KCT4gICAg
ICAgLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tDQoJPiAgICAgIA0KCT4gICAgICAgUHVibGljIFN1YiBGb28oQnlSZWYgbXlW
YXJpYW50IGFzIFZhcmlhbnQsIEJ5UmVmIHBhcmFtMSBhcyBTdHJpbmcpDQoJPiAgICAgIA0KCT4g
ICAgICAgICAgICAgICBEaW0gbXlfZmxhZyBhcyBCb29sZWFuDQoJPiAgICAgIA0KCT4gICAgICAg
ICAgICAgICBJZiBJc0VtcHR5KG15VmFyaWFudCkgVGhlbg0KCT4gICAgICAgICAgICAgICAgICAg
ICAgIG15X2ZsYWcgPSBUcnVlDQoJPiAgICAgICAgICAgICAgIEVsc2UNCgk+ICAgICAgICAgICAg
ICAgICAgIElmIG15VmFyaWFudCBJcyBOb3RoaW5nIFRoZW4NCgk+ICAgICAgICAgICAgICAgICAg
ICAgICBteV9mbGFnID0gVHJ1ZQ0KCT4gICAgICAgICAgICAgICAgICAgRWxzZQ0KCT4gICAgICAg
ICAgICAgICAgICAgICAgIG15X2ZsYWcgPSBGYWxzZQ0KCT4gICAgICAgICAgICAgICAgICAgRW5k
IElmDQoJPiAgICAgICAgICAgICAgIEVuZCBJZg0KCT4gICAgICANCgk+ICAgICAgICAgICAgICAg
SWYgbXlfZmxhZyA9IFRydWUgVGhlbg0KCT4gICAgICAgICAgICAgICAgICAgICAgIFNldCBteVZh
cmlhbnQgPSBDcmVhdGVPYmplY3QoInNvbWVfb2JqZWN0IikNCgk+ICAgICAgICAgICAgICAgRW5k
IElmDQoJPiAgICAgIA0KCT4gICAgICAgICAgICAgICBteVZhcmlhbnQuU29tZU1ldGhvZCgpDQoJ
PiAgICAgIA0KCT4gICAgICAgRW5kIFN1Yg0KCT4gICAgICANCgk+ICAgICAgIC0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0K
CT4gICAgICANCgk+ICAgICAgIFdoZW4gSSBjYWxsIGl0IGZyb20gcHl0aG9uLCB0aGUgbXlfZmxh
ZyB2YXJpYWJsZSBpcyBuZXZlciBUcnVlLiAgSWYgSQ0KCT4gICAgICAgcGFzcyBpbiBOb25lIGZv
ciBteVZhcmlhbnQsIHRoZSBWQiBkZWJ1Z2dlciBzaG93cyBpdCBhcyBiZWluZyBOdWxsLiAgSWYN
Cgk+ICAgICAgIEkgcGFzcyBpbiBweXRob25jb20uRW1wdHksIHRoZSBWQiBkZWJ1Z2dlciBzaG93
cyBpdCBhcyBiZWluZyBNaXNzaW5nLg0KCT4gICAgICAgSXQgd29ya3MgZmluZSBpZiBJIGNhbGwg
aXQgZnJvbSBhIFZCIG1ldGhvZCBhbmQganVzdCBkaW0gdGhlIHZhcmlhbnQNCgk+ICAgICAgIHdp
dGhvdXQgc2V0dGluZyBpdCB0byBhbnl0aGluZy4gIEhvdyBjYW4gSSBwYXNzIGFuIGVtcHR5IG9y
IG5vdGhpbmcNCgk+ICAgICAgIHZhcmlhbnQgZnJvbSBweXRob24/DQoJPiAgICAgIA0KCT4gICAg
ICAgSSBhbSB1c2luZyBBY3RpdmVTdGF0ZSBBY3RpdmVQeXRob24gMi4yIG9uIFdpbjJrLg0KCT4g
ICAgICANCgk+ICAgICAgIFRoYW5rcywNCgk+ICAgICAgIFNoYWgNCgk+ICAgICAgDQoJPiAgICAg
IA0KCT4gICAgICANCgk+ICAgICAgDQoJPiAgICAgICBfX19fX19fX19fX19fX19fX19fX19fX19f
X19fX19fX19fX19fX19fX19fX19fXw0KCT4gICAgICAgUHl0aG9uLXdpbjMyIG1haWxpbmcgbGlz
dA0KCT4gICAgICAgUHl0aG9uLXdpbjMyQHB5dGhvbi5vcmcNCgk+ICAgICAgIGh0dHA6Ly9tYWls
LnB5dGhvbi5vcmcvbWFpbG1hbi9saXN0aW5mby9weXRob24td2luMzINCgk+ICAgICAgDQoJPg0K
CQ0KCQ0KCQ0KCQ0KCQ0KDQo=

--__--__--

Message: 2
Date: Wed, 03 Jul 2002 19:05:07 -0600
To: python-win32@python.org
From: Colin Campbell <ccampbell@ede.org>
Subject: [python-win32] Showing/Selecting Excel sheets

Hello all,

After bashing this around, trawling the docs and getting greyer by the 
minute, I'm turning to the repository of wisdom that is this group.

With luck, I've buttered you up to the point you can handle yet another 
iteration of the vanishing Excel worksheet question. I'm sure I've seen it 
answered a month or so ago; blessed if I can find it!

I'm trying to open a workbook in Excel, using ActiveState Python 2.2.1, 
Excel 2002, and Windows 2000. Eventually, when I teach myself enough 
win32com, my code will read sheet numbers from a file, create a new 
workbook, copy the selected sheets into it, and show the result to the 
user. What is happening at this point in my admittedly incremental 
development, is that Excel fires up and opens the proper workbook, shows me 
only the menu, tool and formula bars, and refuses to select anything other 
then the first sheet in the book. If there is some fairly newby-ish 
documentation I'm missing, I'd be glad of a reference. My code is below.

Many TIA

Colin

#=============================================
#Excel sheet Copier/Hider
# trying to hardwire test values

from win32com.client import Dispatch
xl = Dispatch( 'Excel.Application' )    # create instance of Excel
xl.Visible = True                       # force it to be visible
xlFile = "C:/Other/Prg/Finstmts.xls"    # workbook to open
wkb = xl.Workbooks.Open(xlFile)         # tell excel to open it (ok to here)
wkb.Sheets(2).Select                    # show me sheet 2
z = raw_input()                         # pause the script
wkb.Close()                             # tidy up
xl.Quit()                               # shut down the app
xl = None                               # call the destructor

#========================================

--
I believe that the first test of a truly great man is his humility. I do 
not mean by humility, doubt of his own powers. But really great men have a 
curious feeling that the greatness is not in them, but through them. And 
they see something divine in every other man and are endlessly, foolishly, 
incredibly merciful.
  -John Ruskin, author, art critic, and social reformer (1819-1900)

--__--__--

_______________________________________________
Python-win32 mailing list
Python-win32@python.org
http://mail.python.org/mailman/listinfo/python-win32

End of Python-win32 Digest