com.aspose.cells
Class ImportTableOptions

java.lang.Object
    extended by com.aspose.cells.ImportTableOptions

public class ImportTableOptions 
extends java.lang.Object

Represents the options of importing data into cells.

Constructor Summary
ImportTableOptions()
           Creates the default imporing options.
 
Property Getters/Setters Summary
int[]getColumnIndexes()
voidsetColumnIndexes(int[] value)
           Gets or sets the columns(0-based) to import from data source. null means all columns should be imported.
booleangetConvertNumericData()
voidsetConvertNumericData(boolean value)
           Gets or sets a value that indicates whether the string value should be converted to numeric or date value.
java.lang.StringgetDateFormat()
voidsetDateFormat(java.lang.String value)
           Gets or sets date format string for cells with imported datetime values.
java.lang.Object[]getDefaultValues()
voidsetDefaultValues(java.lang.Object[] value)
           Default value for the value in the table is null.
booleangetInsertRows()
voidsetInsertRows(boolean value)
           Gets or sets a value that indicates whether new rows should be added for importing data records.
booleanisFieldNameShown()
voidsetFieldNameShown(boolean value)
           Gets or sets a value that indicates whether field name should be imported to the first row.
java.lang.String[]getNumberFormats()
voidsetNumberFormats(java.lang.String[] value)
           Gets or sets the number formats
intgetTotalColumns()
voidsetTotalColumns(int value)
           Gets or sets total column count to import from data source. -1 means all rows of given data source.
intgetTotalRows()
voidsetTotalRows(int value)
           Gets or sets total row count to import from data source. -1 means all rows of given data source.
 

Constructor Detail

ImportTableOptions

public ImportTableOptions()
Creates the default imporing options.

Property Getters/Setters Detail

getConvertNumericData/setConvertNumericData

public boolean getConvertNumericData() / public void setConvertNumericData(boolean value)
Gets or sets a value that indicates whether the string value should be converted to numeric or date value.

getInsertRows/setInsertRows

public boolean getInsertRows() / public void setInsertRows(boolean value)
Gets or sets a value that indicates whether new rows should be added for importing data records.

isFieldNameShown/setFieldNameShown

public boolean isFieldNameShown() / public void setFieldNameShown(boolean value)
Gets or sets a value that indicates whether field name should be imported to the first row.

getDateFormat/setDateFormat

public java.lang.String getDateFormat() / public void setDateFormat(java.lang.String value)
Gets or sets date format string for cells with imported datetime values.

getNumberFormats/setNumberFormats

public java.lang.String[] getNumberFormats() / public void setNumberFormats(java.lang.String[] value)
Gets or sets the number formats

getTotalRows/setTotalRows

public int getTotalRows() / public void setTotalRows(int value)
Gets or sets total row count to import from data source. -1 means all rows of given data source.

getTotalColumns/setTotalColumns

public int getTotalColumns() / public void setTotalColumns(int value)
Gets or sets total column count to import from data source. -1 means all rows of given data source.

getColumnIndexes/setColumnIndexes

public int[] getColumnIndexes() / public void setColumnIndexes(int[] value)
Gets or sets the columns(0-based) to import from data source. null means all columns should be imported.

getDefaultValues/setDefaultValues

public java.lang.Object[] getDefaultValues() / public void setDefaultValues(java.lang.Object[] value)
Default value for the value in the table is null.

See Also:
          Aspose.Cells Documentation - the home page for the Aspose.Cellss Product Documentation.
          Aspose.Cells Support Forum - our preferred method of support.