importCSVFile method

This method imports data from a CSV file into the current sheet.

Defined in

Sheet

Syntax

public void importCSVFile(String FileName) throws SymphonyException
public void importCSVFile(String FileName, String fieldSeperator) throws SymphonyException
public void importCSVFile(String FileName, String fieldSeperator, String Delimiter) throws SymphonyException
public void importCSVFile(String FileName, String fieldSeperator, String Delimiter, int firstLine) throws SymphonyException
public void importCSVFile(String FileName, String fieldSeperator, String delimiter, int firstLine, int importMode) throws SymphonyException

Parameters

String FileName

Specifies the source file to be imported. If the source file does not exist or is an unsupported file type, this method throws an exception.

String fieldSeperator

Specifies the separator used in your data. The default value is a comma ( , ).

String delimiter

Specifies a character to delimit text data. The default value is a quotation ( " ).

int firstLine

Specifies the line number of source file, which is the first line in the new sheet. The default value is 1.

int importMode

Specifies whether to import data as Normal or Value and can be of typesheet import mode constant. The default value is SYMPHONY_SHEET_IMPORTMODE_NORMAL.

See examples

Example: importCSVFile method