Excel组件Spire.XLS 教程：在Excel中设置单元格样式

深藏阁楼爱情的钟 2022-06-08 21:08 604阅读 0赞

**VSTO**

using System;
    using System.Collections.Generic;
    using System.Linq;
    using System.Text;
    using System.Xml.Linq;
    using Excel = Microsoft.Office.Interop.Excel;
    using Office = Microsoft.Office.Core;
    using Microsoft.Office.Tools.Excel;
    using System.Drawing;
    using System.Reflection;
     
    namespace VSTO
    {
        public partial class ThisAddIn
        {
            private void ThisAddIn_Startup(object sender, System.EventArgs e)
            {
                //Open the workbook file
                Excel.Workbook workbook = this.Application.Workbooks.Add();
     
                //Get the active sheet
                Excel.Worksheet sheet = workbook.ActiveSheet;
    
                //Add style of specified range          
                Excel.Style style = workbook.Styles.Add("Style");
                style.Font.Size = 16;
                style.Font.Color = Color.Red;
                style.Interior.Color = Color.Black;
                style.Interior.Pattern = Excel.XlPattern.xlPatternSolid;
                Excel.Range range = sheet.get_Range("A1","A7");
                range.Value = "Spire";
                range.Style = "Style",
     
                //Save the file
                workbook.SaveAs("StyleExcel.xlsx");
            }
     
            private void ThisAddIn_Shutdown(object sender, System.EventArgs e)
            {
            }
     
            #region VSTO generated code
     
            /// <summary>
            /// Required method for Designer support - do not modify
            /// the contents of this method with the code editor.
            /// </summary>
            private void InternalStartup()
            {
                this.Startup += new System.EventHandler(ThisAddIn_Startup);
                this.Shutdown += new System.EventHandler(ThisAddIn_Shutdown);
            }
             
            #endregion
        }
    }

[**Spire.XLS**][Spire.XLS]

using System;
    using System.Collections.Generic;
    using System.Linq;
    using System.Text;
    using System.Threading.Tasks;
    using Spire.Xls;
    using System.Drawing;
     
    namespace Spire.XLS
    {
        class Program
        {
            static void Main(string[] args)
            {
                //Initialize a new instance of workbook
                Workbook workbook = new Workbook();
     
                //Get the first worksheet
                Worksheet sheet = workbook.Worksheets[0];
                 
                //Add style of specified range
                CellStyle style=workbook.Styles.Add("Style");
                CellRange range = sheet.Range["A1:A7"];
                range.Text = "Spire";
                range.Style.Font.Size = 16;
                range.Style.Font.Color = Color.Red;
                range.Style.Interior.Color = Color.Black;
                range.Style.Interior.FillPattern = ExcelPatternType.Solid;
     
                //Save and Launch
                workbook.SaveToFile("StyleExcel.xlsx", ExcelVersion.Version2010);
                System.Diagnostics.Process.Start("StyleExcel.xlsx")
     
            }
        }
    }

[点击下载Spire.XLS][Spire.XLS 1]

[慧都控件网][Link 1]

--------------------

[Spire.XLS]: https://www.evget.com/product/3371
[Spire.XLS 1]: https://www.evget.com/product/3371/download
[Link 1]: https://www.evget.com/article/2017/8/29/26806.html