3 ms·
This is a little confusing, because there are now two types of Excel. One is the old desktop version that everybody is used to. That one has had support for arr
by onychomys 5y ago
This is a little confusing, because there are now two types of Excel. One is the old desktop version that everybody is used to. That one has had support for arrays and dictionaries and all sorts of other data structures for decades as part of VBA[0]. But with Office 365, Excel now exists as a web-based tool too, much like google docs or similar. That version doesn't allow VBA, and there's a separate JS-based system for running code on the data in those files.
[0] https://docs.microsoft.com/en-us/office/vba/Language/Reference/User-Interface-Help/dictionary-object https://docs.microsoft.com/en-us/office/vba/Language/Referen...