Class ExcelExporter


  • public class ExcelExporter
    extends java.lang.Object
    • Constructor Detail

      • ExcelExporter

        public ExcelExporter()
    • Method Detail

      • generateXLS

        public static IMendixObject generateXLS​(IContext context,
                                                IMendixObject fileObject,
                                                java.lang.String fileName,
                                                java.util.List<IExcelGrid> grids)
                                         throws CoreException
        Generates an Excel file from the given grids.
        Parameters:
        context - the context to use
        fileObject - the file document object
        fileName - the file name
        grids - the grids to be converted
        Returns:
        the file object
        Throws:
        CoreException - if generated the Excel file failed
      • generateXLS

        public static IMendixObject generateXLS​(IContext context,
                                                IMendixObject fileObject,
                                                java.lang.String fileName,
                                                java.util.List<java.lang.String> oqlQueries,
                                                boolean autoSizeColumns,
                                                java.util.List<java.lang.String> headerNames)
                                         throws CoreException
        Generates an Excel file from the given OQL queries.
        Parameters:
        context - the context to use
        fileObject - the file document object
        fileName - the file name
        oqlQueries - the OQL queries
        autoSizeColumns - indicates whether to size columns automatically
        headerNames - the columns names
        Returns:
        the file object
        Throws:
        CoreException - if generating the Excel file failed
      • createExcelGrid

        public static IExcelGrid createExcelGrid()
        Creates a new Excel grid.
        Returns:
        the Excel grid