Inheritance diagram for com.sparsity.sparksee.io.CSVReader:

Collaboration diagram for com.sparsity.sparksee.io.CSVReader:

Public Member Functions
void	SetSeparator (System.String sep) throws System.ApplicationException
	Sets the character used to separate fields in the file.

void	SetNumLines (int numLines)
	Used to limit the number of lines that will be read.

void	Close () throws System.IO.IOException
	Closes the reader.

void	SetLocale (System.String localeStr)
	Sets the locale that will be used to read the file.

bool	Read (com.sparsity.sparksee.gdb.StringList row) throws System.IO.IOException
	Reads the next row as a string array.

void	SetMultilines (int numExtralines)
	Allows the use of fields with more than one line.

void	Open (System.String filePath) throws System.IO.IOException
	Opens the source file path.

bool	Reset () throws System.IO.IOException
	Moves the reader to the beginning.

void	SetStartLine (int startLine)
	Sets the number of lines to be skiped from the beginning.

void	SetSingleLine ()
	Only allows single line fields.

int	GetRow () throws System.IO.IOException
	The row number for the current row.

	CSVReader ()
	Constructs CSVReader.

void	SetQuotes (System.String quotes) throws System.ApplicationException
	Sets the character used to quote fields.

Detailed Description

CSVReader interface.

A very simple CSV reader.

It works as any other RowReader, but open must be called once before the first read operation.

Using the format RFC 4180.

Except: leading and trailing spaces, adjacent to CSV separator character, are trimmed.

You can use your own separators and quote characters. By default the separator is the comma (,) and the quote character is the double quotes ("). Fields with multiple lines can be allowed (and the maximum lines specified), but the default is a single line. The locale string can be used to set the language, country and the file encoding. The format must be "[language_territory][.codeset]". But only the file encoding is being used in the current version. The languages supported are: "en_US", "es_ES" and "ca_ES". <br> The file encodings supported are: "utf8" and "iso88591". For example: To don't change the default locales, use an empty string: "".<br> To read a file in utf8 with the default language settings use ".utf8".<br> To read a file in iso88591 with English language use: "en_US.iso88591".

Check out the 'Data import' section in the SPARKSEE User Manual for more details on this.

Author: Sparsity Technologies http://www.sparsity-technologies.com

Member Function Documentation

◆ Close()

void com.sparsity.sparksee.io.CSVReader.Close ( ) throws System.IO.IOException

Closes the reader.

Exceptions

System.IO.IOException If the close fails.

◆ GetRow()

int com.sparsity.sparksee.io.CSVReader.GetRow ( ) throws System.IO.IOException

The row number for the current row.

Returns: The current row number; 0 if there is no current row.

Exceptions

System.IO.IOException If it fails.

◆ Open()

void com.sparsity.sparksee.io.CSVReader.Open ( System.String filePath ) throws System.IO.IOException

Opens the source file path.

File can be optionally compressed in GZIP format.

Parameters

filePath [in] CSV file path.

Exceptions

System.IO.IOException If bad things happen opening the file.

◆ Read()

bool com.sparsity.sparksee.io.CSVReader.Read ( com.sparsity.sparksee.gdb.StringList row ) throws System.IO.IOException

Reads the next row as a string array.

Parameters

row	[out] A string list with each comma-separated element as a separate entry.

Returns: Returns true if a row had been read or false otherwise.

Exceptions

System.IO.IOException If bad things happen during the read.

◆ Reset()

bool com.sparsity.sparksee.io.CSVReader.Reset ( ) throws System.IO.IOException

Moves the reader to the beginning.

Restarts the reader.

Returns: true if the reader can be restarted, false otherwise.

Exceptions

System.IO.IOException If bad things happen during the restart.

◆ SetLocale()

void com.sparsity.sparksee.io.CSVReader.SetLocale ( System.String localeStr )

Sets the locale that will be used to read the file.

Parameters

localeStr [in] The locale string for the file encoding.

◆ SetMultilines()

void com.sparsity.sparksee.io.CSVReader.SetMultilines ( int numExtralines )

Allows the use of fields with more than one line.

Parameters

numExtralines [in] Maximum number of extra lines for each column (0==unlimited, N==N+1 total rows).

◆ SetNumLines()

void com.sparsity.sparksee.io.CSVReader.SetNumLines ( int numLines )

Used to limit the number of lines that will be read.

Parameters

numLines [in] The maximum number of lines to read (0 == unlimited)

◆ SetQuotes()

void com.sparsity.sparksee.io.CSVReader.SetQuotes ( System.String quotes ) throws System.ApplicationException

Sets the character used to quote fields.

Parameters

quotes [in] Quote character.

Exceptions

System.ApplicationException For any issue

◆ SetSeparator()

void com.sparsity.sparksee.io.CSVReader.SetSeparator ( System.String sep ) throws System.ApplicationException

Sets the character used to separate fields in the file.

Parameters

sep	[in] Separator character.

Exceptions

System.ApplicationException For any issue

◆ SetStartLine()

void com.sparsity.sparksee.io.CSVReader.SetStartLine ( int startLine )

Sets the number of lines to be skiped from the beginning.

Parameters

startLine [in] The line number to skip for start reading

Public Member Functions

Detailed Description

Member Function Documentation

◆ Close()

◆ GetRow()

◆ Open()

◆ Read()

◆ Reset()

◆ SetLocale()

◆ SetMultilines()

◆ SetNumLines()

◆ SetQuotes()

◆ SetSeparator()

◆ SetStartLine()