src/AddIn/AddIn.cs


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36

using ExcelDna.Integration;
using ExcelDna.IntelliSense;
using Microsoft.Office.Interop.Excel;
using RhSolutions.Services;
using System.Net;
using System.Net.Http;

namespace RhSolutions.AddIn
{
    class RhSolutionsAddIn : IExcelAddIn
    {
        public static Application Excel;
        public static HttpClient httpClient;

        public void AutoOpen()
        {
            Excel = (Application)ExcelDnaUtil.Application;
            httpClient = new HttpClient();
            IntelliSenseServer.Install();
            RegistryUtil.Initialize();
            EventsUtil.Initialize();

            ServicePointManager.SecurityProtocol =
                SecurityProtocolType.Tls12 |
                SecurityProtocolType.Tls11 |
                SecurityProtocolType.Tls;
        }

        public void AutoClose()
        {
            IntelliSenseServer.Uninstall();
            RegistryUtil.Uninitialize();
            EventsUtil.Uninitialize();
        }
    }
}