C#实现建立Excel文件，填充数据后保存
C#实现建立Excel文件，填充数据后保存
直接代码，相关注释见下代码：
static void Main(string[] args)
{ string filePath = @"F:\Test\Excel\";
CreateExcel(filePath);
} public static void CreateExcel(string filePath)
{
Excel.Application excel = new Excel.Application(); //EXCEL读写是否可见
excel.Visible = false;
excel.Application.Workbooks.Add();
Excel.Workbook myBook;
Excel.Worksheet mySheet;
myBook = excel.Workbooks[1];
mySheet = (Excel.Worksheet)myBook.ActiveSheet; //页签名
mySheet.Name = "Student";
mySheet.Cells.Select();
mySheet.Cells.NumberFormatLocal = "@";
mySheet.Cells.EntireColumn.AutoFit(); #region 单元格属性以及列名,列名属性 //字体选择
mySheet.Cells.Font.Name = "Ink Free";// Arial //字号大小
mySheet.Cells.Font.Size = 9; //表头字体加粗
mySheet.Range["A1", "D1"].Font.Bold = true; //表头颜色
mySheet.Range["A1", "D1"].Interior.ColorIndex = 6; //建立EXCE栏位表头
mySheet.Range["A1"].Value = "USER_NAME";
mySheet.Range["B1"].Value = "USER_ID";
mySheet.Range["C1"].Value = "SEX";
mySheet.Range["D1"].Value = "BIRTHDAY"; #endregion
#region 添加数值 //必须从第2行开始添加数值
for (int rownum = 2; rownum < 5; rownum++)
{
mySheet.Range["A" + rownum.ToString()].Value = "Jane";
mySheet.Range["B" + rownum.ToString()].Value = "202005190" + rownum;
mySheet.Range["C" + rownum.ToString()].Value = "女";
mySheet.Range["D" + rownum.ToString()].Value = "2020051" + rownum;
} #endregion
excel.DisplayAlerts = true;
excel.AlertBeforeOverwriting = true; //保存路径
string path = filePath + DateTime.Now.ToString("yyyyMMdd") + ".xlsx"; //保存Excel
myBook.Close(true, path, null); //退出Excel excel.Quit();
}
注：其中的关于表头颜色选择的代码如下：
mySheet.Range["A1", "D1"].Interior.ColorIndex = 6;
颜色对应值见下图：
本文章为转载内容，我们尊重原作者对文章享有的著作权。如有内容错误或侵权问题，欢迎原作者联系我们进行内容更正或删除文章。
