C#??ζ???Excel???沢????????????(??)
???????????? ???????[ 2015/12/14 11:49:20 ] ????????????? Excel
????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??????????????????:
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11