Microsoft brings custom data types to Excel

silversurfer

Level 85
Thread author
Verified
Honorary Member
Top Poster
Content Creator
Malware Hunter
Well-known
Aug 17, 2014
10,055
In a nutshell: Up until recently, Microsoft Excel users have only been able to enter text and numbers as data into cells. One of the announcements Microsoft made at its Ignite 2021 event this week is the addition of more types of information users can enter into Excel, on top of additions it has made in recent years.

Microsoft will soon open up a preview of a new JavaScript API for Excel that will let users make their own custom data types containing things like images, entities, arrays, or formatted number values. These can all be backed up by users' own custom data sources. Users will also be able to make custom functions that can use these data types as both inputs and outputs.

Microsoft published a blog post elaborating on the changes to Excel as well as other parts of Microsoft Office, and includes animated gifs showing Bloomberg using the new data types. The gifs show someone entering a graph into an Excel chart by entering what looks like a formula. Another shows them dragging locations from a world map into cells in a chart, incorporating them with formulas on that chart.
 

About us

  • MalwareTips is a community-driven platform providing the latest information and resources on malware and cyber threats. Our team of experienced professionals and passionate volunteers work to keep the internet safe and secure. We provide accurate, up-to-date information and strive to build a strong and supportive community dedicated to cybersecurity.

User Menu

Follow us

Follow us on Facebook or Twitter to know first about the latest cybersecurity incidents and malware threats.

Top