Changeset 33224 for main/trunk/model-sites-dev/heritage-nz/collect/pdf-reports/prepare/xls-to-sanitized-csv.py

Timestamp:

2019-06-26T16:48:48+12:00 (5 years ago)

Author:

davidb

Message:

Further code tidy-up

File:

• main/trunk/model-sites-dev/heritage-nz/collect/pdf-reports/prepare/xls-to-sanitized-csv.py (modified) (2 diffs)

main/trunk/model-sites-dev/heritage-nz/collect/pdf-reports/prepare/xls-to-sanitized-csv.py

@@ -11 +11 @@
     worksheet = workbook.sheet_by_index(xlsutil.worksheet_index_pos)
     ## worksheet = workbook.sheet_by_name(xlsutil.worksheet_name)
-
-    # excel_filename_split = os.path.split(excel_filename)
-    # excel_dirname = excel_filename_split[0]
-    # excel_file = excel_filename_split[1]
-    # excel_file_splitext = os.path.splitext(excel_file)
-    # excel_file_root = excel_file_splitext[0];
-
-    # sanitized_csv_filename  = os.path.join("for-download",excel_file_root+".csv")
 
     sanitized_csv_ofile = open(sanitized_csv_filename, 'wb')
@@ -49 +41 @@
                 header_col_j = header_names_mapping[header_name]
 
-#                cell_value = worksheet.cell_value(row_i,header_col_j)
-#
-#                cell_value_utf8 = unicode(cell_value).encode("utf-8")
-
                 cell_value_unicode = xlsutil.cell_value_tidy_unicode(worksheet,row_i,header_col_j)
-
                 cell_value_utf8 = cell_value_unicode.encode("utf-8")
-
-##                cell_value_utf8 = unicode(cell_value).encode("utf-8")
 
                 sanitized_utf8_row.append(cell_value_utf8)