Re: unable to read combo boxes in excel by xlrd package in python

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:26:23 GMT
Organization	Norwich University
Lines	29
Message-ID	<balmcvF1518U1@mid.individual.net> (permalink)
References	<6e38b68a-0fa7-47c4-8e36-308b5b89bbdd@googlegroups.com> <ball3mFq38U1@mid.individual.net>
Mime-Version	1.0
Content-Type	text/plain; charset=us-ascii
Content-Transfer-Encoding	7bit
X-Trace	individual.net nzYWjr5gKhh+JcS/SCBMjAfKYBoZpp/cCVK3x85PoJhnkw3A77
Cancel-Lock	sha1:AyBuXSgREKDD0LSXfp+339iyePs=
User-Agent	slrn/0.9.9p1/mm/ao (Win32)
Xref	csiph.com comp.lang.python:54891

Show key headers only | View raw

On 2013-09-27, Neil Cerutti <neilc@norwich.edu> wrote:
> 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.

If it's an Active-X ListBox or ComboBox, there's probably be a
CellLink defined. This will be the cell you need to read with
xlrd to get the value.

-- 
Neil Cerutti

Back to comp.lang.python | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

unable to read combo boxes in excel by xlrd package in python somesh g <someshg2@gmail.com> - 2013-09-27 07:36 -0700
  Re: unable to read combo boxes in excel by xlrd package in python Neil Cerutti <neilc@norwich.edu> - 2013-09-27 15:04 +0000
    Re: unable to read combo boxes in excel by xlrd package in python Neil Cerutti <neilc@norwich.edu> - 2013-09-27 15:26 +0000

csiph-web