`ExcelImporter` should convert integer codes to strings

[danielPclos]

`ExcelImporter` should convert integer codes to strings

[cmutel]

The ExcelImporter is incorrectly reading the code value as an integer:

>>> import bw2io as bi
>>> excel = bi.ExcelImporter("lci_bw_minim.xlsx")
>>> excel.apply_strategies()
>>> excel.data[0]['code']
41000000
>>> type(excel.data[0]['code'])
int

I don't know how this breaks stuff, but it is definitely the problem. Luckily it is easy to fix:

def codes_as_strings(data):
    for ds in data:
        ds['code'] = str(ds['code'])
    return data

excel.apply_strategy(codes_as_strings)

BTW, to import the sample database I had to relabel the "product" column:

def relabel_products(data):
    for ds in data:
        for exc in ds['exchanges']:
            exc['reference product'] = exc['product']
    return data

excel.apply_strategy(relabel_products)

I can then do LCA calculations and get LCIA scores.

[danielPclos]

Dear Christopher,

Thank you so much for your quick response.
Your solution works fine! 🙂

Kind regards,
Daniel

[danielPclos]

Hi again,

Just a small edit to the answer. To make it work on my side I needed to send the code_as_strings as a list since apply_strategies expects such argument type:

excel.apply_strategy([codes_as_strings])

[cmutel]

@danielPclos apply_strategy takes a single function, apply_strategies takes a list of functions. In you last comment you used both terms :)

[danielPclos]

Thanks @cmutel, I'm a bit blind so now I understand why was I getting inconsistent behavior due to interchange of these 2 methods. :)