com.aspose.cells

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
booleangetCheckMergedCells()
void
setCheckMergedCells(booleanvalue)
           Indicates whether checking merged cells.
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.
boolean[]isFormulas()
void
setFormulas(boolean[]value)
           Indicates whether the data are formulas.
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

      • isFormulas/setFormulas

        public boolean[] isFormulas() / public void setFormulas(boolean[] value)
        Indicates whether the data are formulas.

      • 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.

      • getCheckMergedCells/setCheckMergedCells

        public boolean getCheckMergedCells() / public void setCheckMergedCells(boolean value)
        Indicates whether checking merged cells.

    setConvertGridStyle

    public voidsetConvertGridStyle(booleanvalue)
    Indicates whether apply the style of the grid view to cells.

    setConvertNumericData

    public voidsetConvertNumericData(booleanvalue)
    Gets or sets a value that indicates whether the string value should be converted to numeric or date value.

    setInsertRows

    public voidsetInsertRows(booleanvalue)
    Indicates whether new rows should be added for importing data records.

    setShiftFirstRowDown

    public voidsetShiftFirstRowDown(booleanvalue)
    Indicates whether shifting the first row down when inserting rows.

    setFieldNameShown

    public voidsetFieldNameShown(booleanvalue)
    Indicates whether field name should be imported.

    setDateFormat

    public voidsetDateFormat(java.lang.Stringvalue)
    Gets or sets date format string for cells with imported datetime values.

    setNumberFormats

    public voidsetNumberFormats(java.lang.String[]value)
    Gets or sets the number formats

    setFormulas

    public voidsetFormulas(boolean[]value)
    Indicates whether the data are formulas.

    setTotalRows

    public voidsetTotalRows(intvalue)
    Gets or sets total row count to import from data source. -1 means all rows of given data source.

    setTotalColumns

    public voidsetTotalColumns(intvalue)
    Gets or sets total column count to import from data source. -1 means all rows of given data source.

    setColumnIndexes

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

    setDefaultValues

    public voidsetDefaultValues(java.lang.Object[]value)
    Default value for the value in the table is null.

    setHtmlString

    public voidsetHtmlString(booleanvalue)
    Indicates whether the value contains html tags.

    setCheckMergedCells

    public voidsetCheckMergedCells(booleanvalue)
    Indicates whether checking merged cells.