Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #54889

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

Show all headers | View raw

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

Back to comp.lang.python | Previous | Next — Previous in thread | Next 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