本案例用到的库为:Microsoft.Office.Interop.Excel.dll
#region
[DllImport(“user32.dll”, SetLastError = true)]
static extern int GetWindowThreadProcessId(IntPtr hwnd, out int processid);//用于结束Excel进程,防止进程占用导致异常
///
/// Excel模板生成
///
public static void NewExcel()
{
try
{
Excel.Application xapp = new Excel.Application();
string filepath = 模板地址;
Excel.Workbook xbook = xapp.Workbooks._Open(filepath, Missing.Value, Missing.Value,
Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value,
Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
xapp.DisplayAlerts = false;//自动覆盖
Excel.Worksheet xsheet = (Excel.Worksheet)xbook.Sheets[1];
#region Excel数据源
Excel.Range rng = xsheet.get_Range(“M15”, Missing.Value);//M15对应着Excel模板中单元格
rng.Value2 = DateTime.Now.ToString(“yyyy-MM-dd”);//将数据填写至相对应的位置
Excel.Range rng2 = xsheet.get_Range(“B3”, Missing.Value);
rng2.Value2 = “数据内容”;
#endregion
StringBuilder LogPath = new StringBuilder();
LogPath.Append(AppDomain.CurrentDomain.BaseDirectory + @“binNewExcel”);
//检查上传的物理路径是否存在日志类型,不存在则创建
if (!Directory.Exists(LogPath.ToString()))
{
Directory.CreateDirectory(LogPath.ToString());
}
LogPath.Append("\Excel报表" + DateTime.Now.ToString(“yyyy-MM-dd”) + “.xlsx”);//Excel物理路径
xbook.SaveCopyAs(LogPath.ToString());
#region 结束Excel的内容
IntPtr t = new IntPtr(xapp.Hwnd);
int k = 0;
GetWindowThreadProcessId(t, out k);
System.Diagnostics.Process p = System.Diagnostics.Process.GetProcessById(k);
p.Kill();
#endregion
}
catch (Exception ex)
{
}
}
#endregion