我在自己机器上能够正常运行,但是将代码放到服务器上就发生错误
'以COM方式处理Excel
Dim oExcel As New Excel.Application
Dim oBooks As Excel.Workbooks, oBook As Excel.Workbook
Dim oSheets As Excel.Sheets, oSheet As Excel.Worksheet
Dim oCells As Excel.Range
Dim sFile As String, sTemplate As String
Dim sFile1 As String
sFile = Server.MapPath(Request.ApplicationPath) & "/Temp/新上岗人员.xls"
'定义模版文件
oExcel.Visible = False
oExcel.DisplayAlerts = False
'定义一个新的工作簿
oBooks = oExcel.Workbooks
Dim s As String
oBooks.Open(Server.MapPath((Request.ApplicationPath)& "/Temp/template/新上岗人员.xls"))
////////////在这报错。“未将对象引用设置到对象的实例”
我机器是xp,服务器是2000
oBook = oBooks.Item(1)
oSheets = oBook.Worksheets
Dim str As String
Dim row As Int32 = 3
Dim cmd As SqlClient.SqlCommand
Dim reader As SqlClient.SqlDataReader
oSheet = CType(oSheets.Item(1), Excel.Worksheet)
'命名该sheet
oSheet.Name = "新上岗人员"
conn.Open()
//写数据的代码============================
conn.Close()
'保存
oSheet.SaveAs(sFile)
oBook.Close()
'退出Excel,并且释放调用的COM资源
oExcel.Quit()
ReleaseComObject(oSheets) : ReleaseComObject(oBook)
ReleaseComObject(oBooks) : ReleaseComObject(oExcel)
oExcel = Nothing : oBooks = Nothing : oBook = Nothing
oSheets = Nothing : oSheet = Nothing : oCells = Nothing
System.GC.Collect()
Response.Redirect("Temp/新上岗人员.xls")
'以COM方式处理Excel
Dim oExcel As New Excel.Application
Dim oBooks As Excel.Workbooks, oBook As Excel.Workbook
Dim oSheets As Excel.Sheets, oSheet As Excel.Worksheet
Dim oCells As Excel.Range
Dim sFile As String, sTemplate As String
Dim sFile1 As String
sFile = Server.MapPath(Request.ApplicationPath) & "/Temp/新上岗人员.xls"
'定义模版文件
oExcel.Visible = False
oExcel.DisplayAlerts = False
'定义一个新的工作簿
oBooks = oExcel.Workbooks
Dim s As String
oBooks.Open(Server.MapPath((Request.ApplicationPath)& "/Temp/template/新上岗人员.xls"))
////////////在这报错。“未将对象引用设置到对象的实例”
我机器是xp,服务器是2000
oBook = oBooks.Item(1)
oSheets = oBook.Worksheets
Dim str As String
Dim row As Int32 = 3
Dim cmd As SqlClient.SqlCommand
Dim reader As SqlClient.SqlDataReader
oSheet = CType(oSheets.Item(1), Excel.Worksheet)
'命名该sheet
oSheet.Name = "新上岗人员"
conn.Open()
//写数据的代码============================
conn.Close()
'保存
oSheet.SaveAs(sFile)
oBook.Close()
'退出Excel,并且释放调用的COM资源
oExcel.Quit()
ReleaseComObject(oSheets) : ReleaseComObject(oBook)
ReleaseComObject(oBooks) : ReleaseComObject(oExcel)
oExcel = Nothing : oBooks = Nothing : oBook = Nothing
oSheets = Nothing : oSheet = Nothing : oCells = Nothing
System.GC.Collect()
Response.Redirect("Temp/新上岗人员.xls")
解决方案 »
- SQLSERVER怎么样减少数据库服务器的访问压力!(字有点多,有耐心的人来看下)
- NB----NB大牛------请进-----下载大小问题
- 如何在jquery ui dialog的弹出窗口实现数据分页显示
- 自定义分页显示(使用存储过程分页)中出现的问题.
- 求教 .cs 文件下 get 和set的意思
- 请问这个该如何实现
- ASP.NET讨论。
- 请问一下,在ASP.NET下有什么书,或者电子书,或者网站是详细讲述水晶报表的使用方法的啊
- 怎么样在asp.net窗中弹出消息框
- Web开发读取AD数据
- 使用asp.net2.0个性化特性,配置Profile Provider的疑问
- 在ASP.NET中该怎么把查询结果DataSet中的一列"rep"赋值给一个定长的数组Grade(n)
---
检查服务器中的盘符格式,如果是NTFS格式的,看看创建的文件是否具有写入的权限?文件夹的权限是否放开?
如果是FAT32格式的,需要查找另外的原因。
http://blog.csdn.net/zhangjian01361