com.aspose.cells

Class ImportTableOptions

  • java.lang.Object
    • 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()
void
setColumnIndexes(int[]value)
Gets or sets the columns(0-based) to import from data source. null means all columns should be imported.
booleangetConvertGridStyle()
void
setConvertGridStyle(booleanvalue)
Indicates whether apply the style of the grid view to cells.
booleangetConvertNumericData()
void
setConvertNumericData(booleanvalue)
Gets or sets a value that indicates whether the string value should be converted to numeric or date value.
java.lang.StringgetDateFormat()
void
setDateFormat(java.lang.Stringvalue)
Gets or sets date format string for cells with imported datetime values.
java.lang.Object[]getDefaultValues()
void
setDefaultValues(java.lang.Object[]value)
Default value for the value in the table is null.
booleangetInsertRows()
void
setInsertRows(booleanvalue)
Indicates whether new rows should be added for importing data records.
booleanisFieldNameShown()
void
setFieldNameShown(booleanvalue)
Indicates whether field name should be imported.
booleanisHtmlString()
void
setHtmlString(booleanvalue)
Indicates whether the value contains html tags.
java.lang.String[]getNumberFormats()
void
setNumberFormats(java.lang.String[]value)
Gets or sets the number formats
booleangetShiftFirstRowDown()
void
setShiftFirstRowDown(booleanvalue)
Indicates whether shifting the first row down when inserting rows.
intgetTotalColumns()
void
setTotalColumns(intvalue)
Gets or sets total column count to import from data source. -1 means all rows of given data source.
intgetTotalRows()
void
setTotalRows(intvalue)
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.