100 Mo limitation ? - Githubissues

microsoft / python-in-excel

Python in Microsoft Excel

MIT License

490 stars 31 forks source link

100 Mo limitation ? #19

Open stonebig opened 10 months ago

stonebig commented 10 months ago

I'm reading on the nice Minda treacy Cheatsheet that there is currently a limitation on Dataset to 100MB https://twitter.com/KirkDBorne/status/1696723401514369341

Question:

is it indeed the case ? is it 100Mo of compressed data ?
What could be done to make it less impacting / or a less small limit ?

It would be nice to feel only constrained by what can sanely fit in a WASM32.

keyur32 commented 10 months ago

Hi, yes, we have a limit of 100 MB of data that the built-in xl() function is able to reference either through the grid or through a PowerQuery connection. You can split this up into smaller chunks to workaround or use PowerQuery to summarize the data before loading in Excel.