com.ergotech.util

Class ExcelImporter

java.lang.Object

com.ergotech.util.ExcelImporter

public final class ExcelImporter
extends java.lang.Object

Excel Importer for Ids.

Author:

Installer

Constructor Summary

Constructors

Constructor and Description
ExcelImporter()

Method Summary

Modifier and Type	Method and Description
static java.util.List<java.util.Map<java.lang.String,java.lang.Object>>	importExcel(java.io.File importFile, java.lang.String sheetName) Import an excel file.
static void	main(java.lang.String[] argv)

Methods inherited from class java.lang.Object

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

Constructor Detail

ExcelImporter

public ExcelImporter()

Method Detail

importExcel

public static java.util.List<java.util.Map<java.lang.String,java.lang.Object>> importExcel(java.io.File importFile,
                                                                                           java.lang.String sheetName)

Import an excel file. This will read the column headers and for each row in the spreadsheet create a map of header to value. Cells that are empty are not included in the map so a sparse array is possible. Usually, the headers will be properties within a bean. These properties will be populated from the map on return. This does not need to be the case and the caller can manipulate the map as required.

Parameters:

sheetName - if the sheetName is non-null and not zero length and a sheet by that name exists in the file values will be read from that sheet.

importFileName - the file name to import

Returns:

the structure from the imported file.

main

public static void main(java.lang.String[] argv)