asp.net error using office XP PIA

[timtai]

I am trying to create an excel report from my aspx.vb code. I got the
following error trying to add a workbook:
Dim xApp As New Microsoft.Office.Interop.Excel.Application
Dim xWB As Microsoft.Office.Interop.Excel.Workbook
xApp.Workbooks.Add()
ERROR --> COMException (0x800a03ec): Microsoft Excel cannot open or
save any more documents because there is not enough available memory or
disk space
If I replace it with
xWB = xApp.Workbooks.Add("c:\aspnet\default.xlt") -- I have ASPNET as
an user with full access to the folder aspnet.
I got a differnt error:
COMException (0x800a03ec): Excel cannot access 'default.xlt'. The
document may be read-only or encrypted.

I have been trying to get this to work for the whole weekend. Any help
is highly appreciated.

Tim

 

[Ken Tucker [MVP]]

Hi,

I would create the spread sheet in xml and try to use that
instead of automating excel.

http://support.microsoft.com/kb/319180/EN-US/

http://msdn.microsoft.com/office/understanding/xmloffice/

Ken
-------------------
I am trying to create an excel report from my aspx.vb code. I got the
following error trying to add a workbook:
Dim xApp As New Microsoft.Office.Interop.Excel.Application
Dim xWB As Microsoft.Office.Interop.Excel.Workbook
xApp.Workbooks.Add()
ERROR --> COMException (0x800a03ec): Microsoft Excel cannot open or
save any more documents because there is not enough available memory or
disk space
If I replace it with
xWB = xApp.Workbooks.Add("c:\aspnet\default.xlt") -- I have ASPNET as
an user with full access to the folder aspnet.
I got a differnt error:
COMException (0x800a03ec): Excel cannot access 'default.xlt'. The
document may be read-only or encrypted.

I have been trying to get this to work for the whole weekend. Any help
is highly appreciated.

Tim

 

[kbelskie]

Any luck with this. I just ran into this problem today with c# and experience both problems (with and without providing the file name) and have not been successful.

**********************************************************************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...