Package com.mendix.modules.exportmanager.excel

Class ExcelExporter

java.lang.Object

com.mendix.modules.exportmanager.excel.ExcelExporter

public class ExcelExporter
extends Object

Constructor Summary

Constructors

Constructor	Description
ExcelExporter()

Method Summary

Modifier and Type	Method	Description
static IExcelGrid	createExcelGrid()	Creates a new Excel grid.
static IMendixObject	generateXLS(IContext context, IMendixObject fileObject, String fileName, List<IExcelGrid> grids)	Generates an Excel file from the given grids.
static IMendixObject	generateXLS(IContext context, IMendixObject fileObject, String fileName, List<String> oqlQueries, boolean autoSizeColumns, List<String> headerNames)	Generates an Excel file from the given OQL queries.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

ExcelExporter

public ExcelExporter()

Method Details

generateXLS

public static IMendixObject generateXLS(IContext context,
 IMendixObject fileObject,
 String fileName,
 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,
 String fileName,
 List<String> oqlQueries,
 boolean autoSizeColumns,
 List<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