Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!newsfeed.fsmpi.rwth-aachen.de!news-1.dfn.de!news.dfn.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From: Neil Cerutti <neilc@norwich.edu>
Newsgroups: comp.lang.python
Subject: Re: unable to read combo boxes in excel by xlrd package in python
Date: 27 Sep 2013 15:04:22 GMT
Organization: Norwich University
Lines: 24
Message-ID: <ball3mFq38U1@mid.individual.net>
References: <6e38b68a-0fa7-47c4-8e36-308b5b89bbdd@googlegroups.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: individual.net kns56dmAo7OmQ82BjXxv1A66VVOXR1gSdR5U0Ala42ln9uDqtk
Cancel-Lock: sha1:S/+gPBgp98rEoul1LM9Oh61LNO4=
User-Agent: slrn/0.9.9p1/mm/ao (Win32)
Xref: csiph.com comp.lang.python:54889

On 2013-09-27, somesh g <someshg2@gmail.com> wrote:
> Hi..there
>
> I want to read the combo box in excel by using "xlrd" but in
> the output it is showing empty message, its not reading the
> combo box can u guys help me how to read the combo box in excel
> by "xlrd"
>
> code written like this
>
> workbook = xlrd.open_workbook('path of the file')
> worksheet = workbook.sheet_by_name('sheetname')
> TargetSystem = worksheet.cell_value(4, 2)

It depends on what kind of combo-box it is. The Excel-native
combo-box sucks (no auto-completion, no multi-select, etc.), and
so it's possible a Visual Basic widget was used instead. That
would leave the cell contents blank when read, as above.

You will need to retrieve the value from the combo-box object
directly somehow.

-- 
Neil Cerutti