HYTOS

using SqlConnectionDialog;

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Data.SqlClient;

using Microsoft.Office.Interop.Excel;

using System.Windows.Forms;

using System.Drawing;

using System.IO;

using System.IO.Compression;

namespace ID2ManagerImport

{

    public static class DataManager

    {

        static string tableName = "ImportExcel";

        public static string ConnectionDialog()

        {

            var factory = new ConnectionStringFactory();

            var str = factory.OpenDialog();

            return str;

        }

        public static bool CreateTabile(string connectionString)

        {

            bool result = false;

            try

            {

                using (SqlConnection connection = new SqlConnection(connectionString))

                {

                    connection.Open();

                    string checkTableQuery = $"SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = '{tableName}'";

                    // 쿼리 실행하여 테이블 존재 여부 확인

                    SqlCommand checkTableCommand = new SqlCommand(checkTableQuery, connection);

                    int tableCount = (int)checkTableCommand.ExecuteScalar();

                    if (tableCount == 0)

                    {

                        // CREATE TABLE 문 작성

                        string createTableQuery = $"CREATE TABLE {tableName} ( "

                                    + " FILE_NAME VARCHAR(MAX),"

                                    + " WORKSHEET_NAME VARCHAR(MAX),"

                                    + " COUMMN_INDEX INT,"

                                    + " ROW_INDEX INT,"

                                    + " VALUE VARCHAR(MAX),"

                                    + " TopLeftCell VARCHAR(MAX),"

                                    + " OBJECT_TYPE INT"

                                  + " )";

                        // CREATE TABLE 쿼리 실행

                        SqlCommand createTableCommand = new SqlCommand(createTableQuery, connection);

                        createTableCommand.ExecuteNonQuery();

                        connection.Close();

                    }

                    result = true;

                }

            }

            catch (Exception)

            {

                throw;

            }

            return result;

        }

        public static void DeleteData(SqlConnection connection,string FileName, string worksheetName)

        {

                string delQuery = $"DELETE FROM {tableName} WHERE FILE_NAME = '{FileName}' AND WORKSHEET_NAME = '{worksheetName}'";

                // SQL 쿼리 실행

                SqlCommand command = new SqlCommand(delQuery, connection);

                command.ExecuteNonQuery();

        }

        public static bool Import(string FileName, Microsoft.Office.Interop.Excel.Worksheet worksheet)

        {

            bool result = true;

            try

            {

                var connectionStr = ConnectionDialog();

                if (connectionStr != null)

                {

                    if (CreateTabile(connectionStr))

                    {

                        using (SqlConnection connection = new SqlConnection(connectionStr))

                        {

                            connection.Open();

                            DeleteData(connection, FileName, worksheet.Name);

                            Range range = worksheet.UsedRange;

                            // 행 반복

                            for (int row = 1; row <= range.Rows.Count; row++)

                            {

                                // 열 반복

                                for (int column = 1; column <= range.Columns.Count; column++)

                                {

                                    string cellAddress = range.Cells[row, column].Address;

                                    var cellValue = range.Cells[row, column].Value;

                                    //Range cell = range.Cells[row, column];

                                    //XlCellType cellType = cell.Cells[row, column].CellType;

                                    //// 현재 셀 값 가져오기

                                    //string cellValue = cell.Cells[row, column].Value2.ToString();

                                    if (cellValue != null)

                                    {

                                        // SQL INSERT 쿼리 작성

                                        string query = $"INSERT INTO {tableName} (FILE_NAME,WORKSHEET_NAME,COUMMN_INDEX,ROW_INDEX,VALUE,TopLeftCell,OBJECT_TYPE) "

                                                     + $" VALUES ('{FileName}','{worksheet.Name}',{column},{row},'{cellValue}','{cellAddress}',0)";

                                        // SQL 쿼리 실행

                                        SqlCommand command = new SqlCommand(query, connection);

                                        command.ExecuteNonQuery();

                                    }

                                }

                            }

                            ImportImage(connection, FileName, worksheet);

                            connection.Close();

                            result = true;

                        }

                    }

                }

            }

            catch (Exception)

            {

                throw;

            }

            return result;

        }

        private static int GetColumnIndex(string CellAddress)

        {

            int columnIndex = 0;

            if (CellAddress.TrimStart('$').Split('$').Length > 0)

            {

                string columnAddress = CellAddress.TrimStart('$').Split('$')[0];

                foreach (char c in columnAddress)

                {

                    columnIndex = columnIndex * 26 + (int)c - 64;

                }

            }

            return columnIndex;

        }

        private static int GetRowIndex(string CellAddress)

        {

            int RowIndex = 0;

            if (CellAddress.TrimStart('$').Split('$').Length > 1)

            {

                string columnAddress = CellAddress.TrimStart('$').Split('$')[1];

                RowIndex = Convert.ToInt32(columnAddress);

            }

            return RowIndex;

        }

        public static bool ImportImage(SqlConnection connection, string FILE_NAME, Worksheet worksheet)

        {

            bool result = true;

            try

            {

                const Microsoft.Office.Core.MsoShapeType pictureShapeType = Microsoft.Office.Core.MsoShapeType.msoPicture;

                string query = $"INSERT INTO {tableName} (FILE_NAME,WORKSHEET_NAME,COUMMN_INDEX,ROW_INDEX,TopLeftCell,VALUE,OBJECT_TYPE) "

                                        + $" VALUES (@FileName,@worksheetName,@ColumnIndex,@RowIndex,@TopLeftCell,@cellValue,@ObjectType)";

                List<Microsoft.Office.Interop.Excel.Shape> shapes = new List<Shape>();

                foreach (Shape shape in worksheet.Shapes)

                {

                    shapes.Add(shape);

                }

                foreach (Shape shape in shapes)

                {

                    if (shape.Type == pictureShapeType)

                    {

                        string location = shape.TopLeftCell.Address; // 이미지의 위치 정보

                        string base64String = null;

                        try

                        {

                            float originalHeight = shape.Height;

                            float originalWidth = shape.Width;

                            shape.ScaleWidth(1.0f, Microsoft.Office.Core.MsoTriState.msoTrue, Microsoft.Office.Core.MsoScaleFrom.msoScaleFromTopLeft);

                            // 이미지를 가져올 Shape이 그림인 경우 처리

                            shape.CopyPicture(XlPictureAppearance.xlScreen, XlCopyPictureFormat.xlBitmap);

                                if (Clipboard.ContainsImage())

                                {

                                    // 클립보드에서 이미지 가져오기

                                    using (Image clipboardImage = Clipboard.GetImage())

                                    {

                                        // 이미지 크기를 원래 크기로 되돌리기

                                        // 이미지를 byte 배열로 변환

                                        byte[] imageBytes;

                                        using (MemoryStream ms = new MemoryStream())

                                        {

                                            clipboardImage.Save(ms, System.Drawing.Imaging.ImageFormat.Png);

                                            imageBytes = ms.ToArray();

                                            // 이미지를 Base64 문자열로 변환

                                            base64String = CompressString(Convert.ToBase64String(imageBytes));

                                            imageBytes = null;

                                        }

                                    }

                                    shape.ScaleWidth(originalWidth / shape.Width, Microsoft.Office.Core.MsoTriState.msoTrue, Microsoft.Office.Core.MsoScaleFrom.msoScaleFromTopLeft);

                                    Clipboard.Clear();

                                }

                            }

                            catch (Exception ex)

                            {

                                System.Diagnostics.Debug.WriteLine(ex);

                            }

                        // 이미지를 MSSQL에 저장

                        SqlCommand insertCommand = new SqlCommand(query, connection);

                        insertCommand.Parameters.AddWithValue("@FileName", FILE_NAME);

                        insertCommand.Parameters.AddWithValue("@worksheetName", worksheet.Name);

                        insertCommand.Parameters.AddWithValue("@ColumnIndex", GetColumnIndex(location));

                        insertCommand.Parameters.AddWithValue("@RowIndex", GetRowIndex(location));

                        insertCommand.Parameters.AddWithValue("@TopLeftCell", location);

                        insertCommand.Parameters.AddWithValue("@cellValue", base64String);

                        insertCommand.Parameters.AddWithValue("@ObjectType", 1);

                        insertCommand.ExecuteNonQuery();

                    }

                }

                shapes.Clear();

                result = true;

            }

            catch (Exception)

            {

                throw;

            }

            return result;

        }

        public static string CompressString(string str)

        {

            string result = null;

            using (MemoryStream outStream = new MemoryStream())

            {

                using (GZipStream gzipStream = new GZipStream(outStream, CompressionMode.Compress))

                using (MemoryStream srcStream = new MemoryStream(Encoding.UTF8.GetBytes(str)))

                    srcStream.CopyTo(gzipStream);

                result = Convert.ToBase64String(outStream.ToArray());

            }

            return result;

        }

        public static bool Export(Microsoft.Office.Interop.Excel.Worksheet worksheet)

        {

            bool result = true;

            try

            {

                var connectionStr = ConnectionDialog();

                if (connectionStr != null)

                {

                    if (CreateTabile(connectionStr))

                    {

                        using (SqlConnection connection = new SqlConnection(connectionStr))

                        {

                            connection.Open();

                            Microsoft.Office.Interop.Excel.Range range = worksheet.UsedRange;

                            // SQL INSERT 쿼리 작성

                            string query = $"select TopLeftCell,VALUE from {tableName}";

                            // SQL 쿼리 실행

                            SqlCommand command = new SqlCommand(query, connection);

                            var read = command.ExecuteReader();

                            while (read.Read())

                            {

                                MessageBox.Show($"{read.GetString(0)} ; {read.GetString(1)}");

                                break;

                            }

                            connection.Close();

                            result = true;

                        }

                    }

                }

            }

            catch (Exception)

            {

                throw;

            }

            return result;

        }

    }

}

<Project ToolsVersion="16.0" DefaultTargets="Build" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">

  <Import Project="$(MSBuildExtensionsPath)\$(MSBuildToolsVersion)\Microsoft.Common.props" Condition="Exists('$(MSBuildExtensionsPath)\$(MSBuildToolsVersion)\Microsoft.Common.props')" />

  <!--

    This section defines project-level properties.

    AssemblyName

      Name of the output assembly.

    Configuration

      Specifies a default value for debug.

    OutputType

      Must be "Library" for VSTO.

    Platform

      Specifies what CPU the output of this project can run on.

    NoStandardLibraries

      Set to "false" for VSTO.

    RootNamespace

      In C#, this specifies the namespace given to new files. In VB, all objects are

      wrapped in this namespace at runtime.

  -->

  <PropertyGroup>

    <ProjectTypeGuids>{BAA0C2D2-18E2-41B9-852F-F413020CAA33};{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}</ProjectTypeGuids>

    <Configuration Condition=" '$(Configuration)' == '' ">Debug</Configuration>

    <Platform Condition=" '$(Platform)' == '' ">AnyCPU</Platform>

    <ProjectGuid>{3477906E-C120-4FA6-B73D-93791283378A}</ProjectGuid>

    <OutputType>Library</OutputType>

    <NoStandardLibraries>false</NoStandardLibraries>

    <RootNamespace>ID2ManagerImport</RootNamespace>

    <AssemblyName>ID2ManagerImport</AssemblyName>

    <TargetFrameworkVersion>v4.8</TargetFrameworkVersion>

    <DefineConstants>VSTO40</DefineConstants>

    <IsWebBootstrapper>False</IsWebBootstrapper>

    <BootstrapperEnabled>true</BootstrapperEnabled>

    <PublishUrl>게시\</PublishUrl>

    <InstallUrl />

    <TargetCulture>ko</TargetCulture>

    <ApplicationVersion>1.0.0.4</ApplicationVersion>

    <AutoIncrementApplicationRevision>true</AutoIncrementApplicationRevision>

    <UpdateEnabled>false</UpdateEnabled>

    <UpdateInterval>0</UpdateInterval>

    <UpdateIntervalUnits>days</UpdateIntervalUnits>

    <ProductName>ID2ManagerImport</ProductName>

    <PublisherName />

    <SupportUrl />

    <FriendlyName>ID2ManagerImport</FriendlyName>

    <OfficeApplicationDescription />

    <LoadBehavior>3</LoadBehavior>

  </PropertyGroup>

  <ItemGroup>

    <BootstrapperPackage Include=".NETFramework,Version=v4.8">

      <Visible>False</Visible>

      <ProductName>Microsoft .NET Framework 4.8%28x86 및 x64%29</ProductName>

      <Install>true</Install>

    </BootstrapperPackage>

    <BootstrapperPackage Include="Microsoft.Net.Framework.3.5.SP1">

      <Visible>False</Visible>

      <ProductName>.NET Framework 3.5 SP1</ProductName>

      <Install>false</Install>

    </BootstrapperPackage>

    <BootstrapperPackage Include="Microsoft.VSTORuntime.4.0">

      <Visible>False</Visible>

      <ProductName>Microsoft Visual Studio 2010 Tools for Office Runtime%28x86 및 x64%29</ProductName>

      <Install>true</Install>

    </BootstrapperPackage>

  </ItemGroup>

  <PropertyGroup>

    <!--

      OfficeApplication

        Add-in host application

    -->

    <OfficeApplication>Excel</OfficeApplication>

  </PropertyGroup>

  <!--

    This section defines properties that are set when the "Debug" configuration is selected.

    DebugSymbols

      If "true", create symbols (.pdb). If "false", do not create symbols.

    DefineConstants

      Constants defined for the preprocessor.

    EnableUnmanagedDebugging

      If "true", starting the debugger will attach both managed and unmanaged debuggers.

    Optimize

      If "true", optimize the build output. If "false", do not optimize.

    OutputPath

      Output path of project relative to the project file.

    WarningLevel

      Warning level for the compiler.

  -->

  <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Debug|AnyCPU' ">

    <DebugSymbols>true</DebugSymbols>

    <DebugType>full</DebugType>

    <Optimize>false</Optimize>

    <OutputPath>bin\Debug\</OutputPath>

    <EnableUnmanagedDebugging>false</EnableUnmanagedDebugging>

    <DefineConstants>$(DefineConstants);DEBUG;TRACE</DefineConstants>

    <WarningLevel>4</WarningLevel>

    <PlatformTarget>x64</PlatformTarget>

  </PropertyGroup>

  <!--

    This section defines properties that are set when the "Release" configuration is selected.

    DebugSymbols

      If "true", create symbols (.pdb). If "false", do not create symbols.

    DefineConstants

      Constants defined for the preprocessor.

    EnableUnmanagedDebugging

      If "true", starting the debugger will attach both managed and unmanaged debuggers.

    Optimize

      If "true", optimize the build output. If "false", do not optimize.

    OutputPath

      Output path of project relative to the project file.

    WarningLevel

      Warning level for the compiler.

  -->

  <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Release|AnyCPU' ">

    <DebugType>pdbonly</DebugType>

    <Optimize>true</Optimize>

    <OutputPath>bin\Release\</OutputPath>

    <EnableUnmanagedDebugging>false</EnableUnmanagedDebugging>

    <DefineConstants>$(DefineConstants);TRACE</DefineConstants>

    <WarningLevel>4</WarningLevel>

  </PropertyGroup>

  <!--

    This section specifies references for the project.

  -->

  <ItemGroup>

    <Reference Include="Accessibility" />

    <Reference Include="System" />

    <Reference Include="System.Data" />

    <Reference Include="System.Drawing" />

    <Reference Include="System.Windows.Forms" />

    <Reference Include="System.Xml" />

    <Reference Include="System.Core" />

    <Reference Include="System.Xml.Linq" />

    <Reference Include="System.Data.DataSetExtensions" />

    <Reference Include="Microsoft.CSharp" />

  </ItemGroup>

  <ItemGroup>

    <Reference Include="Microsoft.Office.Tools.v4.0.Framework, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a, processorArchitecture=MSIL">

      <Private>False</Private>

    </Reference>

    <Reference Include="Microsoft.VisualStudio.Tools.Applications.Runtime, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a, processorArchitecture=MSIL">

      <Private>False</Private>

    </Reference>

    <Reference Include="Microsoft.Office.Tools, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a, processorArchitecture=MSIL">

      <Private>False</Private>

    </Reference>

    <Reference Include="Microsoft.Office.Tools.Common, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a, processorArchitecture=MSIL">

      <Private>False</Private>

    </Reference>

    <Reference Include="Microsoft.Office.Tools.Excel, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a, processorArchitecture=MSIL">

      <Private>False</Private>

    </Reference>

  </ItemGroup>

  <ItemGroup>

    <Reference Include="Microsoft.Office.Tools.Common.v4.0.Utilities, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a, processorArchitecture=MSIL">

      <Private>True</Private>

    </Reference>

  </ItemGroup>

  <ItemGroup>

    <Reference Include="Office, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c">

      <Private>False</Private>

      <EmbedInteropTypes>true</EmbedInteropTypes>

    </Reference>

    <Reference Include="Microsoft.Office.Interop.Excel, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c">

      <Private>False</Private>

      <EmbedInteropTypes>true</EmbedInteropTypes>

    </Reference>

    <Reference Include="stdole, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">

      <Private>False</Private>

    </Reference>

  </ItemGroup>

  <!--

    This section defines the user source files that are part of the project.

    A "Compile" element specifies a source file to compile.

    An "EmbeddedResource" element specifies an .resx file for embedded resources.

    A "None" element specifies a file that is not to be passed to the compiler (for instance, 

    a text file or XML file).

    The "AppDesigner" element specifies the directory where the application properties files

    can be found.

  -->

  <ItemGroup>

    <Compile Include="DataImport.cs" />

    <Compile Include="ID2Ribbon.cs">

      <SubType>Component</SubType>

    </Compile>

    <Compile Include="ID2Ribbon.Designer.cs">

      <DependentUpon>ID2Ribbon.cs</DependentUpon>

    </Compile>

    <Compile Include="Properties\AssemblyInfo.cs">

      <SubType>Code</SubType>

    </Compile>

    <EmbeddedResource Include="ID2Ribbon.resx">

      <DependentUpon>ID2Ribbon.cs</DependentUpon>

    </EmbeddedResource>

    <EmbeddedResource Include="Properties\Resources.resx">

      <Generator>ResXFileCodeGenerator</Generator>

      <LastGenOutput>Resources.Designer.cs</LastGenOutput>

      <SubType>Designer</SubType>

    </EmbeddedResource>

    <Compile Include="Properties\Resources.Designer.cs">

      <AutoGen>True</AutoGen>

      <DependentUpon>Resources.resx</DependentUpon>

    </Compile>

    <None Include="ID2ManagerImport_TemporaryKey.pfx" />

    <None Include="Properties\Settings.settings">

      <Generator>SettingsSingleFileGenerator</Generator>

      <LastGenOutput>Settings.Designer.cs</LastGenOutput>

    </None>

    <Compile Include="Properties\Settings.Designer.cs">

      <AutoGen>True</AutoGen>

      <DependentUpon>Settings.settings</DependentUpon>

    </Compile>

    <Compile Include="ThisAddIn.cs">

      <SubType>Code</SubType>

    </Compile>

    <None Include="ThisAddIn.Designer.xml">

      <DependentUpon>ThisAddIn.cs</DependentUpon>

    </None>

    <Compile Include="ThisAddIn.Designer.cs">

      <DependentUpon>ThisAddIn.Designer.xml</DependentUpon>

    </Compile>

    <AppDesigner Include="Properties\" />

  </ItemGroup>

  <ItemGroup>

    <PackageReference Include="MsSQLDialog">

      <Version>1.0.0</Version>

    </PackageReference>

  </ItemGroup>

  <PropertyGroup>

    <VisualStudioVersion Condition="'$(VisualStudioVersion)' == ''">10.0</VisualStudioVersion>

    <VSToolsPath Condition="'$(VSToolsPath)' == ''">$(MSBuildExtensionsPath32)\Microsoft\VisualStudio\v$(VisualStudioVersion)</VSToolsPath>

  </PropertyGroup>

  <PropertyGroup>

    <SignManifests>true</SignManifests>

  </PropertyGroup>

  <PropertyGroup>

    <ManifestKeyFile>ID2ManagerImport_TemporaryKey.pfx</ManifestKeyFile>

  </PropertyGroup>

  <PropertyGroup>

    <ManifestCertificateThumbprint>EF3F3E89EB1A23160BB3D1B0635AF73C25DFB484</ManifestCertificateThumbprint>

  </PropertyGroup>

  <!-- Include the build rules for a C# project. -->

  <Import Project="$(MSBuildToolsPath)\Microsoft.CSharp.targets" />

  <!-- Include additional build rules for an Office application add-in. -->

  <Import Project="$(VSToolsPath)\OfficeTools\Microsoft.VisualStudio.Tools.Office.targets" Condition="'$(VSToolsPath)' != ''" />

  <!-- This section defines VSTO properties that describe the host-changeable project properties. -->

  <ProjectExtensions>

    <VisualStudio>

      <FlavorProperties GUID="{BAA0C2D2-18E2-41B9-852F-F413020CAA33}">

        <ProjectProperties HostName="Excel" HostPackage="{29A7B9D7-A7F1-4328-8EF0-6B2D1A56B2C1}" OfficeVersion="15.0" VstxVersion="4.0" ApplicationType="Excel" Language="cs" TemplatesPath="" DebugInfoExeName="#Software\Microsoft\Office\16.0\Excel\InstallRoot\Path#excel.exe" DebugInfoCommandLine="/x" AddItemTemplatesGuid="{51063C3A-E220-4D12-8922-BDA915ACD783}" />

        <Host Name="Excel" GeneratedCodeNamespace="ID2ManagerImport" PublishedHash="69C324AB27932AA2FBF2B7EA72250886FF164DE6" IconIndex="0">

          <HostItem Name="ThisAddIn" Code="ThisAddIn.cs" CanonicalName="AddIn" PublishedHash="82537F06F54D5DD73334C8FD08F4F6A9937971E0" CanActivate="false" IconIndex="1" Blueprint="ThisAddIn.Designer.xml" GeneratedCode="ThisAddIn.Designer.cs" />

        </Host>

      </FlavorProperties>

    </VisualStudio>

  </ProjectExtensions>

</Project>



Microsoft Visual Studio Solution File, Format Version 12.00

# Visual Studio Version 16

VisualStudioVersion = 16.0.33423.256

MinimumVisualStudioVersion = 10.0.40219.1

Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "ID2ManagerImport", "ID2ManagerImport.csproj", "{3477906E-C120-4FA6-B73D-93791283378A}"

EndProject

Global

	GlobalSection(SolutionConfigurationPlatforms) = preSolution

		Debug|Any CPU = Debug|Any CPU

		Release|Any CPU = Release|Any CPU

	EndGlobalSection

	GlobalSection(ProjectConfigurationPlatforms) = postSolution

		{3477906E-C120-4FA6-B73D-93791283378A}.Debug|Any CPU.ActiveCfg = Debug|Any CPU

		{3477906E-C120-4FA6-B73D-93791283378A}.Debug|Any CPU.Build.0 = Debug|Any CPU

		{3477906E-C120-4FA6-B73D-93791283378A}.Release|Any CPU.ActiveCfg = Release|Any CPU

		{3477906E-C120-4FA6-B73D-93791283378A}.Release|Any CPU.Build.0 = Release|Any CPU

	EndGlobalSection

	GlobalSection(SolutionProperties) = preSolution

		HideSolutionNode = FALSE

	EndGlobalSection

	GlobalSection(ExtensibilityGlobals) = postSolution

		SolutionGuid = {7271D6F3-241B-47EE-A9A2-999C578F11C0}

	EndGlobalSection

EndGlobal



namespace ID2ManagerImport

{

    partial class ID2Ribbon : Microsoft.Office.Tools.Ribbon.RibbonBase

    {

        /// <summary>

        /// 필수 디자이너 변수입니다.

        /// </summary>

        private System.ComponentModel.IContainer components = null;

        public ID2Ribbon()

            : base(Globals.Factory.GetRibbonFactory())

        {

            InitializeComponent();

        }

        /// <summary> 

        /// 사용 중인 모든 리소스를 정리합니다.

        /// </summary>

        /// <param name="disposing">관리되는 리소스를 삭제해야 하면 true이고, 그렇지 않으면 false입니다.</param>

        protected override void Dispose(bool disposing)

        {

            if (disposing && (components != null))

            {

                components.Dispose();

            }

            base.Dispose(disposing);

        }

        #region 구성 요소 디자이너에서 생성한 코드

        /// <summary>

        /// 디자이너 지원에 필요한 메서드입니다. 

        /// 이 메서드의 내용을 코드 편집기로 수정하지 마세요.

        /// </summary>

        private void InitializeComponent()

        {

            System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(ID2Ribbon));

            this.tab1 = this.Factory.CreateRibbonTab();

            this.group1 = this.Factory.CreateRibbonGroup();

            this.btnSend = this.Factory.CreateRibbonButton();

            this.btLoad = this.Factory.CreateRibbonButton();

            this.tab1.SuspendLayout();

            this.group1.SuspendLayout();

            this.SuspendLayout();

            // 

            // tab1

            // 

            this.tab1.ControlId.ControlIdType = Microsoft.Office.Tools.Ribbon.RibbonControlIdType.Office;

            this.tab1.Groups.Add(this.group1);

            this.tab1.Label = "TabAddIns";

            this.tab1.Name = "tab1";

            // 

            // group1

            // 

            this.group1.Items.Add(this.btnSend);

            this.group1.Items.Add(this.btLoad);

            this.group1.Label = "ID2 Manager";

            this.group1.Name = "group1";

            // 

            // btnSend

            // 

            this.btnSend.Image = ((System.Drawing.Image)(resources.GetObject("btnSend.Image")));

            this.btnSend.Label = "Send Data";

            this.btnSend.Name = "btnSend";

            this.btnSend.ShowImage = true;

            this.btnSend.Click += new Microsoft.Office.Tools.Ribbon.RibbonControlEventHandler(this.btnSend_Click);

            // 

            // btLoad

            // 

            this.btLoad.Label = "Get Data";

            this.btLoad.Name = "btLoad";

            this.btLoad.ShowImage = true;

            this.btLoad.Click += new Microsoft.Office.Tools.Ribbon.RibbonControlEventHandler(this.btLoad_Click);

            // 

            // ID2Ribbon

            // 

            this.Name = "ID2Ribbon";

            this.RibbonType = "Microsoft.Excel.Workbook";

            this.Tabs.Add(this.tab1);

            this.Load += new Microsoft.Office.Tools.Ribbon.RibbonUIEventHandler(this.ID2Ribbon_Load);

            this.tab1.ResumeLayout(false);

            this.tab1.PerformLayout();

            this.group1.ResumeLayout(false);

            this.group1.PerformLayout();

            this.ResumeLayout(false);

        }

        #endregion

        internal Microsoft.Office.Tools.Ribbon.RibbonTab tab1;

        internal Microsoft.Office.Tools.Ribbon.RibbonGroup group1;

        internal Microsoft.Office.Tools.Ribbon.RibbonButton btnSend;

        internal Microsoft.Office.Tools.Ribbon.RibbonButton btLoad;

    }

    partial class ThisRibbonCollection

    {

        internal ID2Ribbon ID2Ribbon

        {

            get { return this.GetRibbon<ID2Ribbon>(); }

        }

    }

}

using Microsoft.Office.Tools.Ribbon;

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Windows.Forms;

namespace ID2ManagerImport

{

    public partial class ID2Ribbon

    {

        private void ID2Ribbon_Load(object sender, RibbonUIEventArgs e)

        {

        }

        private void btnSend_Click(object sender, RibbonControlEventArgs e)

        {

            Microsoft.Office.Interop.Excel.Worksheet sheet = Globals.ThisAddIn.Application.ActiveSheet;

            if (DataManager.Import(Globals.ThisAddIn.Application.ActiveWorkbook.Name, sheet))

            {

                MessageBox.Show("Send data Ok");

            }

        }

        private void btLoad_Click(object sender, RibbonControlEventArgs e)

        {

            Microsoft.Office.Interop.Excel.Worksheet sheet = Globals.ThisAddIn.Application.ActiveSheet;

            if (DataManager.Export(sheet))

            {

                MessageBox.Show("Read Ok");

            }

        }

    }

}

<?xml version="1.0" encoding="utf-8"?>

<root>

  <!-- 

    Microsoft ResX Schema 

    Version 2.0

    The primary goals of this format is to allow a simple XML format 

    that is mostly human readable. The generation and parsing of the 

    various data types are done through the TypeConverter classes 

    associated with the data types.

    Example:

    ... ado.net/XML headers & schema ...

    <resheader name="resmimetype">text/microsoft-resx</resheader>

    <resheader name="version">2.0</resheader>

    <resheader name="reader">System.Resources.ResXResourceReader, System.Windows.Forms, ...</resheader>

    <resheader name="writer">System.Resources.ResXResourceWriter, System.Windows.Forms, ...</resheader>

    <data name="Name1"><value>this is my long string</value><comment>this is a comment</comment></data>

    <data name="Color1" type="System.Drawing.Color, System.Drawing">Blue</data>

    <data name="Bitmap1" mimetype="application/x-microsoft.net.object.binary.base64">

        <value>[base64 mime encoded serialized .NET Framework object]</value>

    </data>

    <data name="Icon1" type="System.Drawing.Icon, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">

        <value>[base64 mime encoded string representing a byte array form of the .NET Framework object]</value>

        <comment>This is a comment</comment>

    </data>

    There are any number of "resheader" rows that contain simple 

    name/value pairs.

    Each data row contains a name, and value. The row also contains a 

    type or mimetype. Type corresponds to a .NET class that support 

    text/value conversion through the TypeConverter architecture. 

    Classes that don't support this are serialized and stored with the 

    mimetype set.

    The mimetype is used for serialized objects, and tells the 

    ResXResourceReader how to depersist the object. This is currently not 

    extensible. For a given mimetype the value must be set accordingly:

    Note - application/x-microsoft.net.object.binary.base64 is the format 

    that the ResXResourceWriter will generate, however the reader can 

    read any of the formats listed below.

    mimetype: application/x-microsoft.net.object.binary.base64

    value   : The object must be serialized with 

            : System.Runtime.Serialization.Formatters.Binary.BinaryFormatter

            : and then encoded with base64 encoding.

    mimetype: application/x-microsoft.net.object.soap.base64

    value   : The object must be serialized with 

            : System.Runtime.Serialization.Formatters.Soap.SoapFormatter

            : and then encoded with base64 encoding.

    mimetype: application/x-microsoft.net.object.bytearray.base64

    value   : The object must be serialized into a byte array 

            : using a System.ComponentModel.TypeConverter

            : and then encoded with base64 encoding.

    -->

  <xsd:schema id="root" xmlns="" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">

    <xsd:import namespace="http://www.w3.org/XML/1998/namespace" />

    <xsd:element name="root" msdata:IsDataSet="true">

      <xsd:complexType>

        <xsd:choice maxOccurs="unbounded">

          <xsd:element name="metadata">

            <xsd:complexType>

              <xsd:sequence>

                <xsd:element name="value" type="xsd:string" minOccurs="0" />

              </xsd:sequence>

              <xsd:attribute name="name" use="required" type="xsd:string" />

              <xsd:attribute name="type" type="xsd:string" />

              <xsd:attribute name="mimetype" type="xsd:string" />

              <xsd:attribute ref="xml:space" />

            </xsd:complexType>

          </xsd:element>

          <xsd:element name="assembly">

            <xsd:complexType>

              <xsd:attribute name="alias" type="xsd:string" />

              <xsd:attribute name="name" type="xsd:string" />

            </xsd:complexType>

          </xsd:element>

          <xsd:element name="data">

            <xsd:complexType>

              <xsd:sequence>

                <xsd:element name="value" type="xsd:string" minOccurs="0" msdata:Ordinal="1" />

                <xsd:element name="comment" type="xsd:string" minOccurs="0" msdata:Ordinal="2" />

              </xsd:sequence>

              <xsd:attribute name="name" type="xsd:string" use="required" msdata:Ordinal="1" />

              <xsd:attribute name="type" type="xsd:string" msdata:Ordinal="3" />

              <xsd:attribute name="mimetype" type="xsd:string" msdata:Ordinal="4" />

              <xsd:attribute ref="xml:space" />

            </xsd:complexType>

          </xsd:element>

          <xsd:element name="resheader">

            <xsd:complexType>

              <xsd:sequence>

                <xsd:element name="value" type="xsd:string" minOccurs="0" msdata:Ordinal="1" />

              </xsd:sequence>

              <xsd:attribute name="name" type="xsd:string" use="required" />

            </xsd:complexType>

          </xsd:element>

        </xsd:choice>

      </xsd:complexType>

    </xsd:element>

  </xsd:schema>

  <resheader name="resmimetype">

    <value>text/microsoft-resx</value>

  </resheader>

  <resheader name="version">

    <value>2.0</value>

  </resheader>

  <resheader name="reader">

    <value>System.Resources.ResXResourceReader, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>

  </resheader>

  <resheader name="writer">

    <value>System.Resources.ResXResourceWriter, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>

  </resheader>

  <assembly alias="System.Drawing" name="System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />

  <data name="btnSend.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">

    <value>

        /9j/4AAQSkZJRgABAQEAYABgAAD/4QBiRXhpZgAATU0AKgAAAAgAAgE7AAIAAAARAAAAJpydAAEAAAAi

        AAAAOAAAAABLaW0gdGFlc3VuZyBLVFMuAABLAGkAbQAgAHQAYQBlAHMAdQBuAGcAIABLAFQAUwAuAAAA

        /9sAQwAHBQUGBQQHBgUGCAcHCAoRCwoJCQoVDxAMERgVGhkYFRgXGx4nIRsdJR0XGCIuIiUoKSssKxog

        LzMvKjInKisq/9sAQwEHCAgKCQoUCwsUKhwYHCoqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioq

        KioqKioqKioqKioqKioqKioq/8AAEQgA9ADuAwEiAAIRAQMRAf/EAB8AAAEFAQEBAQEBAAAAAAAAAAAB

        AgMEBQYHCAkKC//EALUQAAIBAwMCBAMFBQQEAAABfQECAwAEEQUSITFBBhNRYQcicRQygZGhCCNCscEV

        UtHwJDNicoIJChYXGBkaJSYnKCkqNDU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6

        g4SFhoeIiYqSk5SVlpeYmZqio6Slpqeoqaqys7S1tre4ubrCw8TFxsfIycrS09TV1tfY2drh4uPk5ebn

        6Onq8fLz9PX29/j5+v/EAB8BAAMBAQEBAQEBAQEAAAAAAAABAgMEBQYHCAkKC//EALURAAIBAgQEAwQH

        BQQEAAECdwABAgMRBAUhMQYSQVEHYXETIjKBCBRCkaGxwQkjM1LwFWJy0QoWJDThJfEXGBkaJicoKSo1

        Njc4OTpDREVGR0hJSlNUVVZXWFlaY2RlZmdoaWpzdHV2d3h5eoKDhIWGh4iJipKTlJWWl5iZmqKjpKWm

        p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uLj5OXm5+jp6vLz9PX29/j5+v/aAAwDAQACEQMR

        AD8A+kaKKKACiiigAooooAKKKKACiiigBrUhOBnrnsafSYoAaBn6Uk88NpbvPcypDDGpZ5JGCqoHUkno

        KS4uIbO2kuLqVIYYlLvI5wqgdSTXzh8TvidN4uuW03SXeHRon/3WuSOjN/s9wv4nnAAB6vL8Z/BcV6IP

        7Qldc4MyWzlB+mT+ANdnp2p2Wr2EV7plzHdW0oyksbZB/wAD7dRXxhXX/D/4gX3gjVDjdcabOw+02uf/

        AB9fRgPwPQ9iAD6qoqlpOr2OuaZDqGl3CXFrMu5HX+RHYjuD0q7QAUUUUAFFGcUm6gBaKKKACiiigAoo

        ooAKKKKACiiigAooooAKKKKACiiigAooooAKjubmGztpLi6lSGGJS7yO2FUDqSaLm5hs7WS4upUhhiUu

        8jnCqB1JNfN/xO+J03i26bTdJd4dGif/AHWuiP4mH93uFP1POAAA+J3xOm8XXLabpLvDo0T/AO61yR/E

        w/u9wv4nnAHnVFFABRRRQB1/w/8AiBfeCNUON1xps7D7Ta5/8fX0Yfkeh7EfTuk6tZa5pkOoaXcJcWsy

        5R0/kR2I7g8ivjOuv+H/AMQL3wRqhIDXGmzsPtNrn/x9fRh+R6HsQAfVVFUtJ1ex1vS4dQ0u4S4tZlyk

        in9D6EdweRVsnPAoAQn5umaMDbweO1GPlPPB7ikC4GAc+tADx+dLSAYpaACiiigAooooAKKKKACiiigA

        ooooAKRjilJxTCckZ6UAL3HcUAnvTRuDE9qUAn6UAPqO5uYbO2kuLqVIYYlLvI5wqgdSTSXNzDZ2slxd

        SpDDEpd5HOFUDqSa+cPid8TpvF102m6S8kOjRP8A7rXJHRmH93uF+hPOAAA+J3xOm8XXLabpLvDo0T/7

        rXRH8TD+73C/QnnAHnVFPhhkuJkhgjaSWRgqIgyWJ6ADuaACGGS4mSGCNpJZGCoiDJYnoAO5rf8AFXgj

        VvBsenNrPkq9/E0ixxuWaMrtyrcYyNw6ZHvXtfwv+F0fheFNW1uNJdYkXKIfmFqD2Hq/YkdOQOMk83+0

        T/x8eHv924/nHQB4tW54S8J6h4y1h9N0p4EmSFpmadiqhQQOwJzlhWHXp/wD/wCSgXX/AGDZP/RkdAHn

        Oo6deaTqE1jqVu9tdQNtkiccqf6j3HBqtX1F8Rfh1aeNtPEsWy31aBSILjs4/uP6j36jt3B+Z9Q0290r

        UJrHUbaS3uoG2yROOVP9R7jg9qAOm8AePb7wRqG/LT6bOw+0Wuev+2vowH4HoexH0zpWrWOt6bDqOkzp

        c20wyrr/ACI7Eeh5FfHSyMMLtBI4BPauu8C/EG98E6oMFrjT5iPtVuD1/wBpfRgPwPQ9iAD6jAGCFH50

        8DFU9I1Wx1vS4dQ0u4S4tZhlJF/kR1BHcHkVdoAKKKKACiiigAooooAKM0UxjzxQA+iiigApCfSlNMyO

        ece9AAeVzQOWyD8uOlIAACVzkevelAzzigAUZ+lPo6UUAeQftA6vc22jaVpcLMkF5LJJMVON/l7cKfUZ

        fOPUCvBa+rfiJ4Jj8b+HRaJKsF5A/m20rD5Q2MFW77T7egPOMHwKb4U+NYrowf2FM5yQHSRCje+7dj88

        UAclDDJcTJDBG0kkjBURBksTwAB3NfRXwv8AhdH4XhTV9bjSXWJF+RPvC1B7D/b7EjpyBxkl/wAM/hXF

        4TA1PWhFcau64QL8y2wPZT3Y92/AcZJ9JoAK8P8A2if+Pjw9/u3H8469wrw/9on/AI+PD3+7cfzjoA8W

        r074B/8AJQLr/sGyf+jI68xr074Cgj4g3QPB/s6T/wBGR0AfRJya4v4gfD218Z6f5sW231WEHyLjoHH9

        x/VffqO3cHshjBwcjuKNo27RyM5oA+NtV0660rUpbLUoHgu4W2yxuPun+o9xwap19RfEP4c2fjawEkRS

        21aBcQXJHDD+4+Oq+/Udu4Phk3wp8axXTQDQppCCQHSRCje+7dj88UAdb8ANXuo/Ed/o+8m0mtjc7CeF

        dWVcj0yG5+g9K99rz74WfDp/BdjPd6m0cmqXahX8vlYUHOwHuSeT24GOmT6DQAUUUUAFFFFABRRTGPyk

        k4oAUnPApBwc9fpSZB5TkjqKUYXO0HPegB9ITigmm5PpkUAGctQee3TrRySe644oAJ6mgBQM06iigAoo

        ooAKKKKACiiigArw/wDaJ/4+PD3+7cfzjr3CvD/2if8Aj58Pf7tx/OOgDxavU/gVj/hYFwv8Q058N6/v

        I680LBk3Pgrj8c16V8B3z4+uVU5H9nSdR0/eR0AfQg74GCetOAxQBiloAKKKKACiiigAooooAKKKaSe1

        ACk0zPsD9aUcdfzBoxzz1oADk4z19qcBQBS0AM6rzxzwaTHzA5wR1FBX5cNyOxFOAyaAEAyfan0UUAFF

        FFABRRRQAUUUUAFFFFABXh/7RP8Ax8eHv924/nHXuFeH/tE/8fHh7/duP5x0AeLhsIV7GvTvgH/yUC6/

        7B0n/oyOvMK9P+Af/JQLr/sHSf8AoyOgD6KooooAKKKKACiiigAoJxRTGagAJ7UDgnBz6ikJGQp69QaU

        dTxz3oAQKAuF5yc08DFAGKWgAooooAYFp9FFABRRRQAUUUUAFFFFABRQTimk4x70AOopobnFOoAK8P8A

        2if+Pjw9/u3H8469wrw/9on/AI+PD3+7cfzjoA8Wr0/4B/8AJQLr/sHSf+jI68wr0/4B/wDJQLr/ALB0

        n/oyOgD6KooooAKKKKACiiigBG6U3qOcY70+m460AIOg2n8+1OAxQBiloAKKKKACiiigAooooAKKKKAC

        iiigAooJxTCSRxQArNTc7X2gZHejP3cLkHrS85IoAXqeMU4UgGKWgArw/wDaJ/4+PD3+7cfzjr3CvD/2

        if8Aj48Pf7tx/OOgDxavT/gH/wAlAuv+wdJ/6MjrzCvT/gH/AMlAuv8AsHSf+jI6APoqiiigAooooAKK

        KKACiiigAooooAKKKKACiiigAooooAKKKKACijNNLZ4FAAfvU0BgT8wz6Up/WgDjgUAIAP4cingYoAxS

        0AFFFFABXh/7RP8Ax8eHv924/nHXuFeH/tE/8fHh7/duP5x0AeLV6f8AAP8A5KBdf9g6T/0ZHXmFen/A

        P/koF1/2DpP/AEZHQB9FUGims1AASRz2ozg4ppO1gAM5607OTxigB1FAooAKKKKACiiigAooooAKKKM0

        AFFFFABRRTeuR3oAQsM89KTjcBjIPej5to29c80vRiB0oAMknoPrTgMUAYpaACiiigAooooAK8P/AGif

        +Pjw9/u3H8469wrw/wDaJ/4+PD3+7cfzjoA8Wr0/4B8fEC6/7Bsn/oyOvMK9O+An/JQLnP8A0DpP/Rkd

        AH0TknpTcnAwu7nmjDbuoB9KBj+HIPegB3O7ApQMUAYpaACiiigAooooAKKKKACiikLUAIWxSZyfm4FA

        yO2RQM5JJyp6UAPooooAb1zzim4OCDxnoacRhvY0nOcdqADGcc5PrTgMUAYpaACiiigAooooAKKKKACv

        D/2if+Pjw9/u3H8469wryH4+aNPd6TpmrRRtJDYvJHOFGdgk24Y+2Vx/wIUAeCd8V6j8CIwvj265Of7P

        kH1/eR15ptRdoC7g38Vet/AbSruTxBqGrmPFrDbm1Eh/jdmVsD6BefqKAPdVHoOfWnAYoAxS0AFFFFAB

        RRRQAUUUUAFFFB6UAITTTyoB4J6UcEdPypMDGD8wHSgA437jkH0pwWgDJyadQAUUVDeXAtLGe4YbhDGz

        keuBmgDK1/xhoHhkouuanDau4ysZyzkeu1QTj3xSaB4y8PeJnZND1SG6kQbmiwUcD12sAce+K+TtW1W7

        1zVrnUtRkaW5uXLuxOcegHsBgAdgBTdN1G60jU7fUNPlaG5t3Dxupxg/4HoR3BIoA+z6Kq6ZeDUNJtL0

        LtFzAkoX03KDj9atUAFFFFABRRRQAUUU0855xQAdTiopYlnt5IZY1kRwVdHAIZT1BB6g0/nnPGR1FGOA

        M5PrQBxU3wh8Gy3xuP7MZNx3NFHcOqZ+gPH0HFdhp+nWml2Udpp1tFbW8YwkUShVHfoPfmrAGKWgAooo

        oAKKKKACiiigAooooAKytc8TaN4bt1m1zUIbNXPyBzln+ijJP4CtU18ieNtduPEXjLUb+5kZgZ2jhU/w

        RKxCqPw/Uk96APpfQ/HvhnxFd/ZtI1aGacg4iZWjdvoGAJ/CuiVa+K4Zpba4jnt5GiljYOjocMrA5BB7

        EGvrzwfqs2ueDdK1K6wZ7i2RpSowC+MMQPqDQBtUUUUAFUtZ/wCQDf8A/XtJ/wCgmrtUtZ/5AN//ANe0

        n/oJoA+Mh0FLSDoKWgD7F8Mf8ijo/wD14w/+ixWpWX4Y/wCRR0f/AK8Yf/RYrUoAKKKKACiiigApp4Oa

        dRQAzkHA4FOAxS4ooAKKKKACiiigAooooAKKKQtigBaKTdS0AB6V8X6l/wAha7/67v8A+hGvtA9K+L9S

        /wCQtd/9d3/9CNAFavrD4af8k10P/r2H8zXyfX1h8NP+Sa6H/wBew/maAOpooooAKpaz/wAgG/8A+vaT

        /wBBNXapaz/yAb//AK9pP/QTQB8ZDoKWkHQUtAH2L4YOfCOj4/58YP8A0WK1K+XtD+L3ivQNJh062mtr

        iCBdkX2qIuyKOiggjgds9OlaP/C9vGH93Tf/AAGb/wCLoA+kKK+b/wDhe3jD+7pv/gM3/wAXR/wvbxh/

        d03/AMBm/wDi6APpCivm/wD4Xt4w/u6b/wCAzf8AxdH/AAvbxh/d03/wGb/4ugD6Qor5v/4Xt4w/u6b/

        AOAzf/F0f8L28Yf3dN/8Bm/+LoA+kKK+b/8Ahe3jD+7pv/gM3/xdH/C9vGH93Tf/AAGb/wCLoA+kKK+b

        /wDhe3jD+7pv/gM3/wAXR/wvbxh/d03/AMBm/wDi6APpCivm/wD4Xt4w/u6b/wCAzf8AxdH/AAvbxh/d

        03/wGb/4ugD6Qor5v/4Xt4w/u6b/AOAzf/F0f8L28YHomm/+Azf/ABdAH0eTimE7Rz0PavnUfHLxbsLO

        unYzjAtm/wDi6Vvjl4rUDKacR1B+zt/8XQB9FccdSMcGnDpXzf8A8L18X5zs03/wHb/4ul/4Xt4w/u6b

        /wCAzf8AxdAH0ga+L9ROdUuyOR57/wDoRruL342eML2ylt/Ns7fzFKmSCAh1B9CWOD74rz7p0oAK+sPh

        p/yTXQ/+vYfzNfJ9fWHw0/5Jrof/AF7D+ZoA6miiigAqtqMD3Ol3UEf35YXRc+pUirNFAHxRJFJBK0Uy

        FJI2KurDBUjgg02vpbxl8HdG8VX8moW08mmX0pzK8SB45D3JTjn3BHvk1y3/AAzuP+hlP/gD/wDbKAPE

        qK9t/wCGdx/0Mx/8Af8A7ZSf8M8DOB4lP/gD/wDbKAPFU++Mru9qk8oeWdpGDggmvZ1/Z7Cq3/FS/e7/

        AGL/AO2UD9nvapUeJc56/wCg/wD2ygDxNl2nBIP0pK9tH7Ow/wChlP8A4A//AGyj/hnYf9DMf/AH/wC2

        UAeJUV7b/wAM7D/oZj/4A/8A2yj/AIZ2H/QzH/wB/wDtlAHiVFe2/wDDOw/6GY/+AP8A9so/4Z2H/QzH

        /wAAf/tlAHiVFe2/8M7D/oZj/wCAP/2yj/hnYf8AQzH/AMAf/tlAHiVFe2/8M7j/AKGY/wDgD/8AbKD+

        zwB/zMx/8Af/ALZQB4mBkgepqUKUf5FJwMEk9a9m/wCGeM/8zL/5I/8A2ynL+z7yN3iZiB2+xf8A2ygD

        xhmwGbPXqp9ahZixyfwA7V7Yf2ed7Fj4lxn/AKcf/tlH/DOw/wChmP8A4A//AGygDxKivbf+Gdh/0Mx/

        8Af/ALZR/wAM7D/oZj/4A/8A2ygDxKivbf8AhnYf9DMf/AH/AO2Uf8M7D/oZv/JH/wC2UAeJV9bfD61l

        s/h5okNwhSQWiMyMMFcjOCPXmuQ8N/AvRtHv0u9XvJNWaNgyRNEI4s/7S5Jb6Zx6g16kOlABRRRmgAoo

        ooAKKKKAGMeaUjDjHeiigBNoVTj1pyiiigBaKKKACiiigAooooAKKKKAENNxliDRRQAoG5RmgdaKKAHU

        UUUAFFFFABRRRQAUUUUABpnU0UUAf//Z

</value>

  </data>

</root>

using System.Reflection;

using System.Runtime.CompilerServices;

using System.Runtime.InteropServices;

using System.Security;

// 어셈블리에 대한 일반 정보는 다음 특성 집합을 통해 

// 제어됩니다. 어셈블리와 관련된 정보를 수정하려면

// 이러한 특성 값을 변경하세요.

[assembly: AssemblyTitle("ID2ManagerImport")]

[assembly: AssemblyDescription("")]

[assembly: AssemblyConfiguration("")]

[assembly: AssemblyCompany("")]

[assembly: AssemblyProduct("ID2ManagerImport")]

[assembly: AssemblyCopyright("Copyright ©  2023")]

[assembly: AssemblyTrademark("")]

[assembly: AssemblyCulture("")]

// ComVisible을 false로 설정하면 이 어셈블리의 형식이 COM 구성 요소에 

// 표시되지 않습니다.  COM에서 이 어셈블리의 형식에 액세스하려면 

// 해당 형식에 대해 ComVisible 특성을 true로 설정하세요.

[assembly: ComVisible(false)]

// 이 프로젝트가 COM에 노출되는 경우 다음 GUID는 typelib의 ID를 나타냅니다.

[assembly: Guid("c76dfd44-a403-4555-afa5-c2c517f1b794")]

// 어셈블리의 버전 정보는 다음 네 가지 값으로 구성됩니다.

//

//      주 버전

//      부 버전 

//      빌드 번호

//      수정 버전

//

// 모든 값을 지정하거나 아래와 같이 '*'를 사용하여 빌드 번호 및 수정 번호가 자동으로 

// 지정되도록 할 수 있습니다.

// [assembly: AssemblyVersion("1.0.*")]

[assembly: AssemblyVersion("1.0.0.0")]

[assembly: AssemblyFileVersion("1.0.0.0")]

//------------------------------------------------------------------------------

// <auto-generated>

//     This code was generated by a tool.

//     Runtime Version:4.0.30319.42000

//

//     Changes to this file may cause incorrect behavior and will be lost if

//     the code is regenerated.

// </auto-generated>

//------------------------------------------------------------------------------

namespace ID2ManagerImport.Properties {

    /// <summary>

    ///   A strongly-typed resource class, for looking up localized strings, etc.

    /// </summary>

    // This class was auto-generated by the StronglyTypedResourceBuilder

    // class via a tool like ResGen or Visual Studio.

    // To add or remove a member, edit your .ResX file then rerun ResGen

    // with the /str option, or rebuild your VS project.

    [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

    [global::System.Runtime.CompilerServices.CompilerGeneratedAttribute()]

    internal class Resources {

        private static global::System.Resources.ResourceManager resourceMan;

        private static global::System.Globalization.CultureInfo resourceCulture;

        [global::System.Diagnostics.CodeAnalysis.SuppressMessageAttribute("Microsoft.Performance", "CA1811:AvoidUncalledPrivateCode")]

        internal Resources() {

        }

        /// <summary>

        ///   Returns the cached ResourceManager instance used by this class.

        /// </summary>

        [global::System.ComponentModel.EditorBrowsableAttribute(global::System.ComponentModel.EditorBrowsableState.Advanced)]

        internal static global::System.Resources.ResourceManager ResourceManager {

            get {

                if (object.ReferenceEquals(resourceMan, null)) {

                    global::System.Resources.ResourceManager temp = new global::System.Resources.ResourceManager("ID2ManagerImport.Properties.Resources", typeof(Resources).Assembly);

                    resourceMan = temp;

                }

                return resourceMan;

            }

        }

        /// <summary>

        ///   Overrides the current thread's CurrentUICulture property for all

        ///   resource lookups using this strongly typed resource class.

        /// </summary>

        [global::System.ComponentModel.EditorBrowsableAttribute(global::System.ComponentModel.EditorBrowsableState.Advanced)]

        internal static global::System.Globalization.CultureInfo Culture {

            get {

                return resourceCulture;

            }

            set {

                resourceCulture = value;

            }

        }

    }

}

<?xml version="1.0" encoding="utf-8"?>

<root>

  <!-- 

    Microsoft ResX Schema 

    Version 2.0

    The primary goals of this format is to allow a simple XML format 

    that is mostly human readable. The generation and parsing of the 

    various data types are done through the TypeConverter classes 

    associated with the data types.

    Example:

    ... ado.net/XML headers & schema ...

    <resheader name="resmimetype">text/microsoft-resx</resheader>

    <resheader name="version">2.0</resheader>

    <resheader name="reader">System.Resources.ResXResourceReader, System.Windows.Forms, ...</resheader>

    <resheader name="writer">System.Resources.ResXResourceWriter, System.Windows.Forms, ...</resheader>

    <data name="Name1"><value>this is my long string</value><comment>this is a comment</comment></data>

    <data name="Color1" type="System.Drawing.Color, System.Drawing">Blue</data>

    <data name="Bitmap1" mimetype="application/x-microsoft.net.object.binary.base64">

        <value>[base64 mime encoded serialized .NET Framework object]</value>

    </data>

    <data name="Icon1" type="System.Drawing.Icon, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">

        <value>[base64 mime encoded string representing a byte array form of the .NET Framework object]</value>

        <comment>This is a comment</comment>

    </data>

    There are any number of "resheader" rows that contain simple 

    name/value pairs.

    Each data row contains a name, and value. The row also contains a 

    type or mimetype. Type corresponds to a .NET class that support 

    text/value conversion through the TypeConverter architecture. 

    Classes that don't support this are serialized and stored with the 

    mimetype set.

    The mimetype is used for serialized objects, and tells the 

    ResXResourceReader how to depersist the object. This is currently not 

    extensible. For a given mimetype the value must be set accordingly:

    Note - application/x-microsoft.net.object.binary.base64 is the format 

    that the ResXResourceWriter will generate, however the reader can 

    read any of the formats listed below.

    mimetype: application/x-microsoft.net.object.binary.base64

    value   : The object must be serialized with 

            : System.Serialization.Formatters.Binary.BinaryFormatter

            : and then encoded with base64 encoding.

    mimetype: application/x-microsoft.net.object.soap.base64

    value   : The object must be serialized with 

            : System.Runtime.Serialization.Formatters.Soap.SoapFormatter

            : and then encoded with base64 encoding.

    mimetype: application/x-microsoft.net.object.bytearray.base64

    value   : The object must be serialized into a byte array 

            : using a System.ComponentModel.TypeConverter

            : and then encoded with base64 encoding.

    -->

  <xsd:schema id="root" xmlns="" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">

    <xsd:element name="root" msdata:IsDataSet="true">

      <xsd:complexType>

        <xsd:choice maxOccurs="unbounded">

          <xsd:element name="metadata">

            <xsd:complexType>

              <xsd:sequence>

                <xsd:element name="value" type="xsd:string" minOccurs="0" />

              </xsd:sequence>

              <xsd:attribute name="name" type="xsd:string" />

              <xsd:attribute name="type" type="xsd:string" />

              <xsd:attribute name="mimetype" type="xsd:string" />

            </xsd:complexType>

          </xsd:element>

          <xsd:element name="assembly">

            <xsd:complexType>

              <xsd:attribute name="alias" type="xsd:string" />

              <xsd:attribute name="name" type="xsd:string" />

            </xsd:complexType>

          </xsd:element>

          <xsd:element name="data">

            <xsd:complexType>

              <xsd:sequence>

                <xsd:element name="value" type="xsd:string" minOccurs="0" msdata:Ordinal="1" />

                <xsd:element name="comment" type="xsd:string" minOccurs="0" msdata:Ordinal="2" />

              </xsd:sequence>

              <xsd:attribute name="name" type="xsd:string" msdata:Ordinal="1" />

              <xsd:attribute name="type" type="xsd:string" msdata:Ordinal="3" />

              <xsd:attribute name="mimetype" type="xsd:string" msdata:Ordinal="4" />

            </xsd:complexType>

          </xsd:element>

          <xsd:element name="resheader">

            <xsd:complexType>

              <xsd:sequence>

                <xsd:element name="value" type="xsd:string" minOccurs="0" msdata:Ordinal="1" />

              </xsd:sequence>

              <xsd:attribute name="name" type="xsd:string" use="required" />

            </xsd:complexType>

          </xsd:element>

        </xsd:choice>

      </xsd:complexType>

    </xsd:element>

  </xsd:schema>

  <resheader name="resmimetype">

    <value>text/microsoft-resx</value>

  </resheader>

  <resheader name="version">

    <value>2.0</value>

  </resheader>

  <resheader name="reader">

    <value>System.Resources.ResXResourceReader, System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>

  </resheader>

  <resheader name="writer">

    <value>System.Resources.ResXResourceWriter, System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>

  </resheader>

</root>

//------------------------------------------------------------------------------

// <auto-generated>

//     This code was generated by a tool.

//     Runtime Version:4.0.30319.42000

//

//     Changes to this file may cause incorrect behavior and will be lost if

//     the code is regenerated.

// </auto-generated>

//------------------------------------------------------------------------------

namespace ID2ManagerImport.Properties {

    [global::System.Runtime.CompilerServices.CompilerGeneratedAttribute()]

    [global::System.CodeDom.Compiler.GeneratedCodeAttribute("Microsoft.VisualStudio.Editors.SettingsDesigner.SettingsSingleFileGenerator", "16.0.0.0")]

    internal sealed partial class Settings : global::System.Configuration.ApplicationSettingsBase {

        private static Settings defaultInstance = ((Settings)(global::System.Configuration.ApplicationSettingsBase.Synchronized(new Settings())));

        public static Settings Default {

            get {

                return defaultInstance;

            }

        }

    }

}

<?xml version='1.0' encoding='utf-8'?>

<SettingsFile xmlns="http://schemas.microsoft.com/VisualStudio/2004/01/settings" CurrentProfile="(Default)">

  <Profiles>

    <Profile Name="(Default)" />

  </Profiles>

  <Settings />

</SettingsFile>

//------------------------------------------------------------------------------

// <auto-generated>

//     This code was generated by a tool.

//     Runtime Version:4.0.30319.42000

//

//     Changes to this file may cause incorrect behavior and will be lost if

//     the code is regenerated.

// </auto-generated>

//------------------------------------------------------------------------------

#pragma warning disable 414

namespace ID2ManagerImport {

    /// 

    [Microsoft.VisualStudio.Tools.Applications.Runtime.StartupObjectAttribute(0)]

    [global::System.Security.Permissions.PermissionSetAttribute(global::System.Security.Permissions.SecurityAction.Demand, Name="FullTrust")]

    public sealed partial class ThisAddIn : Microsoft.Office.Tools.AddInBase {

        internal Microsoft.Office.Tools.CustomTaskPaneCollection CustomTaskPanes;

        internal Microsoft.Office.Tools.SmartTagCollection VstoSmartTags;

        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("Microsoft.VisualStudio.Tools.Office.ProgrammingModel.dll", "16.0.0.0")]

        private global::System.Object missing = global::System.Type.Missing;

        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("Microsoft.VisualStudio.Tools.Office.ProgrammingModel.dll", "16.0.0.0")]

        internal Microsoft.Office.Interop.Excel.Application Application;

        /// 

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        [global::System.ComponentModel.EditorBrowsableAttribute(global::System.ComponentModel.EditorBrowsableState.Never)]

        public ThisAddIn(global::Microsoft.Office.Tools.Excel.ApplicationFactory factory, global::System.IServiceProvider serviceProvider) : 

                base(factory, serviceProvider, "AddIn", "ThisAddIn") {

            Globals.Factory = factory;

        }

        /// 

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("Microsoft.VisualStudio.Tools.Office.ProgrammingModel.dll", "16.0.0.0")]

        [global::System.ComponentModel.EditorBrowsableAttribute(global::System.ComponentModel.EditorBrowsableState.Never)]

        protected override void Initialize() {

            base.Initialize();

            this.Application = this.GetHostItem<Microsoft.Office.Interop.Excel.Application>(typeof(Microsoft.Office.Interop.Excel.Application), "Application");

            Globals.ThisAddIn = this;

            global::System.Windows.Forms.Application.EnableVisualStyles();

            this.InitializeCachedData();

            this.InitializeControls();

            this.InitializeComponents();

            this.InitializeData();

        }

        /// 

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("Microsoft.VisualStudio.Tools.Office.ProgrammingModel.dll", "16.0.0.0")]

        [global::System.ComponentModel.EditorBrowsableAttribute(global::System.ComponentModel.EditorBrowsableState.Never)]

        protected override void FinishInitialization() {

            this.InternalStartup();

            this.OnStartup();

        }

        /// 

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("Microsoft.VisualStudio.Tools.Office.ProgrammingModel.dll", "16.0.0.0")]

        [global::System.ComponentModel.EditorBrowsableAttribute(global::System.ComponentModel.EditorBrowsableState.Never)]

        protected override void InitializeDataBindings() {

            this.BeginInitialization();

            this.BindToData();

            this.EndInitialization();

        }

        /// 

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("Microsoft.VisualStudio.Tools.Office.ProgrammingModel.dll", "16.0.0.0")]

        [global::System.ComponentModel.EditorBrowsableAttribute(global::System.ComponentModel.EditorBrowsableState.Never)]

        private void InitializeCachedData() {

            if ((this.DataHost == null)) {

                return;

            }

            if (this.DataHost.IsCacheInitialized) {

                this.DataHost.FillCachedData(this);

            }

        }

        /// 

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("Microsoft.VisualStudio.Tools.Office.ProgrammingModel.dll", "16.0.0.0")]

        [global::System.ComponentModel.EditorBrowsableAttribute(global::System.ComponentModel.EditorBrowsableState.Never)]

        private void InitializeData() {

        }

        /// 

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("Microsoft.VisualStudio.Tools.Office.ProgrammingModel.dll", "16.0.0.0")]

        [global::System.ComponentModel.EditorBrowsableAttribute(global::System.ComponentModel.EditorBrowsableState.Never)]

        private void BindToData() {

        }

        /// 

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        [global::System.ComponentModel.EditorBrowsableAttribute(global::System.ComponentModel.EditorBrowsableState.Advanced)]

        private void StartCaching(string MemberName) {

            this.DataHost.StartCaching(this, MemberName);

        }

        /// 

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        [global::System.ComponentModel.EditorBrowsableAttribute(global::System.ComponentModel.EditorBrowsableState.Advanced)]

        private void StopCaching(string MemberName) {

            this.DataHost.StopCaching(this, MemberName);

        }

        /// 

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        [global::System.ComponentModel.EditorBrowsableAttribute(global::System.ComponentModel.EditorBrowsableState.Advanced)]

        private bool IsCached(string MemberName) {

            return this.DataHost.IsCached(this, MemberName);

        }

        /// 

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("Microsoft.VisualStudio.Tools.Office.ProgrammingModel.dll", "16.0.0.0")]

        [global::System.ComponentModel.EditorBrowsableAttribute(global::System.ComponentModel.EditorBrowsableState.Never)]

        private void BeginInitialization() {

            this.BeginInit();

            this.CustomTaskPanes.BeginInit();

            this.VstoSmartTags.BeginInit();

        }

        /// 

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("Microsoft.VisualStudio.Tools.Office.ProgrammingModel.dll", "16.0.0.0")]

        [global::System.ComponentModel.EditorBrowsableAttribute(global::System.ComponentModel.EditorBrowsableState.Never)]

        private void EndInitialization() {

            this.VstoSmartTags.EndInit();

            this.CustomTaskPanes.EndInit();

            this.EndInit();

        }

        /// 

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("Microsoft.VisualStudio.Tools.Office.ProgrammingModel.dll", "16.0.0.0")]

        [global::System.ComponentModel.EditorBrowsableAttribute(global::System.ComponentModel.EditorBrowsableState.Never)]

        private void InitializeControls() {

            this.CustomTaskPanes = Globals.Factory.CreateCustomTaskPaneCollection(null, null, "CustomTaskPanes", "CustomTaskPanes", this);

            this.VstoSmartTags = Globals.Factory.CreateSmartTagCollection(null, null, "VstoSmartTags", "VstoSmartTags", this);

        }

        /// 

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("Microsoft.VisualStudio.Tools.Office.ProgrammingModel.dll", "16.0.0.0")]

        [global::System.ComponentModel.EditorBrowsableAttribute(global::System.ComponentModel.EditorBrowsableState.Never)]

        private void InitializeComponents() {

        }

        /// 

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        [global::System.ComponentModel.EditorBrowsableAttribute(global::System.ComponentModel.EditorBrowsableState.Advanced)]

        private bool NeedsFill(string MemberName) {

            return this.DataHost.NeedsFill(this, MemberName);

        }

        /// 

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("Microsoft.VisualStudio.Tools.Office.ProgrammingModel.dll", "16.0.0.0")]

        [global::System.ComponentModel.EditorBrowsableAttribute(global::System.ComponentModel.EditorBrowsableState.Never)]

        protected override void OnShutdown() {

            this.VstoSmartTags.Dispose();

            this.CustomTaskPanes.Dispose();

            base.OnShutdown();

        }

    }

    /// 

    [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

    [global::System.CodeDom.Compiler.GeneratedCodeAttribute("Microsoft.VisualStudio.Tools.Office.ProgrammingModel.dll", "16.0.0.0")]

    internal sealed partial class Globals {

        /// 

        private Globals() {

        }

        private static ThisAddIn _ThisAddIn;

        private static global::Microsoft.Office.Tools.Excel.ApplicationFactory _factory;

        private static ThisRibbonCollection _ThisRibbonCollection;