Dim a As Excel.Application
'Dim oBook As Excel.Workbook()
'Dim oSheet As Excel.Worksheet()
a = New Excel.Application
a.Workbooks.Open(Me.Server.MapPath("ChangWu\BiaoDan\RenShiDangAn.xls"))
a.Workbooks.Item(1).Worksheets.Item(1).Cells(3, 4) = Ared("姓名")
a.Workbooks.Item(1).Worksheets.Item(1).Cells(3, 7) = Ared("工号")
a.DisplayAlerts = False
a.Visible = True
a.Workbooks.Item(1).PrintPreview(False)
'''关闭预览界面后,释放资源
System.Runtime.InteropServices.Marshal.ReleaseComObject(a.Workbooks.Item(1).Worksheets.Item(1))
System.Runtime.InteropServices.Marshal.ReleaseComObject(a.Workbooks(1))
a.Workbooks.Item(1).Close()
a.Quit()
a = Nothing 已经实现数据导入到指定格式的excel,并在服务器端能够打印预览
问题:在客户端打击打印->服务端跳出excel打印预览,如何实现
客户端打印预览呢?如何杀掉excel进程
'Dim oBook As Excel.Workbook()
'Dim oSheet As Excel.Worksheet()
a = New Excel.Application
a.Workbooks.Open(Me.Server.MapPath("ChangWu\BiaoDan\RenShiDangAn.xls"))
a.Workbooks.Item(1).Worksheets.Item(1).Cells(3, 4) = Ared("姓名")
a.Workbooks.Item(1).Worksheets.Item(1).Cells(3, 7) = Ared("工号")
a.DisplayAlerts = False
a.Visible = True
a.Workbooks.Item(1).PrintPreview(False)
'''关闭预览界面后,释放资源
System.Runtime.InteropServices.Marshal.ReleaseComObject(a.Workbooks.Item(1).Worksheets.Item(1))
System.Runtime.InteropServices.Marshal.ReleaseComObject(a.Workbooks(1))
a.Workbooks.Item(1).Close()
a.Quit()
a = Nothing 已经实现数据导入到指定格式的excel,并在服务器端能够打印预览
问题:在客户端打击打印->服务端跳出excel打印预览,如何实现
客户端打印预览呢?如何杀掉excel进程
解决方案 »
- 关于使用Lucene.Net的问题
- 谁做过.net使用 UCenter实现同步登录,新增,修改,退出的
- asp.net word在线打开 发布到服务器上面IIS会卡死 本地正常(跪求高手帮忙 在线等)
- 网站的生成与发布
- 2003企业版装完.net 2.0,IIS运行任何.net程序,都显示“无法找到资源”
- datatable和dataview绑定问题?
- 急!请问如何在自定义的控间中保存全局变量?变量也是自定义的类型,用视图出错:该页面视图已损坏……
- 精彩实用的Html在线编辑器!!!
- 数据上传,比对重复
- 电商项目,求40枚asp.net大神加入!!!
- 请问Asp.net的Gridview如何实现这种效果?
- javascript的一个问题,请高手帮帮我
GC.Collect()
GC.WaitForPendingFinalizers()
public void page_load(){ FileStream fStream;
fStream = File.OpenRead("E:\text.xls");//你生成的excel文件
byte[] buffer = new byte[fStream.Length + 1]; h);//转成二进制流
fStream.Read(buffer, 0, buffer.Length);
fStream.Close(); //以下将文件输出到客户端
Response.Clear()
Response.ContentType = "application/ms-excel"
Response.AddHeader("Content-Length", buffer.GetLength(0).ToString);
Response.AddHeader("Content-Disposition", "attachment;filename=file.xls");
Response.Filter.Close();
//Close the filter
Response.BinaryWrite(buffer);
Response.Flush();
Response.End(); }
http://download.csdn.net/source/1368361
Dim d As Diagnostics.Process
ds = System.Diagnostics.Process.GetProcessesByName("Excel")
GC.Collect()
For Each d In ds
'只退出标题为空的EXCEL对象:可能是本程序调用而未完全退出的对象
If Len(d.MainWindowTitle) = 0 Then
d.Kill()
d.Close()
End If
Next '杀掉EXCEL进程
Dim filePath As String = Server.MapPath("ChangWu\BiaoDan\RenShiDangAn.xls")
Dim fileInfo As New FileInfo(filePath)
Response.Clear()
Response.ClearContent()
Response.ClearHeaders()
Response.AddHeader("Content-Disposition", "attachment;filename=" + fileName)
Response.AddHeader("Content-Length", fileInfo.Length.ToString())
Response.AddHeader("Content-Transfer-Encoding", "binary")
Response.ContentType = "application/octet-stream"
Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312")
Response.WriteFile(fileInfo.FullName)
Response.Flush()
Response.End()
隐藏生成excel下面两句
a.DisplayAlerts = False
a.Visible = True
结果在服务器提示是否保存,不保存则下载上次更新的模板。
加上上面两句则直接下载上次模板更新的excel