com.highqsoft.csvconverter

Class Excel2CVS

java.lang.Object

com.highqsoft.csvconverter.Excel2CVS

All Implemented Interfaces:

java.lang.Runnable

public class Excel2CVS
extends java.lang.Object
implements java.lang.Runnable

The EXCEL to CSV converter. This is a standalone class to be used to convert MS-EXCEL to CSV files.

The startup main methos can be controlled using the following paramters.

*

Property Keyword	Datatype	Default	Description
Separator	string	semicolon (;)	The separator that should be used as cell separtor.
SingleSheetNamePattern	string	{0}.cvs	The filename pattern for single sheet files. The first message format parameter will be filename without extension of the input file file.
MultiSheetNamePattern	string	{0}-Sheet{1}.cvs	The filename pattern for multi sheet files. The first message format parameter will be filename without extension of the input file file. The second parameter will be the index, starting at 1, fo the sheet.

Since:

$Date: 2017/04/06 13:28:56 $

Version:

$Revision: 1.11 $

Author:

Andreas Hofmann

See Also:

Field Summary

Fields

Modifier and Type	Field and Description
protected java.lang.String[]	filenames
protected java.util.Properties	properties
static java.lang.String	SEPARATOR

Constructor Summary

Constructors

Constructor and Description
Excel2CVS(java.lang.String[] filenames, java.util.Properties properties) The constructor.

Method Summary

Methods

Modifier and Type	Method and Description
protected java.lang.String	getProperty(java.lang.String key, java.lang.String def) Get a property.
static void	main(java.lang.String[] args) Main module of this application.
void	run() Start the convertion process.

Methods inherited from class java.lang.Object

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

Field Detail

SEPARATOR

public static final java.lang.String SEPARATOR

See Also:

Constant Field Values

filenames

protected java.lang.String[] filenames

properties

protected java.util.Properties properties

Constructor Detail

Excel2CVS

public Excel2CVS(java.lang.String[] filenames,
         java.util.Properties properties)

The constructor.

Parameters:

filenames - the EXCEL filenames

properties - the properties to control the process.

Method Detail

run

public void run()

Start the convertion process.

Specified by:

run in interface java.lang.Runnable

getProperty

protected java.lang.String getProperty(java.lang.String key,
                           java.lang.String def)

Get a property.

Parameters:

key - property key

def - the default value.

Returns:

return the value or the default.

main

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

Main module of this application.

Parameters:

args - just pass EXCEL spreadsheet to that program.