Search code examples
devexpressexport-to-excelxtragrid

DevExpress XtraGrid ExportToXls is not working on all desktops: what are its prerequisites?


What are the prerequisites for the XtraGrid's ExportToXls method? To accomplish this, does some DLL have to be included in addition to the XtraGrid DLL? Does the export use Office interop behind the scenes? I am trying to get to the bottom of a problem where it works on some machines and fails on others.


Solution

  • What are the prerequisites for the XtraGrid's ExportToXls method?
    To accomplish this, does some DLL have to be included in addition to the XtraGrid DLL?

    Ans:

    Source: Export Methods and Settings and GridControl.ExportToXls(String,XlsExportOptions) Method

    The XtraGrid control provides a set of methods that allow you to export data in various formats. These methods export data using routines implemented in the XtraPrinting Library.

    GridControl.ExportToXls(String) Method method indirectly calls the DevExpress.XtraPrinting.PrintingSystemBase.ExportToXls method of the XtraPrinting Library. If this library is not available the method does nothing. For details on the ExportToXls method see the DevExpress.XtraPrinting.PrintingSystemBase.ExportToXls topic

    XtraPrinting Library Ref

    Does the export use Office interop behind the scenes?

    Regarding this you need to ask the DevExpress guys for clearification. As per my understanding, it does not require any Microsoft Office interop dll references.