Unable to extract currency from excel formatted cells

[samiashi]

When I have an excel file with some cells formatted with currency, the conversion does not include the currency label. It only seems to extract the value.

For example an excel file with the following:

Returns:
'## Sheet1\n| Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 |\n| --- | --- | --- | --- | --- |\n| Item | Count | Cost | Weight | Total |\n| Breakfast | 20 | 5 | NaN | 100 |\n| Laptops | 5 | 1199 | NaN | 5995 |\n| Car tires | 8 | 199 | 150 kg | 1592 |\n| NaN | NaN | NaN | NaN | 7687 |'

currency_label_invoice.xlsx
currency_label_invoice_2.xlsx

[afourney]

Hmm, good catch. The type and formatting info are in the cell metadata which might not be considered when we load the table via pandas. I'll see if there's an alternative approach.