Class ExcelExporter
- java.lang.Object
-
- com.mendix.modules.exportmanager.excel.ExcelExporter
-
public class ExcelExporter extends java.lang.Object
-
-
Constructor Summary
Constructors Constructor Description ExcelExporter()
-
Method Summary
All Methods Static Methods Concrete Methods Modifier and Type Method Description static IExcelGrid
createExcelGrid()
Creates a new Excel grid.static IMendixObject
generateXLS(IContext context, IMendixObject fileObject, java.lang.String fileName, java.util.List<IExcelGrid> grids)
Generates an Excel file from the given grids.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)
Generates an Excel file from the given OQL queries.
-
-
-
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 usefileObject
- the file document objectfileName
- the file namegrids
- 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 usefileObject
- the file document objectfileName
- the file nameoqlQueries
- the OQL queriesautoSizeColumns
- indicates whether to size columns automaticallyheaderNames
- 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
-
-