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.

Sign up for GitHub

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

Jump to bottom

ADO (Microsoft.ACE.OLEDB) Fails to read generated xlsx files with "System Resource Exceeded" error #25

Open
AlexVallat opened this issue Sep 20, 2023 · 1 comment
Open

ADO (Microsoft.ACE.OLEDB) Fails to read generated xlsx files with "System Resource Exceeded" error #25

AlexVallat opened this issue Sep 20, 2023 · 1 comment
Labels
documentation Improvements or additions to documentation

Comments

@AlexVallat
Copy link

Files generated by SpreadCheetah using the default settings cannot be read by the Microsoft Excel ADO OleDb provider. No idea why Microsoft would use different parsing for Excel and the ADO reader, but apparently they do.

Turning on the SpreadCheetahOptions.WriteCellReferenceAttributes option resolves this.

Maybe worth mentioning in the documentation?
@sveinungf
Copy link
Owner

Thank you for letting me know. I'll add some more documentation around the use of that option.

@sveinungf sveinungf added the documentation Improvements or additions to documentation label Jul 5, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
documentation Improvements or additions to documentation
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@AlexVallat @sveinungf