110,533
社区成员
发帖
与我相关
我的任务
分享
#region 结束进程
/// <summary>
/// 结束进程
/// FindAndKillProcessByName
/// </summary>
/// <param name="name"></param>
private void FindAndKillProcessByName(string name)
{
foreach (Process winProc in Process.GetProcessesByName(name))
{
if (winProc.ProcessName.Equals(name))
{
winProc.Kill();
}
}
}
#endregion
/// <summary>
/// Excel模板
/// DemoXls
/// </summary>
/// <returns></returns>
private void DemoXls()
{
string pp = "C:\\我的文档";
if (!Directory.Exists(pp))
{
Directory.CreateDirectory(pp);
}
pp = pp + "\\" + "Example.xls";
try
{
FindAndKillProcessByName("EXCEL"); //结束excel进程
FindAndKillProcessByName("et"); //结束wps进程
Thread.Sleep(1000); //写入excel延时
FileStream fs = new FileStream(pp, FileMode.Append);
StreamWriter fsw = new StreamWriter(fs, Encoding.GetEncoding("GB2312"));
fsw.WriteLine("-----------------------------------------------------------------------------");
string firstrow = "";
for(int i = 0; i < 10; i++)
{
firstrow = "列标题" + i + "\t"; //\t换一列
}
fsw.WriteLine(firstrow); //写入一行
fsw.WriteLine("内容1" + "\t" + "内容2" + "\t……");
fsw.WriteLine(); //空一行
fsw.Close();
fs.Close();
}
catch (System.Exception ex)
{
System.Windows.MessageBox.Show(ex.ToString());
}
}