The Math Forum

Search All of the Math Forum:

Views expressed in these public forums are not endorsed by NCTM or The Math Forum.

Math Forum » Discussions » Software » comp.soft-sys.matlab

Notice: We are no longer accepting new posts, but the forums will continue to be readable.

Topic: COM: Get "type" of Excel workbook object
Replies: 1   Last Post: May 20, 2013 4:38 PM

Advanced Search

Back to Topic List Back to Topic List Jump to Tree View Jump to Tree View   Messages: [ Previous | Next ]

Posts: 517
Registered: 2/23/10
COM: Get "type" of Excel workbook object
Posted: May 9, 2013 2:01 PM
  Click to see the message monospaced in plain text Plain Text   Click to reply to this topic Reply

The expression get(sh1,'type') returns xlWorksheet for a worksheet
object. However, there is no such type attribute for a workbook
object. What is the most reliable way to test for a workbook object,
ideally independent of Windows version and whether the host system is
32-bit or 64-bit. For that matter, it would be even more ideal if the
test method was independent of whether Matlab and Excel was 32-bit or
64-bit. I'm not sure if Excel actually comes in both bit-widths, but
the guiding idea is to write portable code that doesn't die just
because I forget to bring my laptop and end up using a colleague's

Point your RSS reader here for a feed of the latest messages in this topic.

[Privacy Policy] [Terms of Use]

© The Math Forum at NCTM 1994-2018. All Rights Reserved.