- Timestamp:
- 2019-06-22T10:44:47+12:00 (5 years ago)
- Location:
- main/trunk/model-sites-dev/heritage-nz/collect/pdf-reports
- Files:
-
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
main/trunk/model-sites-dev/heritage-nz/collect/pdf-reports/PREPARE-IMPORT.sh
r33188 r33192 5 5 6 6 echo "Generating sanitized CSV version of spreadsheet suitable for download through DL" 7 python prepare/xls-to-sanitized-csv.py "import/Archaeological report PDFs 20190620.xlsx" 7 python prepare/xls-to-sanitized-csv.py \ 8 "import/Archaeological report PDFs 20190620.xlsx" \ 9 "for-download/Archaeological-Reports-20190620.xlsx" 8 10 9 11 echo "Generating PDF-Bound and Unbound CSV files for use in import.pl" -
main/trunk/model-sites-dev/heritage-nz/collect/pdf-reports/prepare/xls-to-sanitized-csv.py
r33191 r33192 2 2 import csv 3 3 import os 4 import sys 4 5 5 6 import xlsutil 6 7 7 def excel_to_sanitized_csv(excel_filename ):8 def excel_to_sanitized_csv(excel_filename,sanitized_csv_filename): 8 9 workbook = xlrd.open_workbook(excel_filename) 9 10 … … 11 12 ## worksheet = workbook.sheet_by_name(xlsutil.worksheet_name) 12 13 13 excel_filename_split = os.path.split(excel_filename)14 excel_dirname = excel_filename_split[0]15 excel_file = excel_filename_split[1]16 excel_file_splitext = os.path.splitext(excel_file)17 excel_file_root = excel_file_splitext[0];14 # excel_filename_split = os.path.split(excel_filename) 15 # excel_dirname = excel_filename_split[0] 16 # excel_file = excel_filename_split[1] 17 # excel_file_splitext = os.path.splitext(excel_file) 18 # excel_file_root = excel_file_splitext[0]; 18 19 19 sanitized_csv_filename = os.path.join(excel_dirname,excel_file_root+".csv")20 # sanitized_csv_filename = os.path.join("for-download",excel_file_root+".csv") 20 21 21 22 sanitized_csv_ofile = open(sanitized_csv_filename, 'wb') … … 63 64 64 65 if __name__ == "__main__": 65 excel_to_sanitized_csv(os.sys.argv[1]) 66 if len(os.sys.argv) != 3: 67 print >> sys.stderr, "Usage: " + os.sys.argv[0] + "input.xsl|input.xslx output.csv" 68 exit(1) 66 69 70 excel_to_sanitized_csv(os.sys.argv[1],os.sys.argv[2]) 71
Note:
See TracChangeset
for help on using the changeset viewer.