I am rewriting an ASP NET 1.0 application for Net 2.0. It has worked beautifully for us on NET 1.0. It's ages since I originally wrote the app and I don't know which version of Aspose I'm using (the dll just says Aspose.Cells.dll. I'm also on Vista with IIS 7. I can't upgrade because my license expired Dec 06 and we don't need any new functionality.
When I use the save method to open the spreadsheet in a browser and prompt for the user to save or open, it gives me a "Internet Explorer cannot display the webpage" error in the browser. The code goes past the call to save, but the page just sits there, then flips to the error page.
My app produces a very large spreadsheet with multiple worksheets, but it doesn't work on even an extremely simple spreadsheet either.
My code is as follows: (You'll see it's a trivial example, but it still doesn't work.) The identical code works in NET 1.0 on IIS 6.
Dim wkbook As New Excel
Dim sheet As Worksheet = wkbook.Worksheets(0)
Dim cells As Cells = sheet.Cells
cells("A3").Formula = "=sum(A1:A2)" (at this point in my real app I have verified that it is a valid workbook object with worksheets, etc)
wkbook.Save("Plan.xls", SaveType.OpenInExcel, FileFormatType.Default, Me.Response)
Any ideas would be greatly appreciated. Jackie