VSTO
文章平均质量分 78
riverlau
这个作者很懒,什么都没留下…
展开
-
Adding Styles to Excel sheet Range in VSTO
http://blogs.msdn.com/b/krishnab/archive/2008/10/04/disable-all-default-ribbons-in-excel-application.aspxExcel.Style style;style = Globals.ThisWorkbook.Styles.Add("Style1", Type.Missing); style.转载 2012-05-31 10:10:38 · 617 阅读 · 0 评论 -
Troubleshooting in Office at Run Time
http://msdn.microsoft.com/en-us/library/6s0wczt9(v=vs.80).aspx原创 2012-08-23 16:44:38 · 350 阅读 · 0 评论 -
Create your own .pfx file for ClickOnce
http://blogs.msdn.com/b/maximelamure/archive/2007/01/24/create-your-own-pfx-file-for-clickonce.aspxWhen you use ClickOnce to deploy your application with Visual Studio, a .pfx file is automatica转载 2012-08-22 18:10:55 · 693 阅读 · 0 评论 -
ControlNotFoundException in Excel 2010
ErrorMicrosoft.VisualStudio.Tools.Applications.Runtime.ControlNotFoundException: This document might not function as expected because the following control is missing: Sheet8.SolutionFin转载 2012-08-08 10:40:33 · 614 阅读 · 0 评论 -
VSTO Document Level Deployment (Con'd)
http://blogs.msdn.com/b/rjohri/archive/2009/06/29/the-page-you-are-requesting-cannot-be-served-because-of-the-extension-configuration.aspxhttp://blogs.msdn.com/b/keithmg/archive/2010/11/08/wcf-error原创 2012-08-01 17:29:35 · 1485 阅读 · 0 评论 -
loop through column that has value - SpecialCells
Excel.Range a = this.UsedRange[1, 1].EntireColumn.Cells.SpecialCells(Excel.XlCellType.xlCellTypeConstants); foreach (Excel.Range r in a.Cells) { }原创 2012-07-14 12:13:49 · 305 阅读 · 0 评论 -
Conditional row color based on a cell value
http://www.asap-utilities.com/blog/index.php/2005/11/07/conditional-row-color-based-on-a-cell-value/Jeremy (US) asked me a question about coloring based on a cells value:First your product A转载 2012-07-02 17:43:40 · 408 阅读 · 0 评论 -
VSTO - Named Range Control Basic Operation
Add Named Range Microsoft.Office.Tools.Excel.NamedRange AuthorNamedRange = null; Excel.Range AuthorRange = this.Range["E1", "G1"]; // Setting the range name for cells AuthorNamedRange = this.原创 2012-06-26 22:34:22 · 949 阅读 · 0 评论 -
VSTO Check Cell is In Edit Mode or Not
private bool isInCellEditingMode() { bool flag = false; try { app.DisplayAlerts = false; //This will throw an Exception if Excel is in Cell转载 2012-07-06 00:00:28 · 502 阅读 · 0 评论 -
Write data to an Excel Worksheet
http://www.clear-lines.com/blog/post/Write-data-to-an-Excel-worksheet-with-C-fast.aspxThe current project I am working on requires writing large amount of data to Excel worksheets. In this type转载 2012-07-05 23:22:32 · 421 阅读 · 0 评论 -
VSTO Performance (Con'd)
Performance Tuning-ScreenUpdating-Caching Data-use Array + Range instead of dataTable to populate data-Assign value to a range instead of one cell by one cellhttp://blogs.office.co原创 2012-06-03 19:51:45 · 1180 阅读 · 0 评论 -
How to send a keybord shortcut to the Excel.
http://geekswithblogs.net/lszk/archive/2009/09/10/vsto-for-excel-2007-snippets.aspx#4How to send a keybord shortcut to the Excel. Globals.ThisWorkbook.Application.SendKeys("{F10}");转载 2012-06-17 21:56:48 · 437 阅读 · 0 评论 -
Excel Programming in VSTO (book:Visual Studio Tools for Office 2007 VSTO) Note
The Office PIAs (Primary Interop Assemblies) allow .NET code to call the unmanaged object models that Office applications expose. Programming Excel: -Thebasic hierarchy of the E原创 2012-06-03 20:06:53 · 1870 阅读 · 0 评论 -
VSTO SaveCopyAs方法在Excel 2007下必须注意的一个问题
http://www.haogongju.net/art/273841SaveCopyAs是与Excel当前的默认保存设置格式相关的,它不会根据文件名后缀来自动调整保存的格式,也就是说,如果你设置默认存储格式为Excel 97-2003 Workbook(.xls)格式,而SaveCopyAs参数里的文件名是.xlsx的话,其实真正的格式仍然是.xls的,在这种情况下,你用Exce转载 2013-05-22 17:27:26 · 1334 阅读 · 0 评论