org.vishia.zcmd

Class Csv2Data

java.lang.Object

org.vishia.zcmd.Csv2Data

public class Csv2Data
extends java.lang.Object

This class can parse an Excel file given in the textual csv format and translate it either to XML or to internal Java data. There are some specials in the text format of csv:

• If the text in an Excel cell contains more as one line, the line will be separated with 0x0a instead 0x0d 0x0a. That is not meaningfully here.
• A text in an Excel cell which contains more as one line is presented in more as one line in the csv format with 0x0a as line separator. The parser does not distinguish between 0x0a and 0x0d as line separators. The conclusion of the text of the cell is detected by recognizing the quotes at begin of the cell and the closing quotes at the end of the cell in some lines later.

csv-example:

 "column 1"; "column 2"; "column 3"; "column 4";
 "This is a cell"; 123,05; "Text with
 more as one
 line in a cell"; "more data"
 

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
(package private) static class	Csv2Data.Args
(package private) static class	Csv2Data.CmdHandler

Field Summary

Fields

Modifier and Type	Field and Description
(package private) char	cDecimalSep '.' if the separator is ',', elsewhere ','.
(package private) int	colident Column where the identifier is found.
(package private) java.util.List<java.lang.String>	columns
(package private) java.util.Map<java.lang.String,java.util.Map<java.lang.String,java.lang.String>>	dataMap
(package private) int	lineNr
(package private) java.util.List<java.util.Map<java.lang.String,java.lang.String>>	lines
(package private) MainCmdLogging_ifc	log
(package private) char	separator The character which is the separator of columns in the line.
static java.lang.String	sVersion Version, history and license.

Constructor Summary

Constructors

Constructor and Description
Csv2Data()
Csv2Data(MainCmdLogging_ifc log)

Method Summary

Modifier and Type	Method and Description
void	createColumns(java.lang.String sLine) The first line should contain the identifier for the columns.
static void	main(java.lang.String[] cmdargs)
java.lang.String	parseCsv(java.lang.String sFileIn)
java.lang.String	parseCsvZbnf(java.lang.String sFileIn)
void	parseLine(java.lang.String sLineStart, java.io.BufferedReader reader)
java.lang.Object	value(java.lang.String cell, java.lang.String name) Converts a value
float	XXXfloatVal(java.lang.String cell)
java.lang.String	XXXparseLine(java.lang.String sLine)

Methods inherited from class java.lang.Object

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

Field Detail

sVersion

public static final java.lang.String sVersion

Version, history and license.

• 2016-06-22 bugfix: A ""text"" inside a text cell should be detected exactly.
• 2016-03-30 bugfix: Only one line separation per csv-line was processed, now more as one (text cell, which contains line feed)
• 2015-11-19 new chg All identifier in first line in "" possible.
• 2015-07-04 new #value(String), returns a float value if it is possible.
• 2014-02-09 created. Evaluation from excel content.

Copyright/Copyleft: For this source the LGPL Lesser General Public License, published by the Free Software Foundation is valid. It means:

1. You can use this source without any restriction for any desired purpose.
2. You can redistribute copies of this source to everybody.
3. Every user of this source, also the user of redistribute copies with or without payment, must accept this license for further using.
4. But the LPGL is not appropriate for a whole software product, if this source is only a part of them. It means, the user must publish this part of source, but don't need to publish the whole source of the own product.
5. You can study and modify (improve) this source for own using or for redistribution, but you have to license the modified sources likewise under this LGPL Lesser General Public License. You mustn't delete this Copyright/Copyleft inscription in this source file.

If you are intent to use this sources without publishing its usage, you can get a second license subscribing a special contract with the author.

See Also:

Constant Field Values

log

final MainCmdLogging_ifc log

dataMap

java.util.Map<java.lang.String,java.util.Map<java.lang.String,java.lang.String>> dataMap

lines

java.util.List<java.util.Map<java.lang.String,java.lang.String>> lines

columns

java.util.List<java.lang.String> columns

colident

int colident

Column where the identifier is found.

lineNr

int lineNr

separator

char separator

The character which is the separator of columns in the line. It is either ";" or ",", detect from the first line in createColumns(String).

cDecimalSep

char cDecimalSep

'.' if the separator is ',', elsewhere ','.

Constructor Detail

Csv2Data

public Csv2Data(MainCmdLogging_ifc log)

Csv2Data

public Csv2Data()

Method Detail

main

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

parseCsv

public java.lang.String parseCsv(java.lang.String sFileIn)

createColumns

public void createColumns(java.lang.String sLine)

The first line should contain the identifier for the columns. The column of that identifier which is named "Identifier" is set as colident. It is the column which contains the identifier for the line.

Parameters:

sLine -

XXXparseLine

public java.lang.String XXXparseLine(java.lang.String sLine)

parseLine

public void parseLine(java.lang.String sLineStart,
                      java.io.BufferedReader reader)

value

public java.lang.Object value(java.lang.String cell,
                              java.lang.String name)

Converts a value

Parameters:

cell - String given value

name - the name only for test.

Returns:

Either null, a String or a Float

XXXfloatVal

public float XXXfloatVal(java.lang.String cell)

parseCsvZbnf

public java.lang.String parseCsvZbnf(java.lang.String sFileIn)