做导出Excel时导出成功后会遇到一个问题就是如何杀死Excel进程，用GC.Collect()回收不了，找了个杀死进程的方法。这个方法是强行将电脑中的所有Excel进程杀死。缺点是如果电脑中本来有打开的Excle文档，当使用导出Excel后调用此方法杀死进程就会将原来开着的Excel文档强行关闭。

        private void KillProcess(string processName)
        {
            System.Diagnostics.Process myproc = new System.Diagnostics.Process();
            //得到所有打开的进程
            try
            {
                foreach (Process thisproc in Process.GetProcessesByName(processName))
                {
                    if (!thisproc.CloseMainWindow())
                    {
                        thisproc.Kill();
                    }
                }
            }
            catch (Exception Exc)
            {
                Page.RegisterStartupScript(“Error”,”<script>alert(‘杀死进程失败！\n’”+Exc.Message+”);</script>”);
            }
        }

            通过KillProcess(“Excel”);调用。同样如果要杀死Word进程只需将Excel替换成Word即可

            添加引用：using Excel = Microsoft.Office.Interop.Excel;
                          using Microsoft.Office.Interop.Excel;

            Excel.Application application = new Excel.Application();
            Excel.Workbook book = application.Workbooks.Add(true);
            Excel.Worksheet sheet = book.ActiveSheet as Excel.Worksheet;

            Excel.Range range1 = sheet.get_Range(sheet.Cells[1, 1], sheet.Cells[2, 1]) as Excel.Range;//合并一列两行
            range1.Merge(0);
            range1.Value2 = “Test1″;

            Excel.Range range2 = sheet.get_Range(sheet.Cells[1, 2], sheet.Cells[1, 3]) as Excel.Range;//合并一行两列
            range2.Merge(true);
            range2.Columns.ColumnWidth = 20;
            range2.HorizontalAlignment = XlVAlign.xlVAlignCenter;    //居中
            range2.Value2 = “Test2″;

            Excel.Range range3 = sheet.Cells[2, 2] as Excel.Range;
            range3.Merge(true);
            range3.Value2 = “Test1″;

            Excel.Range range4 = sheet.Cells[2, 3] as Excel.Range;
            range4.Merge(true);
            range4.Value2 = “Test2″;
            string fileName = Guid.NewGuid().ToString() + “.xls”;
            string pathFileName = HttpContext.Current.Server.MapPath(fileName);
            book.SaveAs(pathFileName, XlFileFormat.xlWorkbookNormal, Type.Missing, Type.Missing, Type.Missing, Type.Missing, XlSaveAsAccessMode.xlNoChange, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
            book.Close(Type.Missing, Type.Missing, Type.Missing);
            application.Quit();
            System.Runtime.InteropServices.Marshal.ReleaseComObject(book);
            System.Runtime.InteropServices.Marshal.ReleaseComObject(application);
            System.Runtime.InteropServices.Marshal.ReleaseComObject(sheet);
            book = null;
            application = null;
            sheet = null;
            GC.Collect();

            HttpResponse response = HttpContext.Current.Response;
            string fileName1 = HttpContext.Current.Server.UrlEncode(“test.xls”);
            response.AppendHeader(“Content-Disposition”, “attachment; filename=” + fileName1);
            response.Charset = “UTF-8″;
            response.ContentEncoding = System.Text.Encoding.Default;
            response.ContentType = “application/ms-excel”;

            response.Clear();
            response.WriteFile(pathFileName);
            response.End();

效果图

这个问题一般是由于iis与.NET Framework的安装顺序引起的。iis在.NET Framework之后安装会出现此错误。

解决：打开Visual Studio 命令提示（一般会在开始菜单中Visual Studio Tools中），然后运行aspnet_regiis -i然后重启一下IIS，看看好用不，

如果问题没有解决则在Visual Studio 命令提示中运行aspnet_regiis -ua卸载掉电脑中的.NET Framework程序，然后在上网下一个.NET Framework装上。这样一般就能搞定

(1) Helper扩展
public ActionResult HtmlHelper()
{
this.ViewData["Name"] = “Fanxinfu”;
var employees = new List<object>
{
new {ID = 1,Name = “xiao fu”},
new {ID = 2,Name = “zhanshen”},
new {ID = 3,Name = “daqing”},
new {ID = 4,Name = “laomeng”},
};
return this.View();
}
<%= Html.TextBox(“Name”) %>
<%= Html.DropDownList(“Employees”) %>

<%= Html.ActionLink(“Go Back To Index”,”Index”) %>
//跳转到Index
<hr />
<%= Html.ActionLink(“Go Back To Index with id=1″, “Index”, new { id=1})%><br />
//跳转到Index，同时传递id参数
<%= Html.ActionLink(“Go back to Index”,”Index”,new{},new{style=”color:red;”}) %>
//跳转到Index，设置连接颜色为红色。个人认为由于ActionLink并没有设置（链接文字，链接地址，连接颜色）的重载，只有（链接文字，链接地址，参数，连接颜色）所以设置了一个new{}空对象
<hr />
<% using (Html.BeginForm(“Index”,”form1″,FormMethod.Post)) {%>
<%= Html.TextBox(“textBox_simple”) %>
<%} %>
//输出一个form表单，必须用using
(2) Routing规则
routes.IgnoreRoute(“Home/About”);//取消路径
(3) 不同方式的循环输出（脚本或控件）
public ActionResult ScriptOrNot()
{
this.ViewData["Number"] = new int[] { 1, 2, 3, 4, 5, 6 };
return View();
}

protected void Page_Load(object sender, EventArgs e)
{
this.rptNumbers.DataSource = this.Numbers;
this.rptNumbers.DataBind();
}
public int[] Numbers
{
get
{
return (int[])this.ViewData["Number"];
}
}

//脚本输出
<% for (int i = 0; i < this.Numbers.Length; i++)
{ %>
<%= this.Numbers[i] %>
<% if (i != this.Numbers.Length – 1)
{%>
,
<%} %>
<%} %>
//控件输出
<asp:Repeater runat=”server” ID=”rptNumbers”>
<ItemTemplate>
<%# Container.DataItem %>
</ItemTemplate>
<SeparatorTemplate>
,
</SeparatorTemplate>
</asp:Repeater>
(4) ViewData强类型输出
//创建一个类
public class TypedIndexViewData
{
public string Title { get; set; }

public string Message { get; set; }
}
//设置类属性值
public ActionResult TypedIndex()
{
var viewData = new TypedIndexViewData
{
Title = “Home Page”,
Message = “Welcome to ASP.NET MVC!”
};
return View(viewData);
}
//输出
<%= Html.Encode(Model.Message) %>

在GridView控件的<Columns></Columns>之外加入代码：

<PagerTemplate>
<asp:LinkButton ID=”btnFirst” runat=”server” CausesValidation=”False” CommandArgument=”First” CommandName=”Page”>首页</asp:LinkButton>
<asp:LinkButton ID=”btnPrev” runat=”server” CausesValidation=”False” CommandArgument=”Prev” CommandName=”Page”>上一页</asp:LinkButton>
<asp:LinkButton ID=”btnNext” runat=”server” CausesValidation=”False” CommandArgument=”Next” CommandName=”Page”>下一页</asp:LinkButton>
<asp:LinkButton ID=”btnLast” runat=”server” CausesValidation=”False” CommandArgument=”Last” CommandName=”Page”>尾页</asp:LinkButton>
第<asp:Label ID=”lbpage” runat=”server” Text=” <%#((GridView)Container.Parent.Parent).PageIndex + 1 %>”> </asp:Label>页
共<asp:Label ID=”lbpagecount” runat=”server” Text=” <%# ((GridView)Container.Parent.Parent).PageCount %>”></asp:Label>页
跳到<asp:TextBox ID=”txtPage” runat=”server” Text=” <%# ((GridView)Container.Parent.Parent).PageIndex + 1 %>” Width=”27px”></asp:TextBox>
<asp:LinkButton ID=”btnGO” runat=”server” CausesValidation=”False” CommandArgument=”-1″ CommandName=”Page” Text=”GO”></asp:LinkButton>
</PagerTemplate>

之后再控件的PageIndexChangin事件中加入代码：（pagesize为公共变量）

protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
if (Session["pagesize"] == “”)
{
if (e.NewPageIndex < 0)
{
pagesize = 0;
}
else if (e.NewPageIndex > GridView1.PageCount – 1)
{
pagesize = GridView1.PageCount – 1;
}
else
{
pagesize = e.NewPageIndex;
}
}
else
{
pagesize = Convert.ToInt32(Session["pagesize"].ToString());
Session["pagesize"] = “”;
}
BindGridView(pagesize);//绑定GridView数据
}

再在RowCommand事件中加入代码：

protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == “Page”)
{
if (e.CommandArgument == “-1″)
{
int page = Convert.ToInt32(((TextBox)GridView1.BottomPagerRow.FindControl(“txtPage”)).Text.ToString()) – 1;
Session["pagesize"] = page;
}
}
}

首先在当前目录下创建一个Table.xls的模板文件。

添加引用
using Excel = Microsoft.Office.Interop.Excel;
using Microsoft.Office.Interop.Excel;
using System.IO;

protected void btnExport_Click(object sender, EventArgs e)
{
string templateFilePath = MapPath(“Table.xls”);
Excel.Application appliction = new Application();
Excel.Workbook book = appliction.Workbooks.Add(templateFilePath);
Excel.Worksheet sheet = book.ActiveSheet as Excel.Worksheet;

//设置Excel中第一行，第一列的内容
Excel.Range range1 = sheet.Cells[1, 1] as Excel.Range;
range1.Value2 = “aa”;
//设置单元格中内容左对齐
range1.HorizontalAlignment = Excel.XlHAlign.xlHAlignLeft;
//设置单元格的背景颜色，16代表灰色
range1.Interior.ColorIndex = 16;
//设置Excel中第一行，第二列的内容
Excel.Range range2 = sheet.Cells[1, 2] as Excel.Range;
range2.Value2 = “bb”;

//设置Excel中第二行，第一列的内容
Excel.Range range3 = sheet.Cells[2, 1] as Excel.Range;
range3.Value2 = “cc”;
//设置Excel中第二行，第二列的内容
Excel.Range range4 = sheet.Cells[2, 2] as Excel.Range;
range4.Value2 = “dd”;
string tmpfilePath = SaveAndCloseBook(book);
RenderExcelFile(tmpfilePath, “Table.xls”);
DeleteFile(tmpfilePath);
}

public static string SaveAndCloseBook(Workbook book)
{
string pathFileName = GenerateTempExcelFileName();
book.SaveAs(pathFileName, XlFileFormat.xlWorkbookNormal, Type.Missing, Type.Missing, Type.Missing, Type.Missing, XlSaveAsAccessMode.xlNoChange, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
book.Close(Type.Missing, Type.Missing, Type.Missing);

return pathFileName;
}

public static string GenerateTempExcelFileName()
{
string fileName = Guid.NewGuid().ToString() + “.xls”;
string pathFileName = HttpContext.Current.Server.MapPath(fileName);
return pathFileName;
}

public static void RenderExcelFile(string pathFileName, string clientFileName)
{
HttpResponse response = HttpContext.Current.Response;
string fileName = HttpContext.Current.Server.UrlEncode(clientFileName);
response.AppendHeader(“Content-Disposition”, “attachment; filename=” + fileName);
response.Charset = “UTF-8″;
response.ContentEncoding = System.Text.Encoding.Default;
response.ContentType = “application/ms-excel”;

response.Clear();
response.WriteFile(pathFileName);
response.Flush();
}

public static void DeleteFile(string pathFileName)
{
if (!string.IsNullOrEmpty(pathFileName))
{
File.Delete(pathFileName);
}
}