VSTO 两个实例

上传者: mason_mow | 上传时间: 2021-09-17 22:48:39 | 文件大小: 457KB | 文件类型: ZIP
实验环境:VS2013+Office2013。所用语言C# 两个VSTO开发实例 Task1——行求和,然后画出曲线图 随机生成100行100列个数,每个数位为0~9的整数,然后求每行的和,最后调用Chart,画出线状图。 Task2——求TFIDF值。 对于一个workbook有10个sheet,每个sheet随机产生100行*100列共10000个单词words,然后计算每个单词在每个文档的TFIDF值。 方便期间,我用100个数字(0~99)来代表不同的单词word,也就是为每个sheet随机了10000个数。 程序运行流程: 1.单击ActionsPane中的randData按钮,给每个sheet随机产生words(i.e.,0~99), 2.单机ActionsPane中calcTFIDF按钮,计算每个word在每个文档sheet的TFIDF值,结果输出值文件“E:\\resultFilename.txt"文件中。 结果文件说明:文件共100行,10列。 行代表100个words(0~99),列代表10个文档sheet。 第i行第j列表示的就是word (i-1) 在文档 j 中的TFIDF值。 由于随机的数都在每个sheet趋于均匀分布,算出的TFIDF值也很接近。算TFIDF的公式有几个变种(参考wikipedia),自己用了最简单的。

文件下载

资源详情

[{"title":"( 96 个子文件 457KB ) VSTO 两个实例","children":[{"title":"ExcelTask2","children":[{"title":"ExcelTask2","children":[{"title":"ExcelTask2.xlsx <span style='color:#111;'> 12.35KB </span>","children":null,"spread":false},{"title":"Sheet9.Designer.xml <span style='color:#111;'> 390B </span>","children":null,"spread":false},{"title":"Sheet9.Designer.cs <span style='color:#111;'> 8.03KB </span>","children":null,"spread":false},{"title":"Sheet10.Designer.xml <span style='color:#111;'> 394B </span>","children":null,"spread":false},{"title":"Sheet8.Designer.cs <span style='color:#111;'> 8.03KB </span>","children":null,"spread":false},{"title":"Sheet2.Designer.cs <span style='color:#111;'> 8.03KB </span>","children":null,"spread":false},{"title":"Sheet7.Designer.xml <span style='color:#111;'> 390B </span>","children":null,"spread":false},{"title":"Sheet2.cs <span style='color:#111;'> 1.03KB </span>","children":null,"spread":false},{"title":"Sheet10.cs <span style='color:#111;'> 1.04KB </span>","children":null,"spread":false},{"title":"ThisWorkbook.cs <span style='color:#111;'> 5.75KB </span>","children":null,"spread":false},{"title":"Sheet5.Designer.cs <span style='color:#111;'> 8.03KB </span>","children":null,"spread":false},{"title":"ThisWorkbook.Designer.xml <span style='color:#111;'> 899B </span>","children":null,"spread":false},{"title":"Sheet1.cs <span style='color:#111;'> 1.03KB </span>","children":null,"spread":false},{"title":"Sheet6.cs <span style='color:#111;'> 1.03KB </span>","children":null,"spread":false},{"title":"Sheet6.Designer.xml <span style='color:#111;'> 390B </span>","children":null,"spread":false},{"title":"ThisWorkbook.Designer.cs <span style='color:#111;'> 10.91KB </span>","children":null,"spread":false},{"title":"ExcelTask2_TemporaryKey.pfx <span style='color:#111;'> 1.61KB </span>","children":null,"spread":false},{"title":"Sheet4.Designer.xml <span style='color:#111;'> 390B </span>","children":null,"spread":false},{"title":"Sheet4.Designer.cs <span style='color:#111;'> 8.03KB </span>","children":null,"spread":false},{"title":"Sheet8.cs <span style='color:#111;'> 1.03KB </span>","children":null,"spread":false},{"title":"Properties","children":[{"title":"Settings.settings <span style='color:#111;'> 249B </span>","children":null,"spread":false},{"title":"Resources.Designer.cs <span style='color:#111;'> 2.64KB </span>","children":null,"spread":false},{"title":"AssemblyInfo.cs <span style='color:#111;'> 1.36KB </span>","children":null,"spread":false},{"title":"Settings.Designer.cs <span style='color:#111;'> 1.07KB </span>","children":null,"spread":false},{"title":"Resources.resx <span style='color:#111;'> 5.48KB </span>","children":null,"spread":false}],"spread":false},{"title":"Sheet6.Designer.cs <span style='color:#111;'> 8.03KB </span>","children":null,"spread":false},{"title":"Sheet3.Designer.xml <span style='color:#111;'> 390B </span>","children":null,"spread":false},{"title":"Sheet4.cs <span style='color:#111;'> 1.03KB </span>","children":null,"spread":false},{"title":"Sheet5.Designer.xml <span style='color:#111;'> 390B </span>","children":null,"spread":false},{"title":"Sheet10.Designer.cs <span style='color:#111;'> 8.04KB </span>","children":null,"spread":false},{"title":"Sheet7.Designer.cs <span style='color:#111;'> 8.03KB </span>","children":null,"spread":false},{"title":"Sheet3.Designer.cs <span style='color:#111;'> 8.03KB </span>","children":null,"spread":false},{"title":"Sheet1.Designer.xml <span style='color:#111;'> 390B </span>","children":null,"spread":false},{"title":"ExcelTask2.csproj <span style='color:#111;'> 13.80KB </span>","children":null,"spread":false},{"title":"Sheet9.cs <span style='color:#111;'> 1.03KB </span>","children":null,"spread":false},{"title":"Sheet8.Designer.xml <span style='color:#111;'> 390B </span>","children":null,"spread":false},{"title":"obj","children":[{"title":"Debug","children":[{"title":"ExcelTask2.dll <span style='color:#111;'> 27.50KB </span>","children":null,"spread":false},{"title":"TempPE","children":null,"spread":false},{"title":"ExcelTask2.Properties.Resources.resources <span style='color:#111;'> 180B </span>","children":null,"spread":false},{"title":"ExcelTask2.csproj.GenerateResource.Cache <span style='color:#111;'> 919B </span>","children":null,"spread":false},{"title":"ExcelTask2.csproj.FileListAbsolute.txt <span style='color:#111;'> 1.04KB </span>","children":null,"spread":false},{"title":"DesignTimeResolveAssemblyReferencesInput.cache <span style='color:#111;'> 8.73KB </span>","children":null,"spread":false},{"title":"TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs <span style='color:#111;'> 0B </span>","children":null,"spread":false},{"title":"TemporaryGeneratedFile_E7A71F73-0F8D-4B9B-B56E-8E70B10BC5D3.cs <span style='color:#111;'> 0B </span>","children":null,"spread":false},{"title":"TemporaryGeneratedFile_5937a670-0e60-4077-877b-f7221da3dda1.cs <span style='color:#111;'> 0B </span>","children":null,"spread":false},{"title":"ExcelTask2.pdb <span style='color:#111;'> 113.50KB </span>","children":null,"spread":false}],"spread":false}],"spread":false},{"title":"Sheet1.Designer.cs <span style='color:#111;'> 8.03KB </span>","children":null,"spread":false},{"title":"Sheet2.Designer.xml <span style='color:#111;'> 390B </span>","children":null,"spread":false},{"title":"bin","children":[{"title":"Debug","children":[{"title":"ExcelTask2.xlsx <span style='color:#111;'> 14.22KB </span>","children":null,"spread":false},{"title":"ExcelTask2.dll <span style='color:#111;'> 27.50KB </span>","children":null,"spread":false},{"title":"ExcelTask2.dll.manifest <span style='color:#111;'> 12.89KB </span>","children":null,"spread":false},{"title":"Microsoft.Office.Tools.Common.v4.0.Utilities.dll <span style='color:#111;'> 31.90KB </span>","children":null,"spread":false},{"title":"ExcelTask2.vsto <span style='color:#111;'> 5.38KB </span>","children":null,"spread":false},{"title":"Microsoft.Office.Tools.Common.v4.0.Utilities.xml <span style='color:#111;'> 19.01KB </span>","children":null,"spread":false},{"title":"Microsoft.Office.Tools.Excel.v4.0.Utilities.dll <span style='color:#111;'> 231.40KB </span>","children":null,"spread":false},{"title":"Microsoft.Office.Tools.Excel.v4.0.Utilities.xml <span style='color:#111;'> 697.17KB </span>","children":null,"spread":false},{"title":"ExcelTask2.pdb <span style='color:#111;'> 113.50KB </span>","children":null,"spread":false}],"spread":false}],"spread":false},{"title":"Sheet7.cs <span style='color:#111;'> 1.03KB </span>","children":null,"spread":false},{"title":"Sheet5.cs <span style='color:#111;'> 1.03KB </span>","children":null,"spread":false},{"title":"Sheet3.cs <span style='color:#111;'> 1.03KB </span>","children":null,"spread":false}],"spread":false},{"title":"ExcelTask2.sln <span style='color:#111;'> 999B </span>","children":null,"spread":false},{"title":"ExcelTask2.v12.suo <span style='color:#111;'> 44.00KB </span>","children":null,"spread":false}],"spread":true},{"title":"ReadMe.txt <span style='color:#111;'> 1.21KB </span>","children":null,"spread":false},{"title":"ExcelTask1","children":[{"title":"ExcelTask1.sln <span style='color:#111;'> 999B </span>","children":null,"spread":false},{"title":"ExcelTask1","children":[{"title":"ExcelTask1.xlsx <span style='color:#111;'> 8.21KB </span>","children":null,"spread":false},{"title":"ThisWorkbook.cs <span style='color:#111;'> 1.06KB </span>","children":null,"spread":false},{"title":"ThisWorkbook.Designer.xml <span style='color:#111;'> 899B </span>","children":null,"spread":false},{"title":"Sheet1.cs <span style='color:#111;'> 3.25KB </span>","children":null,"spread":false},{"title":"ThisWorkbook.Designer.cs <span style='color:#111;'> 10.91KB </span>","children":null,"spread":false},{"title":"Properties","children":[{"title":"Settings.settings <span style='color:#111;'> 249B </span>","children":null,"spread":false},{"title":"Resources.Designer.cs <span style='color:#111;'> 2.64KB </span>","children":null,"spread":false},{"title":"AssemblyInfo.cs <span style='color:#111;'> 1.36KB </span>","children":null,"spread":false},{"title":"Settings.Designer.cs <span style='color:#111;'> 1.07KB </span>","children":null,"spread":false},{"title":"Resources.resx <span style='color:#111;'> 5.48KB </span>","children":null,"spread":false}],"spread":true},{"title":"Sheet1.Designer.xml <span style='color:#111;'> 390B </span>","children":null,"spread":false},{"title":"ExcelTask1_TemporaryKey.pfx <span style='color:#111;'> 1.61KB </span>","children":null,"spread":false},{"title":"obj","children":[{"title":"Debug","children":[{"title":"ExcelTask1.Properties.Resources.resources <span style='color:#111;'> 180B </span>","children":null,"spread":false},{"title":"ExcelTask1.csproj.FileListAbsolute.txt <span style='color:#111;'> 1.04KB </span>","children":null,"spread":false},{"title":"ExcelTask1.csproj.GenerateResource.Cache <span style='color:#111;'> 919B </span>","children":null,"spread":false},{"title":"TempPE","children":null,"spread":false},{"title":"ExcelTask1.dll <span style='color:#111;'> 16.50KB </span>","children":null,"spread":false},{"title":"DesignTimeResolveAssemblyReferencesInput.cache <span style='color:#111;'> 8.15KB </span>","children":null,"spread":false},{"title":"ExcelTask1.pdb <span style='color:#111;'> 35.50KB </span>","children":null,"spread":false},{"title":"TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs <span style='color:#111;'> 0B </span>","children":null,"spread":false},{"title":"TemporaryGeneratedFile_E7A71F73-0F8D-4B9B-B56E-8E70B10BC5D3.cs <span style='color:#111;'> 0B </span>","children":null,"spread":false},{"title":"TemporaryGeneratedFile_5937a670-0e60-4077-877b-f7221da3dda1.cs <span style='color:#111;'> 0B </span>","children":null,"spread":false}],"spread":false}],"spread":true},{"title":"ExcelTask1.csproj <span style='color:#111;'> 9.19KB </span>","children":null,"spread":false},{"title":"Sheet1.Designer.cs <span style='color:#111;'> 8.03KB </span>","children":null,"spread":false},{"title":"bin","children":[{"title":"Debug","children":[{"title":"ExcelTask1.xlsx <span style='color:#111;'> 10.09KB </span>","children":null,"spread":false},{"title":"ExcelTask1.dll <span style='color:#111;'> 16.50KB </span>","children":null,"spread":false},{"title":"ExcelTask1.vsto <span style='color:#111;'> 5.38KB </span>","children":null,"spread":false},{"title":"Microsoft.Office.Tools.Common.v4.0.Utilities.dll <span style='color:#111;'> 31.90KB </span>","children":null,"spread":false},{"title":"ExcelTask1.pdb <span style='color:#111;'> 35.50KB </span>","children":null,"spread":false},{"title":"ExcelTask1.dll.manifest <span style='color:#111;'> 11.12KB </span>","children":null,"spread":false},{"title":"Microsoft.Office.Tools.Common.v4.0.Utilities.xml <span style='color:#111;'> 19.01KB </span>","children":null,"spread":false},{"title":"Microsoft.Office.Tools.Excel.v4.0.Utilities.dll <span style='color:#111;'> 231.40KB </span>","children":null,"spread":false},{"title":"Microsoft.Office.Tools.Excel.v4.0.Utilities.xml <span style='color:#111;'> 697.17KB </span>","children":null,"spread":false}],"spread":false}],"spread":false}],"spread":false},{"title":"ExcelTask1.v12.suo <span style='color:#111;'> 43.50KB </span>","children":null,"spread":false}],"spread":true}],"spread":true}]

评论信息

  • u012325112 :
    新手可以用的,哈哈
    2018-01-11
  • ayouxinping :
    还不知道如何,下下来看看,现在csdn真的很烂,下了一次就不允许下第二次了,为什么?
    2017-12-17
  • lazy_one :
    适合新手学习.
    2016-11-03
  • hero3108 :
    vsto本身不好用。很无奈
    2016-09-13
  • u011808175 :
    对初步学习VSTO很有帮助!
    2015-08-02

免责申明

【只为小站】的资源来自网友分享,仅供学习研究,请务必在下载后24小时内给予删除,不得用于其他任何用途,否则后果自负。基于互联网的特殊性,【只为小站】 无法对用户传输的作品、信息、内容的权属或合法性、合规性、真实性、科学性、完整权、有效性等进行实质审查;无论 【只为小站】 经营者是否已进行审查,用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。
本站所有资源不代表本站的观点或立场,基于网友分享,根据中国法律《信息网络传播权保护条例》第二十二条之规定,若资源存在侵权或相关问题请联系本站客服人员,zhiweidada#qq.com,请把#换成@,本站将给予最大的支持与配合,做到及时反馈和处理。关于更多版权及免责申明参见 版权及免责申明