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

Timestamp:

2019-06-26T15:52:27+12:00 (5 years ago)

Author:

davidb

Message:

More careful working with unicode/utf8

File:

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

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

@@ -49 +49 @@
                 header_col_j = header_names_mapping[header_name]
 
-                cell_value = worksheet.cell_value(row_i,header_col_j)
+#                cell_value = worksheet.cell_value(row_i,header_col_j)
+#
+#                cell_value_utf8 = unicode(cell_value).encode("utf-8")
 
-                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)