Unable to Save Excel File using NPOI Library

Question

I am having some difficulties exporting excel file using NPOI dll through ASP.NET page.

Basically, I am able to populate the cells with no exception, however right at the few last steps where I need to export out the excel, it throws an exception when it tries to run Response.End.

Dim ms As New MemoryStream
xlWorkbook.Write(ms)
Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader("content-disposition", "attachment;filename=M4_Control_Chart.xls")
Response.Clear()
Response.BinaryWrite(ms.GetBuffer())
Response.End()

I dont get a lot of information from the exception, it just says "Unable to evaluate expression"

Does anyone have any idea how to fix this?

Thanks.

Why do you have square brackets around Response.End? Typo? If not that is probably the reason - remove them and retry — Kevin Main, Jul 24 '12 at 08:29
In that case see this question http://stackoverflow.com/questions/10756359/unable-to-evaluate-expression-on-web-page — Kevin Main, Jul 24 '12 at 08:38

score 2 · Answer 1 · answered May 24 '14 at 14:24

2

Flush your stream before you read the buffer: ms.Flush()

answered May 24 '14 at 14:24

David Robbins

9,996
7
51
82

Unable to Save Excel File using NPOI Library

1 Answers1