Fix for when RangeUsed() in worksheet returns null.

microsoft / kernel-memory

RAG architecture: index and query any data using LLM and natural language, track sources, show citations, asynchronous memory patterns.

https://microsoft.github.io/kernel-memory

MIT License

1.52k stars 293 forks source link

Fix for when RangeUsed() in worksheet returns null. #468

Closed jurepurgar closed 4 months ago

jurepurgar commented 4 months ago

Motivation and Context (Why the change? What's the scenario?)

I have an excel document that has a special worksheet which is not even visible in Excel. I don't know the specifics behind this, but RangeUsed() returns null for this worksheet. This PR addresses this by skipping the worksheets for which RangeUsed() returns null.

High level description (Approach, Design)

Fix for a special kind of Excel document.

dluc commented 4 months ago

Thanks!