Excel dotnet ExportAsFixedFormat

thegunzo

Hi masters

I am having trouble using the command

XlWrkBk.ExportAsFixedFormat(XlFixedFormatType.xlTypePDF,PDFFileName,XlFixedFormatQuality.xlQualityStandard,true,true,1,1,false,Pointer);

According to http://msdn.microsoft.com/en-us/library/microsoft.office.tools.excel.workbook.exportasfixedformat.aspx the pointer is

FixedFormatExtClassPtrType: Object

A pointer to an implementation of the IMsoDocExporter interface that enables the workbook to be saved in a different fixed format. For more information, see Extending the Office (2007) Fixed-Format Export Feature.

I need to set this pointer to be able to compile. In all examples I can find this property is ignored. Has anyone used this or can help me in selecting the correct dotnet object to use as a pointer ?

thegunzo

I went the "new Visual Studio Class Library" way...

http://www.dynamics.is/?p=1468

\:D/

TinaVdV

Hi,

The answer to your question is described in this post: http://makecreatereiterate.com/workbook ... namics-ax/

You need to create the following objects:

System.Type                  type           = System.Type::GetType("System.Reflection.Missing");
    System.Reflection.FieldInfo  info           = type.GetField("Value");
    System.Object                missingVariant = info.GetValue(null);

Hope that helps!