git_diff_xlsx icon indicating copy to clipboard operation
git_diff_xlsx copied to clipboard

Enhanced display of non-ascii friendly content

Open kokhoon opened this issue 9 years ago • 0 comments

Thanks for this useful script, I made the following change to add some robustness in handling non-ascii friendly content that may appear in the Excel files, such as curly quotes.

line 61: output += unicodedata.normalize('NFKD', unicode(content)).encode('utf-8', 'ignore')

Sample output as follows:

 =================================
-Sheet: Sheet1[ 4 , 2 ]
+Sheet: Sheet1[ 5 , 5 ]
 =================================
     B3:
         Col1
     A4:
         Row1
     B4:
-        456.0
+        "456"
+    A5:
+        Row2
+    B5:
+        “test”
+    C5:
+        °C
+    D5:
+        ⛨
+    E5:
+        Ɛ

kokhoon avatar Nov 25 '16 04:11 kokhoon