Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error when trying to parse date in format "yyyy. MM. dd.": "invalid formatting code: unsupported or unescaped characters" #835

Open
jerbob92 opened this issue Dec 11, 2024 · 5 comments

Comments

@jerbob92
Copy link

When trying to parse an XLSX sheet with the date format yyyy. MM. dd., the following error is returned:
invalid formatting code: unsupported or unescaped characters

Here is the sheet I'm trying to read: https://www.mnb.hu/Root/ExchangeRate/arfolyam.xlsx

I'm not really sure if yyyy. MM. dd. is an actual valid date format, but LibreOffice shows the dates fine. Could it be that the . only has special meaning following some formatting characters?

Copy link

Stale issue message

@jerbob92
Copy link
Author

Well that is one way to keep the issue count low...

@tealeg
Copy link
Owner

tealeg commented Feb 17, 2025

Ack. Sorry about that. I actually should turn that off. I've but had any time to work on this library lately, but it doesn't mean issues should be ignored.

@jerbob92
Copy link
Author

@tealeg thanks! I might fix this myself at some point, I have now made my own implementation of XLSXToSlice that has a custom implementation in case the format is yyyy. MM. dd..

@tealeg
Copy link
Owner

tealeg commented Feb 18, 2025

@jerbob92 I'd be happy to review a PR. Sometimes I"m a bit slow, as you see, but I try to get there eventually.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants