This method imports data from a spreadsheet into current sheet.
Defined in
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