summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorXavier Carcelle <xcarcelle@avencall.com>2012-07-04 17:58:29 +0200
committerXavier Carcelle <xcarcelle@avencall.com>2012-07-04 17:58:29 +0200
commit215304f1f19643b767d37caef32dd1d319c224af (patch)
tree60cd9c06ce38266cbe6d9db514f207c0b39abe8f
parentf45ae8c3b14c6f346eb4629e4e6b84291eb3bfaa (diff)
stock.py: Correct field skipping
-rw-r--r--stock.py7
1 files changed, 4 insertions, 3 deletions
diff --git a/stock.py b/stock.py
index 6d21473..d248fac 100644
--- a/stock.py
+++ b/stock.py
@@ -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)