C# 操作 Excel 儲存格格式設定

C# 操作 Excel 儲存格自動填滿，置中對齊，字型顏色設定

 

 //設定標題Excel.Range titleRange = worksheet.get_Range(worksheet.Cells[1, 1], worksheet.Cells[1, columnCount]);//選取儲存格，選取一行或多行titleRange.Merge(true);//合併儲存格titleRange.Value2 = strTitle; //設定儲存格內文本titleRange.Font.Name = "宋體";//設定字型titleRange.Font.Size = 18;//字型大小titleRange.Font.Bold = true;//加粗顯示titleRange.HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter;//水平置中titleRange.VerticalAlignment = Excel.XlVAlign.xlVAlignCenter;//垂直置中titleRange.Borders.LineStyle = Excel.XlLineStyle.xlContinuous;//設定邊框titleRange.Borders.Weight = Excel.XlBorderWeight.xlMedium;//邊框常規粗細

 

 

參考:http://blog.csdn.net/zhaobisha/article/details/3862568