Skip to content

Unable to extract currency from excel formatted cells #53

@samiashi

Description

@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:
Image

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't workingopen for contributionInvites open-source developers to contribute to the project.

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions