
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.
Create an Excel add-in using C# VSTO to build a ribbon with two buttons, an edit box, and a label, enabling insert and retrieve operations on a worksheet.
Learn to build a ribbon with buttons to insert and read a range in an Excel add-in using C# VSTO, handling 1-based indexing for 2D ranges.
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.
learn to create an Excel chart with a c# vsto add-in using addchart2 on the active worksheet, set the chart type and margins, and bind data from a1 to c2.
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.
learn to insert and read data across multiple cells in an excel add-in built with c# vsto and web, using two-dimensional arrays, range operations, and returning results.
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