Building an Excel Custom Function Add-In Using the Office API | Pt. 6
Continuing on with our series, we now will switch gears slightly and focus on adding a new custom function to our task pane. That custom function will be called the UNPIVOT function which will take a pivoted range of data and convert it to a normalized set of data. Additionally, we will explore how to make are functions more user friendly by using the metadata JSON file and adding docstrings to our functions.
Video Resources:
--------------------------------------------------
https://github.com/areed1192/excel-cu...
Resources:
--------------------------------------------------
Facebook Page: / codingsigma
Facebook Group: / sigmacoding
GitHub Sigma Coding: https://github.com/areed1192/sigma_co...
Support Sigma Coding:
--------------------------------------------------
Patreon: / sigmacoding
Amazon Associates: https://amzn.to/3bsTI5P **
Related Topics:
--------------------------------------------------
Title: Conditional Formatting in the Excel JavaScript API
Link: • Conditional Formatting in the Excel J...
Title: How to Build Custom Excel Functions in the Excel JavaScript API
Link: • How to Build Custom Excel Functions i...
Title: How To Work With Tables in the Office JavaScript API
Link: • How To Work With Tables in the Office...
Title: Working With Pivot Tables in the Excel JavaScript API | Part 1
Link: • Working With Pivot Tables in the Exce...
Title: How To Select Ranges of Cells in the Microsoft Office JavaScript API
Link: • How To Select Ranges of Cells in the ...
Title: How To Work With Excel Ranges in the Office JavaScript API
Link: • How To Work With Excel Ranges in the ...
Title: Working With the Workbook Object in the Office JavaScript API
Link: • Working With the Workbook Object in t...
Title: How To Work With a Worksheet in the Office JavaScript API
Link: • How To Work With a Worksheet in the O...
Title: Building an Excel Custom Function Add-In Using the Office API | Pt. 1
Link: • Building an Excel Custom Function Add...
Title: Building an Excel Custom Function Add-In Using the Office API | Pt. 2
Link: • Building an Excel Custom Function Add...
Title: Building an Excel Custom Function Add-In Using the Office API | Pt. 4
Link: • Building an Excel Custom Function Add...
Title: Building an Excel Custom Function Add-In Using the Office API | Pt. 3
Link: • Building an Excel Custom Function Add...
Title: Building an Excel Custom Function Add-In Using the Office API | Pt. 5
Link: • Building an Excel Custom Function Add...
**Amazon Associates Disclosure:
--------------------------------------------------
I am a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com. One of the ways I support the channel is by using Amazon Associates to earn fees on purchases you make. That means when you use the link above, it will track any purchases made from that link and give a small portion of it to the Sigma Coding. I love this approach because it allows you to do what you're already doing (shopping) but also helps support the channels you care about. Also, it makes it where I can invest that revenue to help improve and grow the channel.
Tags:
--------------------------------------------------
#Excel #JavaScriptAPI #AddIns
Смотрите видео Building an Excel Custom Function Add-In Using the Office API | Pt. 6 онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Sigma Coding 06 Май 2020, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 2,843 раз и оно понравилось 34 людям.