> I would like to use multiple command line arguments in my script. If
> one or all of them are found, the script will produce an output for
> them (from excel sheet). Please see the code below. Basically the
> problem is here:

>     if sh.cell(i, 1).value == sys.argv[1]:

> and I would like to use

>     if sh.cell(i, 1).value == sys.argv[1:]:

> so the operator "==" is wrong. I would like to use

> > python Read_xls_files.py group1 group2 group3

> and if one or two or all of these are found in the excel file, certain
> cells are printed (see the code below)

> Many thanks.
> _johannes_

> ######################## python code #####################
> #!/Python26/
> # -*- coding: utf-8 -*-

> import sys
> import xlrd

> #------------ functions ------------------
> def uniq(inlist):
>     # order preserving
>     uniques = []
>     for item in inlist:
>         if item not in uniques:
>             uniques.append(item)
>     return uniques

> #----------- commandlinearguments ------
> if len(sys.argv) < 2:
>         print 'Usage: python Read_xls_files.py <groupst>'
>         sys.exit()

> #----------- input ----------------
> wb = xlrd.open_workbook('testiexcel.xls')

> #----------- main -----------------------
> #Get the first sheet either by name
> sh = wb.sheet_by_name(u'data')

> hlo = []
> for i in range(len(sh.col_values(8))):
>     if sh.cell(i, 1).value == sys.argv[1]:
>         hlo.append(sh.cell(i, 8).value)

> sposti = uniq(hlo)

> for i in range(len(sposti)):
>     print sposti[i] + ';'

> johannes rara wrote:
>> I would like to use multiple command line arguments in my script.

> ...then I suggest you have a look at argparse:

> http://code.google.com/p/argparse/

>> for i in range(len(sh.col_values(8))):
>>     if sh.cell(i, 1).value == sys.argv[1]:

> The above would then likely become:

> if sh.cell(i, 1).value in options.special_values

> cheers,

> Chris

> --
> Simplistix - Content Management, Batch Processing & Python Consulting
>            - http://www.simplistix.co.uk

> for grp in sys.argv[1:]:
>   for i in range(len(sh.col_values(8))):
>    if sh.cell(i, 1).value == grp:
>       hlo.append(sh.cell(i, 8).value)

>> http://code.google.com/p/argparse/

>>> for i in range(len(sh.col_values(8))):
>>>     if sh.cell(i, 1).value == sys.argv[1]:
>> The above would then likely become:

>> if sh.cell(i, 1).value in options.special_values

> On 30/10/2009 5:50 PM, johannes rara wrote:
>> Thanks, I'll have to check that. I found also this:

>> for grp in sys.argv[1:]:
>>   for i in range(len(sh.col_values(8))):
>>    if sh.cell(i, 1).value == grp:
>>       hlo.append(sh.cell(i, 8).value)

> Extremely inefficient.

>> 2009/10/30 Chris Withers <ch...@simplistix.co.uk>:
>>> johannes rara wrote:
>>>> I would like to use multiple command line arguments in my script.
>>> ...then I suggest you have a look at argparse:

>>> http://code.google.com/p/argparse/

>>>> for i in range(len(sh.col_values(8))):
>>>>     if sh.cell(i, 1).value == sys.argv[1]:
>>> The above would then likely become:

>>> if sh.cell(i, 1).value in options.special_values

> Ummmm ... why not
>     if sh.cell(i, 1).value in sys.argv[1:]:
> ?

> Better: at start-up, do:
>     argset = set(sys.argv[1:])
> then each iteration do:
>     if sh.cell(i, 1).value in argset:

> For alliteration aficionados and fans of Sesame Street, today's letter
> is "b". The for statement is bordering on being a bit bloated, baroque
> and byzantine; try:
>     for i in xrange(sh.nrows):

> HTH,
> John

> 2009/10/30 John Machin <sjmac...@lexicon.net>:
>> On 30/10/2009 5:50 PM, johannes rara wrote:
>>> Thanks, I'll have to check that. I found also this:

>>> for grp in sys.argv[1:]:
>>>   for i in range(len(sh.col_values(8))):
>>>    if sh.cell(i, 1).value == grp:
>>>       hlo.append(sh.cell(i, 8).value)