|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learning-excel-vsto-made-easy/
课程评论:没有评论
课程名称:轻松学习Excel编程(VSTO,C#,WPF [MVVM]) 课程概述:本课程专注于使用C#和WPF创建Excel VSTO插件和工作簿。从零开始构建实际功能的插件。课程将重点讨论与Excel插件相关的主题,而与之无关的内容将相对简略。通过课程,您将观看关于我们将要构建的插件的预览视频,以判断这是否是适合您的课程。 如果您对以下问题的回答都是“是”,那么这门课肯定适合您。反之,则不建议您加入课程: - 您是否喜欢通过构建实际应用程序来直接学习新编程技能? - 课程中会使用外部NuGet库快速构建用户界面(UI),您是否对使用NuGet库感到舒适? - 构建应用程序意味着需要花费更多时间设置应用程序的逻辑,您是否对此感到认同? - 课程将使用WPF构建UI,即使您对WPF不熟悉,也会逐步讲解构建过程。您是否愿意在学习Excel插件的同时学习WPF? 如果您对以上几点表示认可,那就准备好使用WPF构建现代、互动和响应式的Excel插件,学习之旅即将开始! 课程结束时,您将学到的重要和实用的Excel类和方法,这些知识可以应用到您的工作中,包括: - 使用Visual Studio进行工作 - 调试项目和修复错误 - 通过插件将外部文件数据导入Excel - 循环方法(for,foreach,while) - 面向对象编程 - 将您的插件打包成可与他人共享的可执行文件(.exe或.msi) 注意:为快速原型设计,课程将使用NuGet包,特别是TheoHaleyProject,这是一个用于构建UI的开源库集(免责声明:我也是Haley Project的作者,该项目托管在GitHub上)。
This course focuses on creating Excel VSTO add-ins & Excel VSTO Workbook using C#,WPF. Real-life functional add-ins will be built from scratch.Since this course is meant for learning Excel Add-ins, topics not related to Excel Add-ins will be taught with limited scope where as Excel Add-ins related topics will be dealt with complete focus.Take a look at the preview video regarding the add-ins that we will build in the course.Is this a Right course for you??If you say "Yes" to all the questions below, then this course is definitely for you. If you are not okay with some of the questions, then please do not join the course.Are you a kind of person who likes to learn new programming skill directly by starting to build real-life applications?Since this course is for learning Excel Add-ins, external NuGet libraries will be used for quick building of user interface (UI Windows). Are you comfortable with using NuGet libraries?Building an applications mean, spending more time on setting up the logic for the application itself. So, half the time you will learn building the application and its logic. Rest of the time, you will learn to manipulate the data and communicate/read/write data to Excel. Are you okay with this?I will use WPF (rather than Windows form) for building the UI. Even if you are new to WPF, you can find that this course explains every step of building the UI using WPF. If you already have no idea about WPF then are you ready to learn WPF along with Excel Add-ins?If you are okay with above points, then get ready to learn to build excel add-ins with modern/interactive/responsive UI using WPFAt the end of the Course, you would have learnedImportant and useful Excel classes and methods that you can apply on your work.Working with Visual StudioDebug the project and fix errorsImport data from external files into Excel via your add-inLooping methods (for , foreach, while)Object oriented programming Packaging your add-in into an executable (.exe or.msi) that can be shared with others.Note: For the purpose of quick prototyping of the UI, NuGet packages will be used. In Particular, TheHaleyProject , a set of opensource libraries, will be used for building UI. (Disclaimer: I'm the Author of Haley Project, a set of OpenSource libraries hosted in github).