Error on creating Pivot Table in Excel from .net web application

Question

In my web application, I am using Microsoft.Office.Interop.Excel to generate a pivot table in Excel. While Executing the application in my Visual studio IDE, the code is working fine and I am getting the Excel file. But when I hosted the same on IIS, my code is not working and I am receiving the following error

Message: Sys.WebForms.PageRequestManagerParserErrorException: The message received from the server could not be parsed. Common causes for this error are when the response is modified by calls to Response.Write(), response filters, HttpModules, or server trace is enabled. Details: Error parsing near 'Retrieving the COM c'.

Please guide me to overcome this.

Community · Accepted Answer · 2017-05-23 11:55:33Z

1

Automation from a service (IIS is a service) poses several problems... but main point is - you should NOT use Office automation server-side as MS says here http://support.microsoft.com/default.aspx?scid=kb;EN-US;q257757#kb2

see also here Problems with office automation in asp.net. I can use alternatives such as open-office, if I knew how

If you need to modify/create Excel files there are some libraries out there which work support your scenario (for example Aspose.Cells, Spreadsheetgear, Flexcel etc.)

edited May 23, 2017 at 11:55

CommunityBot

11 silver badge

answered Jul 26, 2011 at 4:44

Yahia

70.5k9 gold badges117 silver badges147 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Error on creating Pivot Table in Excel from .net web application

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related