All Downloads are FREE. Search and download functionalities are using the official Maven repository.

com.aspose.cells.ImportTableOptions.html Maven / Gradle / Ivy






ImportTableOptions




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 importing options.
 
Property Getters/Setters Summary
booleangetCheckMergedCells()
voidsetCheckMergedCells(boolean)
           Indicates whether checking merged cells.
int[]getColumnIndexes()
voidsetColumnIndexes(int[])
           Gets or sets the columns(0-based) to import from data source. null means all columns should be imported.
booleangetConvertGridStyle()
voidsetConvertGridStyle(boolean)
           Indicates whether apply the style of the grid view to cells.
booleangetConvertNumericData()
voidsetConvertNumericData(boolean)
           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)
           Gets or sets date format string for cells with imported datetime values.
java.lang.Object[]getDefaultValues()
voidsetDefaultValues(java.lang.Object[])
           Default value for the value in the table is null.
booleangetInsertRows()
voidsetInsertRows(boolean)
           Indicates whether new rows should be added for importing data records.
booleanisFieldNameShown()
voidsetFieldNameShown(boolean)
           Indicates whether field name should be imported.
boolean[]isFormulas()
voidsetFormulas(boolean[])
           Indicates whether the data are formulas.
booleanisHtmlString()
voidsetHtmlString(boolean)
           Indicates whether the value contains html tags.
java.lang.String[]getNumberFormats()
voidsetNumberFormats(java.lang.String[])
           Gets or sets the number formats
booleangetShiftFirstRowDown()
voidsetShiftFirstRowDown(boolean)
           Indicates whether shifting the first row down when inserting rows.
intgetTotalColumns()
voidsetTotalColumns(int)
           Gets or sets total column count to import from data source. -1 means all rows of given data source.
intgetTotalRows()
voidsetTotalRows(int)
           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 importing 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.

setConvertGridStyle

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.

setConvertNumericData

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.

setInsertRows

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.

setShiftFirstRowDown

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.

setFieldNameShown

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.

setDateFormat

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

setNumberFormats

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.

setFormulas

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.

setTotalRows

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.

setTotalColumns

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.

setColumnIndexes

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.

setDefaultValues

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.

setHtmlString

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.

setCheckMergedCells

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

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





© 2015 - 2024 Weber Informatics LLC | Privacy Policy