microsoft / microsoft/markitdown
Unable to extract currency from excel formatted cells
Nobody has claimed this yet.
- Dominant language
- Python
- Stars
- 186k
- Forks
- 13.7k
- Avg merge
- 1d 4h
- Merged PRs (30d)
- 49
Description
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 |'
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reproducing the conversion with currency_label_invoice.xlsx and currency_label_invoice_2.xlsx, then locate the Excel conversion entry point that handles formatted cells. The work is done when currency labels from formatted cells appear in the Markdown output and the behavior is covered by a regression test.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- python
- Domain
- data
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Active
- Clarity
- Mostly clear
- Newbie friendliness
- 55/100