
Explore excel add-in development with c# vsto and web add-ins, mastering dynamic typing and cross-platform considerations. Access, insert, retrieve data, modify properties, and insert values and formulas across both approaches.
Generate multiple sheets in the active workbook by looping through periods, adding and naming each sheet, merging cells A1:B1, and inserting the period date while sanitizing sheet names.
Explore the basics of web add-in development, set up a new project, clean defaults, and implement insert and read operations for a single Excel cell using a script.
These days there are two ways to develop excel add-ins - using vsto and using web add-ins. Both options work well, but the decision will likely be based on the project requirements, for that reason this course introduces both options. We will get through the basics and all the setup, so that you can get started with no interruptions.
Whilst Javascript option is available on all devices, C# options has no limitations - but this course will cover both options:
In the C# part, you will learn about interacting with excel sheets from ribbon UI, setting up ribbons themselves. With that, you will see how to find the right cells, how to deal with columns and rows. And not only that, but also how to add various objects and do a few more things with your excel files. And even how to pick files in the add-ins.
In the Javascript part, you will learn about interacting with excel sheets from html user interface, setting up interface itself. With that, you will see how to find the right cells, how to deal with columns and rows. And not only that, but also how to add various objects and do a few more things with your excel files.
--source code included