????Excel?????????????????????????????????????и????????????????????????????????????????????????????????????????(????Excel??????????????????????)??.NET???????Excel Add-In??Excel???й??????????Щ??????????????????????????????UI??????????????????????
????? ?????Excel???????
????1 VBA
????VBA?????Visual Basic???????????????Office????????????????????VBA??VB????????????Visual Basic?????VBA???????????????????????????????????????????????????????????????VBA?????????????
????2 Excel Addin
????Excel Addin????Visual Studio???????????????????Щ?????Office?????Щ???????VBA???Щ?????Щ??????????????????? VisualBasic????VisualC++???????????Office???Щdll???????Office???п??????????????dll????com?? ????????????????????????????????Excel??????????Щ?????
????3 VSTO (Visual Studio Tools for Office)
????VSTO??????Office???Щdll??????.NET??????????????????.NET???????????????Office???Щ???????е??á??? ???Office??????????????μ????????????????????????????????????????????????????Office?????? ?????????????ú??????VSTO????????????????????????Office??ó?????????????.NET??????????????????????.NET??????????????н??????????????Office?????????????
????4 XLL
????XLL??Excel??????????ó????????C??C++?????????????????Excel?????C??????????????????????????????ó???Ч????????????????????????????????????Excel-DNA?????XLL??????????????????.NET ???????????????RTD?????????????UDF???????д???????
????5 OpenXML
????????????а??Excel??ó??????????????????????????Excel???????????????????????????????Excel?????????????￡???????Excel??????и???????????????????????OpenXML??NPOI??????????????дExcel???????????????汾??
?????? ???Excel Add-In???????
????????????: ???????Windows Server 2008R2 x64;Excel?Excel 2010 x64;?????????Visual Studio 2012????x64;??????SQL Server 2008R2 x64.
????1 ?????
??????Visual Studio 2012??????ExcelAddInDemo??Excel Add-In????????????????????????????:

???????У?RibbonAddIn???????2010??UI??壬SqlHelper.cs??????????????????????UClog.cs??UCPaneLeft.cs??UCTaskGrid.cs??UCTaskPane.cs?????????????????????????????EXCEL??????.?????????????????:

????????????????Excel??????????ID??First??Last??Email???(?????????????????)??????????б?????????水???????????浽???????.
????2 RibbonAddIn???
???????????RibbonAddIn.cs??Excel??Ribbon???????????CUMT????.RibbonAddIn???????????????????????????????????.RibbonAddIn.cs??????????????????: