日期:2014-05-18 浏览次数:21143 次
private void MakeExcel() { string filePath = System.Windows.Forms.Application.StartupPath + "\\Board.xls"; if (!File.Exists(filePath)) { //****************************************************** Microsoft.Office.Interop.Excel.Application xls_exp = null; Microsoft.Office.Interop.Excel._Workbook xls_book = null; Microsoft.Office.Interop.Excel._Worksheet xls_sheet = null; object missing = System.Reflection.Missing.Value; try { // string[] tt = new string[] { "客户简称", "客户姓名", "联系电话", "银行账号", "账户名称", "账户性质" }; xls_exp = new Microsoft.Office.Interop.Excel.ApplicationClass(); xls_exp.Visible = true; xls_book = xls_exp.Workbooks.Add(missing); xls_sheet = xls_book.Worksheets.Add(missing, missing, 1, missing) as Microsoft.Office.Interop.Excel._Worksheet; //(Microsoft.Office.Interop.Excel._Worksheet)xls_book.ActiveSheet; xls_sheet.Name = "RelationerTable"; xls_sheet.Columns.NumberFormatLocal = "@"; xls_sheet.Cells[1, 1] = "客户简称"; xls_sheet.Cells[1, 2] = "客户姓名"; xls_sheet.Cells[1, 3] = "联系电话"; xls_sheet.Cells[1, 4] = "银行账号"; xls_sheet.Cells[1, 5] = "账户名称"; xls_sheet.Cells[1, 6] = "账户性质"; xls_book.SaveAs(filePath, missing, missing, missing, missing, missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlShared, missing, missing, missing, missing, missing); xls_exp.Quit(); System.Diagnostics.Process.Start(System.Windows.Forms.Application.StartupPath + "\\Board.xls"); } catch (Exception err) { MessageBox.Show(err.Message); } finally { System.Runtime.InteropServices.Marshal.ReleaseComObject(xls_exp); xls_exp = null; GC.Collect(); } //****************************************************** } else { System.Diagnostics.Process.Start(System.Windows.Forms.Application.StartupPath + "\\Board.xls"); } }
public static void SaveToExcel(string content, string filename) { System.Web.HttpContext.Current.Response.Clear(); System.Web.HttpContext.Current.Response.ClearHeaders(); System.Web.HttpContext.Current.Response.ClearContent(); System.Web.HttpContext.Current.Response.Buffer = false; System.Web.HttpContext.Current.Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; System.Web.HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8"); System.Web.HttpContext.Current.Response.AppendHeader("Content-Disposition", "Attachment;filename=" + System.Web.HttpUtility.UrlEncode(filename, Encoding.UTF8) + ".xls"); Sy