C# Excel 单元格内部某段字节设置格式

示例一

Dim a, b As Integer
a=len(text1.text)
b=len(text2.text)
xlSheet.Range(Cells(1, 2)).Characters(5, a).Font.Underline = xlUnderlineStyleSingle
xlSheet.Range(Cells(1, 2)).Characters(5+a+5, b).Font.Underline = xlUnderlineStyleSingle

 

实例二

        /// <summary>
        /// 生成申请书清单
        /// </summary>
        /// <param name="dataSet"></param>
        /// <param name="filePath"></param>
        public void exportExcel(string filePath)
        {
            DataSet dataSet = new DataSet();
            DataTable dataTable = new DataTable();
            dataTable.Columns.Add("指南编号", typeof(string));
            dataTable.Columns.Add("课题名称", typeof(string));
            dataTable.Columns.Add("申请人", typeof(string));
            dataTable.Columns.Add("申请经费（万元）", typeof(string));
            dataTable.Columns.Add("密级", typeof(string));
            dataTable.Columns.Add("课题组联系方式", typeof(string));
            dataTable.Columns.Add("Email", typeof(string));
            DataRow dr = dataTable.NewRow();
            dr["指南编号"] = this.ptcGuideNum.Text;
            dr["课题名称"] = this.ptcTopicName.Text;
            dr["申请人"] = this.ptcApplicant.Text;
            dr["申请经费（万元）"] = this.ptcDirectMoney28.Text;
            dr["密级"] = this.ptcFragmentLevel.Text;
            dr["课题组联系方式"] = "联系电话：" + this.telephonePtc.Text + "\n手机：" + this.userMobilePtc.Text;
            dr["Email"] = this.ptcEmail.Text;
            dataTable.Rows.Add(dr);
            dataSet.Tables.Add(dataTable);
            if (dataSet.Tables.Count == 0)
            {

                throw new Exception("DataSet中没有任何可导出的表。");
            }
            //创建application对象
            Microsoft.Office.Interop.Excel.Application excelApplication = new Microsoft.Office.Interop.Excel.Application();
            excelApplication.DisplayAlerts = false;
            object m_objOpt = System.Reflection.Missing.Value;
            //打开excel对象
            Microsoft.Office.Interop.Excel.Workbook workbook = excelApplication.Workbooks.Open(filePath, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt);
            //获取excel的sheet集
            Microsoft.Office.Interop.Excel.Sheets m_objSheets = null;
            m_objSheets = (Microsoft.Office.Interop.Excel.Sheets)workbook.Worksheets;
            //Microsoft.Office.Interop.Excel.Workbook workbook = excelApplication.Workbooks.Add(Missing.Value);
            int i = 0;
            foreach (DataTable dt in dataSet.Tables)
            {
                i++;
                //Microsoft.Office.Interop.Excel.Worksheet lastWorksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Worksheets.get_Item(workbook.Worksheets.Count);
                //Microsoft.Office.Interop.Excel.Worksheet lastWorksheet = (Microsoft.Office.Interop.Excel.Worksheet)(m_objSheets.get_Item(i));
                Microsoft.Office.Interop.Excel.Worksheet newSheet = (Microsoft.Office.Interop.Excel.Worksheet)(m_objSheets.get_Item(1));
                //lastWorksheet.Name = dt.TableName;
                //表头的导出
                //for (int col = 0; col < dt.Columns.Count; col++)
                //{
                //    newSheet.Cells[1, col + 1] = dt.Columns[col].ColumnName;
                //}
                Microsoft.Office.Interop.Excel.Range range1;

                string unitname = "  " + this.ptcRelyingUnit.Text + "  ";
                //列的导出
                newSheet.Cells[1, 1] = unitname + "242计划申报课题清单";
                range1 = newSheet.get_Range("A1");
                range1.get_Characters(0, unitname.Length).Font.Underline = true;
                newSheet.Cells[2, 1] = "（" + this.ptcApplicationDateYear.Text + "年" + this.ptcApplicationDateMonth.Text + "月" + this.ptcApplicationDateDay.Text + "日）";
                for (int row = 0; row < dt.Rows.Count; row++)
                {
                    for (int col = 0; col < dt.Columns.Count; col++)
                    {
                        newSheet.Cells[row + 5, col + 1] = dt.Rows[row][col].ToString();
                    }
                }
            }
            try
            {
                workbook.Close(true, filePath, System.Reflection.Missing.Value);
            }
            catch (Exception e)
            {
                throw e;
            }
            excelApplication.Quit();
        }