diff options
author | Xavier Carcelle <xcarcelle@avencall.com> | 2012-07-04 17:58:29 +0200 |
---|---|---|
committer | Xavier Carcelle <xcarcelle@avencall.com> | 2012-07-04 17:58:29 +0200 |
commit | 215304f1f19643b767d37caef32dd1d319c224af (patch) | |
tree | 60cd9c06ce38266cbe6d9db514f207c0b39abe8f | |
parent | f45ae8c3b14c6f346eb4629e4e6b84291eb3bfaa (diff) |
stock.py: Correct field skipping
-rw-r--r-- | stock.py | 7 |
1 files changed, 4 insertions, 3 deletions
@@ -3,12 +3,12 @@ import ezodf import pickle from collections import OrderedDict -def parse_file(f, sheet, keyno, fields): +def parse_file(f, sheet, keyno, fields, skip_first=1, skip_last=0): l = [] try: # Read EagleDbDict or create it if not present ods = ezodf.opendoc(f) sheet = ods.sheets[sheet] - for index in range(1, sheet.nrows()): + for index in range(skip_first, sheet.nrows()-skip_last): new = [sheet[index, keyno].value] new.extend(sheet[index, i].value for i in fields) l.append(new) @@ -20,7 +20,8 @@ def parse_file(f, sheet, keyno, fields): #Get Avencall stock Stock = parse_file('../AvenCallHardwareStock.ods', 'Work', 0, (2,4)) -Quote = parse_file('/home/massoud/Projets/XiVO/Software/proto_pcbs/pcb_xioh/Ver5/EgV6-XIOHV5/BoM/Commandes/Digikey/XIOHv5-Digikey-Order-quote7081688.ods','dk', 0, (3,)) +Quote = parse_file('/home/massoud/Projets/XiVO/Software/proto_pcbs/pcb_xioh/Ver5/EgV6-XIOHV5/BoM/Commandes/Digikey/XIOHv5-Digikey-Order-quote7081688.ods', + 'dk', 0, (3,), skip_first=0, skip_last=2) EagleBom = parse_file('../EagleBom.ods','BomProcess', 0, (6,)) #disp_struct(Stock) |