diff options
| -rw-r--r-- | python/read_excel.py | 31 |
1 files changed, 0 insertions, 31 deletions
diff --git a/python/read_excel.py b/python/read_excel.py deleted file mode 100644 index ce2f5c43..00000000 --- a/python/read_excel.py +++ /dev/null @@ -1,31 +0,0 @@ -import os
-from xlrd import open_workbook
-import csv
-
-rootdir = "/home/share/rmbs/data/finra/"
-
-
-# dir_list = os.listdir(rootdir)
-dir_list = [d for d in dir_list if "zip" not in d]
-
-for d in dir_list:
- file_list = os.listdir(os.path.join(rootdir, d))
- for f in file_list:
- if os.path.splitext(f)[1] == ".xls":
- wb = open_workbook(os.path.join(rootdir, d, f))
- with open( os.path.join(rootdir, d, os.path.splitext(f)[0] + ".csv"), "w") as fh:
- wbcsv = csv.writer(fh, dialect = csv.excel)
- if "PXTABLES" in f:
- s = wb.sheets()[3]
- else:
- s = wb.sheets()[0]
- for row in range(s.nrows):
- this_row = []
- for col in range(s.ncols):
- val = s.cell_value(row, col)
- if isinstance(val, unicode):
- val = val.encode('utf8')
- if isinstance(val, float):
- val = str(val)
- this_row.append(val)
- wbcsv.writerow(this_row)
|