Error while generating a PDF file with Excel in ASP.NET

Question

I have to generate an excel file and a PDF file from an asp.net application. I'm using the Interop assemblies and I can generate the excel file without any problem. But when I'm generating an pdf file with the add-in SaveAsPDFandXPS.exe I'm getting the next error:

Exception HRESULT: 0x800A03EC

with a debug I see the error is in the next method which is used to export de PDF file:

_objWB.ExportAsFixedFormat(Excel.XlFixedFormatType.xlTypePDF, _nombreArchivo,
   Excel.XlFixedFormatQuality.xlQualityStandard, false, false, Type.Missing,
   Type.Missing, false, Type.Missing);

MArag · Accepted Answer · 2009-12-07 18:19:08Z

1

That might happen when the office version that you developed against is different from the one used at runtime.

answered Dec 7, 2009 at 18:19

MArag

1363 bronze badges

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

Comments

John Saunders · Accepted Answer · 2010-04-11 16:17:44Z

1

You cannot safely use Office Automation in a server process. The Automation APIs are developed for use in a desktop application only. They usually don't work in ASP.NET, or don't work reliably. There are also licensing issues.

answered Apr 11, 2010 at 16:17

John Saunders

162k26 gold badges252 silver badges403 bronze badges

Comments

fearofawhackplanet · Accepted Answer · 2009-12-08 12:54:46Z

0

Office automation is in general horribly unreliable. Even Microsoft recommend against using it. You might be better off using a pdf generation library like Itextsharp or Crystal Reports.

answered Dec 8, 2009 at 12:54

fearofawhackplanet

53.6k55 gold badges167 silver badges258 bronze badges

Collectives™ on Stack Overflow

Error while generating a PDF file with Excel in ASP.NET

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related