Package de.xima.fc.gui.utils.data

Class StringDataSheetUtils

java.lang.Object

de.xima.fc.gui.utils.data.StringDataSheetUtils

public class StringDataSheetUtils
extends Object

Utility Class containing helper methods for working with a data grid model of type String

Author:

XIMA MEDIA GmbH

Method Summary

Modifier and Type	Method	Description
static SheetDimension	findSheetDimensions(org.apache.poi.ss.usermodel.Sheet sheet)
static String	getCSVStringFromDataSheet(StringDataSheet sheet)
static StringDataSheet	getDataSheet(String data, CSVFormatWrapper csvFormat, int startAtLine)
static StringDataSheet	getDataSheetFromCSVByteArray(byte[] bytes, CSVFormatWrapper csvFormat, int startAtLine)
static StringDataSheet	getDataSheetFromCSVString(String csvString, CSVFormatWrapper csvFormat, int startAtLine)
static StringDataSheet	getDataSheetFromExcelByteArray(byte[] data, String sheetName, int startAtLine)	Generates a StringDataSheet for the given sheet name
static StringDataSheet	getDataSheetFromTemplate(Textbaustein template, Locale clientLocale, String technicalNameKeyColumn, String displayNameKeyColumn, String technicalNameDefaultColumn)	Create a StringDataSheet object and returns it.
static Map<String,StringDataSheet>	getDataSheetsFromExcelByteArray(byte[] data)	Generates a Map with StringDataSheets (values) and their names (key)
static Map<String,StringDataSheet>	getDataSheetsFromExcelByteArray(byte[] data, List<String> sheetNames)	Generates a Map with StringDataSheets (values) and their names (key) for the given sheet names
static StringDataSheet	getDefaultDataSheet()
static Map<String,Properties>	getPropertyObjectsFromDataSheet(StringDataSheet dataSheet, String columnNameForPropertyKey, String columnNameForDefault, Locale currentClientLocale)	Generates a Properties-Object from all Columns in given data sheet.
static Charset	guessCharset(InputStream is)
static void	prefillDataSheetReferencesFromSystemProperties(ADataSheet<String> sheet, String keyColumnName, String refContent)	Fills the given data sheet with the data from the system properties.

Methods inherited from class java.lang.Object

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

Method Detail

getDefaultDataSheet

public static final StringDataSheet getDefaultDataSheet()

getCSVStringFromDataSheet

public static final String getCSVStringFromDataSheet(StringDataSheet sheet)

getDataSheetFromCSVString

public static final StringDataSheet getDataSheetFromCSVString(String csvString,
                                                              CSVFormatWrapper csvFormat,
                                                              int startAtLine)
                                                       throws Exception

Throws:

Exception

getDataSheet

public static final StringDataSheet getDataSheet(String data,
                                                 CSVFormatWrapper csvFormat,
                                                 int startAtLine)
                                          throws Exception

Throws:

Exception

getDataSheetFromCSVByteArray

public static final StringDataSheet getDataSheetFromCSVByteArray(byte[] bytes,
                                                                 CSVFormatWrapper csvFormat,
                                                                 int startAtLine)
                                                          throws Exception

Throws:

Exception

guessCharset

public static Charset guessCharset(InputStream is)
                            throws IOException

Throws:

IOException

getDataSheetFromExcelByteArray

public static final StringDataSheet getDataSheetFromExcelByteArray(byte[] data,
                                                                   String sheetName,
                                                                   int startAtLine)
                                                            throws Exception

Generates a StringDataSheet for the given sheet name

Parameters:

data - byte array of excel file (.xls or .xlsx)

sheetName - String of sheet name to generate StringDataSheets for

Returns:

StringDataSheet for given sheet name

Throws:

Exception - when an error during the reading occurs

getDataSheetsFromExcelByteArray

public static final Map<String,StringDataSheet> getDataSheetsFromExcelByteArray(byte[] data,
                                                                                      List<String> sheetNames)
                                                                               throws Exception

Generates a Map with StringDataSheets (values) and their names (key) for the given sheet names

Parameters:

data - byte array of excel file (.xls or .xlsx)

sheetNames - List of names to generate StringDataSheets for

Returns:

Map with sheet names and sheets

Throws:

Exception - when an error during the reading occurs

getDataSheetsFromExcelByteArray

public static final Map<String,StringDataSheet> getDataSheetsFromExcelByteArray(byte[] data)
                                                                               throws Exception

Generates a Map with StringDataSheets (values) and their names (key)

Parameters:

data - byte array of excel file (.xls or .xlsx)

Returns:

Map with sheet names and sheets

Throws:

Exception - when an error during the reading occurs

getDataSheetFromTemplate

public static final StringDataSheet getDataSheetFromTemplate(Textbaustein template,
                                                             Locale clientLocale,
                                                             String technicalNameKeyColumn,
                                                             String displayNameKeyColumn,
                                                             String technicalNameDefaultColumn)
                                                      throws IOException

Create a StringDataSheet object and returns it. The entries are read from the given Textbaustein.

Parameters:

template - the Textbaustein object with the language specific overloaded properties

clientLocale - the locale of the current Mandant object

technicalNameKeyColumn - technical name for the key column

displayNameKeyColumn - display name for the key column

technicalNameDefaultColumn - technical name of the default column

Returns:

the read StringDataSheet

Throws:

IOException - when an error during the reading occurs

prefillDataSheetReferencesFromSystemProperties

public static final void prefillDataSheetReferencesFromSystemProperties(ADataSheet<String> sheet,
                                                                        String keyColumnName,
                                                                        String refContent)

Fills the given data sheet with the data from the system properties.

Parameters:

sheet - the data sheet to prefill

keyColumnName - the name of the 'key' column

refContent - The reference values.

getPropertyObjectsFromDataSheet

public static final Map<String,Properties> getPropertyObjectsFromDataSheet(StringDataSheet dataSheet,
                                                                                 String columnNameForPropertyKey,
                                                                                 String columnNameForDefault,
                                                                                 Locale currentClientLocale)

Generates a Properties-Object from all Columns in given data sheet. One column from the data sheet must be defined as properties key.

Parameters:

dataSheet - contains the data for the properties objects

columnNameForPropertyKey - name of the columns, which represents the key's for the properties-objects

columnNameForDefault - name of the column, with represents the default locale for the client

currentClientLocale - the current locale of Mandant-object

Returns:

a Map-object with all overloaded Properties

findSheetDimensions

public static SheetDimension findSheetDimensions(org.apache.poi.ss.usermodel.Sheet sheet)