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.
booleangetConvertGridStyle()
voidsetConvertGridStyle(boolean value)
           Indicates whether apply the style of the grid view to cells.
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)
           Indicates whether new rows should be added for importing data records.
booleanisFieldNameShown()
voidsetFieldNameShown(boolean value)
           Indicates whether field name should be imported.
booleanisHtmlString()
voidsetHtmlString(boolean value)
           Indicates whether the value contains html tags.
java.lang.String[]getNumberFormats()
voidsetNumberFormats(java.lang.String[] value)
           Gets or sets the number formats
booleangetShiftFirstRowDown()
voidsetShiftFirstRowDown(boolean value)
           Indicates whether shifting the first row down when inserting rows.
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

getConvertGridStyle/setConvertGridStyle

public boolean getConvertGridStyle() / public void setConvertGridStyle(boolean value)
Indicates whether apply the style of the grid view to cells.

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)
Indicates whether new rows should be added for importing data records.

getShiftFirstRowDown/setShiftFirstRowDown

public boolean getShiftFirstRowDown() / public void setShiftFirstRowDown(boolean value)
Indicates whether shifting the first row down when inserting rows.

isFieldNameShown/setFieldNameShown

public boolean isFieldNameShown() / public void setFieldNameShown(boolean value)
Indicates whether field name should be imported.

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.

isHtmlString/setHtmlString

public boolean isHtmlString() / public void setHtmlString(boolean value)
Indicates whether the value contains html tags.

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