Individual users are free of charge. They can automatically upgrade the Excel plug-in, use VSTO for development, explain the installation process of Excel catalyst, and solve installation failures. excelvsto

Individual users are free of charge. They can automatically upgrade the Excel plug-in, use VSTO for development, explain the installation process of Excel catalyst, and solve installation failures. excelvsto

Because the Excel catalyst uses VSTO development technology and uses Clickonce deployment mode for the best user experience (automatic update without manual intervention, allowing users to access the website like a browser, always the latest content and features ). The installation process is difficult. In this article, we only want to give you some practical guidance (the Excel catalyst plug-in has been installed successfully or other Excel plug-ins developed by VSTO have been installed successfully, it will be very easy to install other similar VSTO plug-ins, so it is necessary to have a hard time and will be easy in the future ).

Source description

The original text is published in the simplified book, and then synchronized to the Excel catalyst public account or other platforms. Subsequent modifications and updates to the article will be performed in the simplified book. Other platforms will not make modifications and updates simultaneously, therefore, it is recommended that you go back to the simplified book platform to view the articles from other sources as much as possible.
Address: https://www.jianshu.com/p/4efcee38175a

Series of articles

Excel catalyst installation process detailed explanation and installation failure solution-simple book https://www.jianshu.com/p/4efcee38175a
Excel catalyst function 1st wave-worksheet navigation-Simplified book https://www.jianshu.com/p/d9b2ae29cebe
Excel catalyst function 2nd wave-digital format settings-Simplified book https://www.jianshu.com/p/a758ac3e77e2
Excel catalyst function 3rd wave-interconnected with PowerbiDesktop-Simplified book https://www.jianshu.com/p/e05460ad407d
Excel catalyst function 4th wave-a large wave of custom functions advanced application, redefining the learning and use of Excel functions-Simplified book https://www.jianshu.com/p/534803771c20
Excel catalyst function 5th wave-Get data sources from PowerbiDeskTop using DAX queries-Simplified book https://www.jianshu.com/p/21b2ca8fd2b8
Excel catalyst function 6th wave-export PowerbiDesktop model data dictionary-Simplified https://www.jianshu.com/p/bc26a8dcdfce

Basic Environment requirements

Because the plug-ins use VSTO development technology, they are fully compatible with 32-bit/64-bit OFFICE (many plug-ins developed by non-VSTO on the market cannot be compatible with 64-bit OFFICE, A large number of plug-ins will be used for VSTO development in the future ). It requires some underlying Windows systems to support its running. The underlying environment includes the. net FrameWork and VSTO runtime.

Hosts IP address ing and trusted Certificate Installation

Because the automatic update mechanism requires the user's computer to fully trust the program developed by the developer, and recognizes that it will not cause harm to the computer, it can be automatically installed on the user's computer without user intervention, therefore, you need to trust your machine in the Developer Program (because Excel only trusts websites and does not trust IP address access, you need to use the Hosts file to configure the ing relationship, that is to say, let the computer know that accessing a domain name is actually accessing an IP address) and install the certificate used by the developer on the user's computer to ensure that the entire trust process can be completed.

Environment Installation Method

Excel catalyst has prepared some silly smart installation methods. You only need to double-click and run a few exe files to complete the installation as prompted. Download a rar compressed package with relevant operation indicators. The following is a simple explanation.
For (preferably add QQ Group 600275142, group file sharing more comprehensive): https://pan.baidu.com/s/1i5Vk88t

Check environment Installation

• . NetFrameWork4.62 components :( need win7sp1 and above to install) https://www.microsoft.com/zh-CN/download/details.aspx? Id = 53344

• . NetFrameWork4.5 components :( win7sp1 and above to install): https://www.microsoft.com/zh-CN/download/details.aspx? Id = 42637

• . NetFrameWork4.0 component: https://www.microsoft.com/zh-cn/download/details.aspx? Id = 17718

• VSTO runtime: https://www.microsoft.com/zh-CN/download/details.aspx? Id = 48217

• Microsoft SQL Server 2012 Native Client (32-bit and 64-bit, install clients of different digits based on the number of digits of the OFFICE version): https://www.microsoft.com/zh-CN/download/details.aspx? Id = 50402

2. Run [append hosts ing (administrator privilege: Run cmd.exe]
   The IP ing of the website path allows the computer to locally convert the access to the external IP address 101.132.130.88, that is, add a line 101.132.130.88 LiWeiJianWeb on the hosts file
3. Run the token Import Certificate and set the exceltrust folder .exe]
   Let Excel trust the program with the external network address, and import the certificate of the program developer, let Excel trust the version updates of the program stored on the network in the future, and automatically download the new version to local use.

Plugin installation

After the above operations are installed, you can download the plug-in at the following address. If no unexpected download is completed, double-click the plug-in to install the plug-in successfully. If you have any questions, please feel free to give feedback, QQ or no.: 190262897.
Excel catalyst plug-in:
Http: // 101.132.130.88/VSTO plug-in/Excel catalyst/setup.exe

Installed successfully

• Environment detection successful
  After installing all the environments and configuring hosts, the following style will appear:

  
  Environmental Testing success .png

• The trust path and certificate are successfully imported.
  After running the certificate and information path, the following style will appear successfully:

  
  Trust token set successfully .png

Certificate imported successfully. PNG installation failure and Solution

• Installation failure 1: solution: Find the file in the prompted path and delete the file.

  
  Installation Failure Case 1: click "cancel"-delete this file. PNG

• User-defined functions cannot be used.

  
  Custom processing failure handling failure .png

About Excel Catalysts

The Excel catalyst is the name of a public account, followed by its name. The Excel plug-in is officially released, and the plug-in will be updated continuously, the update cycle depends on the time of the person who wants to launch a major function module within one week. The Excel catalyst plug-in promises permanent free use for individual users!

The Excel catalyst plug-in uses the latest deployment technology for one installation. All updates are automatically updated in the future. You do not need to pay attention to the updates again. manually download the installation package and reinstall it, you only need to install the latest version once!

Excel catalyst plug-in download link: https://pan.baidu.com/s/1eT2znYM
Because the plug-in is developed using VSTO, the installation of the plug-in requires the computer to meet the relevant environment configuration before it can run, and the automatic update mechanism must be implemented by connecting to the Internet, if you have any questions during the download and installation process or need to install the offline version, try not to talk about it separately, the QQ group can be effectively solved (the Group has already brought together top domestic talents in VSTO development, Powerbi technology, and Sqlserver business intelligence. The benefits of joining the group do not need to be said too much)

Image

Name catalyst. Because of the strength of Excel, not everyone can immediately enjoy it. Most people are still in the stage of being abused by Excel software, that is, what they want to achieve clearly in their minds, in addition, experts have already achieved this, that is, they cannot do anything about them, or even worse, it takes countless years to spend time doing data mechanically and manually without knowing what Excel can do. Therefore, it gave rise to the question of whether it can be used as a medium, so that the majority of Excel users can instantly ignite the explosion of Excel, without the need to struggle to learn the skills of the day and night, the burning of advanced complex functions, finally, we are on the road from getting started to giving up.

In the end, Excel is powerful. In fact, we still need to establish a point of view. Not all tasks must be done in Excel, and not all tasks in Excel are competent, the world outside is still a vast world, Excel is just one of the dazzling stars, and there are other equally brilliant and powerful technologies and tools. * Excel catalysts will also leverage these other technologies to make Excel more powerful!

About Excel catalyst author

Name: Li weijian, a learner who has been engaged in data analysis for many years (for BI.
The technical route is from an ordinary user to a non-specialist IT professional who learns from the Excel software and then to the data world.
After a lot of difficulties, we finally reached the technical plain on the road of data, and it was no longer difficult to learn a lot of knowledge, it also forms its own data solution (data collection, data processing and cleaning, multi-dimensional data modeling, and data report presentation ).

Expertise in technical fields: Excel and other Office software, secondary development of VBA & VSTO, Sqlserver database technology, Sqlserver Business Intelligence BI technology, Powerbi technology, and ECs deployment technology.

In 2018, he started his career and made major adjustments. He switched from his original job to a freelancer, with no fixed income. He was not clear about the road and had to go back to his job, the Operation and Development of Excel catalysts must be greatly affected (it is impossible to maintain the Excel catalysts during the official working hours or to publish the results during the official working hours, the work time is also very limited, because of the establishment, family responsibility is significant ).

With the hope of many advocates, the Excel catalyst can continue to run, the group we benefit from is able to provide support (with more comments and encouragement, forwarding the Recommendations of the circle of friends, small reward, and the most important recommendation can be recommended with the company and its peers, let my technology bring value to your company and achieve a win-win situation (preliminary ideas can be achieved through data consulting or small project development ).)