创建一个Excel文件
/// <param name="filePath">filePath 为Excel保存的路径</param> 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(); }