Excel - How To Use Your Company Data In A Data Type In Excel Using The API - Episode 2451

Microsoft Excel Tutorial: How to create your own custom data types in Excel using ScriptLab and the Javascript API.

Github for the example using a Custom Function:

Welcome back to the MrExcel Podcast! In this episode (number 2451), Bill Jelen takes us on the third leg of the quest for the perfect custom data type in Excel. Data Types are incredible, but what if you want YOUR data, not just Wolfram or Wikipedia data? Bill shows us how to achieve this using the JavaScript API.

🔍 Key Highlights:
Bill's goal: Type plain text into a cell and convert it to a custom data type.
Accessing the same gallery as other data types and returning an array of entities.
Demonstration: =A13.Member returns a list of names, each being a person.
Using company data to return images from image URLs and clickable hyperlinks.
Customizing icons for a personalized touch.

💼 Practical Use:
Bill envisions the power of this feature for businesses, allowing for dynamic exploration of data directly within Excel. Imagine receiving a spreadsheet with an API-fed product list, empowering users to investigate and analyze effortlessly.

📊 Workbook Download:
Bill shares a downloadable workbook in the video, allowing you to explore these data types firsthand. The possibilities are vast, and the data types work seamlessly.

🎉 Breaking News:
As of last Friday, the awaited release is here! Bill showcases the capabilities, including the ability to return an array of entities, opening new avenues for data exploration.

🙌 Special Thanks:
A big shoutout to Suat for his contributions and figuring out the intricacies of this exciting development.

📈 Stay Tuned:
Don't miss out on this groundbreaking episode! Dive into the world of custom data types and elevate your Excel game. Hit that subscribe button, download the workbook, and let's explore together.

Table of Contents
(0:00) The quest for a perfect custom data type
(1:50) Download a workbook with working custom data types
(3:54) The back-end API
(5:17) ScriptLab add-in
(8:33) ScriptLab Function
(10:49) Visual Studio version
(12:00) Nerdvana check

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial

This video answers these common search terms:
how to add data types to excel
how to use your company data in a data type in excel
how to get data types to work in excel
what is a data type in excel
how do you change the data type in excel
what is convert to data types excel

[excelisfun]

Thanks, Mr Excel!!!! I have done this with Power BI and Excel mix, but this is a new

[wayneedmondson]

Thanks Mr. Excel. Looks like an awesome and powerful development! Can't wait to learn more about it. Thumbs up!!

[ricos]

That's more like it!!! I like it.

[Bobodia]

This is awesome! What avenues of news are there to hear about releases like this?

[NikkiXC]

Is it possible to schedule a JS api? I want to read some data online and save it into excel daily.

[dhunmsy]

This is great video, I made a test with this code and it works. But I am wondering why webimage type only work with your image url. I made a test with other image url, the image did not show in excel cell.