Repository navigation
Unable to extract currency from excel formatted cells #53
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 |'
Activity
afourney commentedon Dec 16, 2024
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.
Fix microsoft#53: Preserve Excel cell formatting (currency, percentag…
preetpatel26 commentedon Jul 14, 2025
Adam Fourney (@afourney) Gagan Bansal (@gagb) I have created PR #1325 for this issue
Fix: Extract currency symbols and number formats from Excel cells
fix: preserve currency number format when converting xlsx to markdown
Fix: Extract currency symbols and number formats from Excel cells
Fix: Extract currency symbols and number formats from Excel cells
fix: preserve currency formatting in XLSX conversion (fixes microsoft#53
fix: preserve currency formatting in XLSX conversion (microsoft#53)
aslamalkarywk7 commentedon Sep 18, 2026
Hi! I would like to take this on (it carries the open-for-contribution label). Plan: in XlsxConverter, overlay Excel number-format currency symbols onto values (pandas drops number_format), so currency-formatted cells render with their label, plus a regression test with an in-memory workbook. Thanks!
aslamalkarywk7 commentedon Sep 18, 2026
Opened PR #2538 with the fix (currency-symbol overlay from number_format + regression tests). All green locally; pre-existing env failures unchanged. Happy to adjust the approach if you prefer a different rendering.
Keep currency labels on currency-formatted xlsx cells