| 15 |
|
from collections import namedtuple |
| 16 |
|
from win32com import client as win32 |
| 17 |
|
|
| 18 |
< |
version = "1.0" |
| 18 |
> |
version = "2.0" |
| 19 |
|
|
| 20 |
|
class ExcelToDictIngestor: |
| 21 |
|
def __init__(self): |
| 42 |
|
@staticmethod |
| 43 |
|
def _normalize_multi(val,delimiter: str) -> list: |
| 44 |
|
raw = ExcelToDictIngestor._cel_to_string(val) |
| 45 |
< |
parts = [p.strip().upper() for p in raw.split(delimiter)] |
| 46 |
< |
uniq = sorted({p for p in parts if p}) |
| 47 |
< |
return uniq |
| 45 |
> |
parts = [p.strip().upper() for p in raw.split(delimiter) if p] |
| 46 |
> |
## These next two lines deduplicate the values in the multi value cells but i'm reconsidering this. If the original had dups, I want the dict to have dups. |
| 47 |
> |
#uniq = sorted({p for p in parts if p}) |
| 48 |
> |
#return uniq |
| 49 |
> |
return sorted(parts) |
| 50 |
|
|
| 51 |
|
def _ensure_app(self, visible: bool): |
| 52 |
|
if self._excel_app is None: |
