Adding Styles to Excel sheet Range in VSTO

转载于 2012-05-31 10:10:38 发布 · 664 阅读

文章标签：

#styles #excel #object

VSTO 专栏收录该内容

13 篇文章

订阅专栏

本文介绍如何通过VBA代码在Excel中创建并应用一种新的样式。该样式包括Calibri字体、字号11、边框连续线型以及水平垂直居中对齐等属性。

http://blogs.msdn.com/b/krishnab/archive/2008/10/04/disable-all-default-ribbons-in-excel-application.aspx

Excel.Style style;

style = Globals.ThisWorkbook.Styles.Add("Style1", Type.Missing);

 style.Font.Name = "Calibri";

style.Font.Size = 11;

style.NumberFormat = "General";

style.Borders[(Excel.XlBordersIndex)Excel.Constants.xlTop].LineStyle = Excel.XlLineStyle.xlContinuous;

style.Borders[(Excel.XlBordersIndex)Excel.Constants.xlBottom].LineStyle = Excel.XlLineStyle.xlContinuous;

style.Borders[(Excel.XlBordersIndex)Excel.Constants.xlLeft].LineStyle = Excel.XlLineStyle.xlContinuous;

style.Borders[(Excel.XlBordersIndex)Excel.Constants.xlRight].LineStyle = Excel.XlLineStyle.xlContinuous;

style.HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter;

style.VerticalAlignment = Excel.XlVAlign.xlVAlignCenter;

Set this style object to Excel Range instance

excelRange.Style = style;