2 ms·
Microsoft opens up Excel to custom data types with images, arrays, and more
- onychomys 5y agoThis 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...