importFile method

This method imports data from a spreadsheet into current sheet.

Defined in

Sheet

Syntax

public void importFile(String fileName, String SheetName) throws SymphonyException
public void importFile(String fileName, String SheetName, int firstLine) throws SymphonyException
public void importFile(String fileName, String sheetName, int firstLine, int importMode) throws SymphonyException

Parameters

String fileName

Specifies the source spreadsheet document to import. The file format ods, ots, xls are supported. If the source file does not exist or is an unsupported file type, this method throws an exception.

String sheetName

Specifies the name of the sheet to import in the source spreadsheet document .

int firstLine

Specifies the line number of source sheet, 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: importFile method