private void ExportExcel1(System.Data.DataTable dt, string p)
{
string newpath = Server.MapPath(".") + @"\" + Guid.NewGuid() + ".xls";
FileInfo mode = new FileInfo(Server.MapPath(".") + @"\报价单.xls");
//string newpath = ResolveUrl(@"\Upload\Excel\") + Guid.NewGuid() + ".xls";
//FileInfo mode = new FileInfo(ResolveUrl(@"\Upload\Excel") + @"\报价单.xls");
Excel.Application app = new Excel.Application();
app.Application.DisplayAlerts = false;
app.Visible = false;
if (mode.Exists)
{
Excel.Workbook tworkbook;
Object missing = System.Reflection.Missing.Value;
app.Workbooks.Add(missing);
tworkbook = app.Workbooks.Open(mode.FullName, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing);
Excel.Worksheet tworksheet = (Excel.Worksheet)tworkbook.Sheets[1];
tworksheet.Cells[3, 1] = "Tel: Fax:E-mail:"+dt.Rows[0].ItemArray[14].ToString();
tworksheet.Cells[7, 2] = dt.Rows[0].ItemArray[1].ToString();
tworksheet.Cells[7, 5] = dt.Rows[0].ItemArray[3].ToString();
tworksheet.SaveAs(newpath, missing, missing, missing, missing, missing, missing, missing, missing, missing);
tworkbook.Close(false, mode.FullName, missing);
app.Workbooks.Close();
app.Quit();
if (app != null)
{
foreach (System.Diagnostics.Process p1 in System.Diagnostics.Process.GetProcessesByName("Excel"))
{
//先判断当前进程是否是excel
if (!p1.CloseMainWindow())
{
p1.Kill();
}
}
}
tworkbook = null;
app = null;
GC.Collect();
}
//打开保存对话框
string FileName = dt.Rows[0].ItemArray[1].ToString() + "Quotation" + DateTime.Now.ToString("yyyyMMdd") + ".xls";
Response.Clear();
Response.ClearHeaders();
Response.Buffer = false;
Response.Charset = "UTF-8";
Response.ContentType = "application/ms-excel";
Response.AppendHeader("Content-Disposition", "attachment;filename=" + Server.UrlEncode(FileName));
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
Response.AppendHeader("Content-Length", mode.Length.ToString());
Response.Charset = "";
this.EnableViewState = false;
Response.WriteFile(newpath);
//删除创建的Excel文件
FileInfo fileinf = new FileInfo(newpath);
fileinf.Delete();
//关闭连接
Response.Flush();
Response.End();
}
