Drexel dragonThe Math ForumDonate to the Math Forum



Search All of the Math Forum:

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


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

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 ]
Paul

Posts: 263
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
laptop.



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

[Privacy Policy] [Terms of Use]

© Drexel University 1994-2014. All Rights Reserved.
The Math Forum is a research and educational enterprise of the Drexel University School of Education.