|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-add-in-with-c-vsto-and-web/
课程评论:没有评论
Coursera 课程:Excel 加载项开发:VSTO 与 Web 技术 本课程全面介绍 Excel 加载项的两种主要开发方式:VSTO (Visual Studio Tools for Office) 和 Web 加载项。无论您选择哪种技术,都能有效进行开发,具体取决于项目需求。 课程将从基础概念和环境设置开始,确保您能顺利上手。 **C# (VSTO) 部分:** * **Ribbon UI 开发:** 学习如何与 Excel 功能区(Ribbon)进行交互,并进行功能区的自定义设置。 * **Excel 对象操作:** 掌握如何定位工作表中的单元格、处理行和列。 * **高级功能:** 学习如何向 Excel 文件添加各种对象,以及其他丰富的操作,包括在加载项中选择文件。 **JavaScript (Web 加载项) 部分:** * **HTML 用户界面开发:** 学习如何利用 HTML 构建 Excel 加载项的用户界面,并实现与 Excel 工作表的交互。 * **Excel 对象操作:** 同样掌握如何定位单元格、处理行和列。 * **高级功能:** 学习如何向 Excel 文件添加各种对象,以及其他丰富的操作。 本课程包含源代码,助您轻松实践。
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