java.lang.ObjectLoadOptions
com.aspose.cells.TxtLoadOptions
public class TxtLoadOptions
Constructor Summary |
---|
TxtLoadOptions()
Creates the options for loading text file. |
TxtLoadOptions(int loadFormat)
Creates the options for loading text file. |
Property Getters/Setters Summary | ||
---|---|---|
boolean | getCheckExcelRestriction() | → inherited from LoadOptions |
void | setCheckExcelRestriction(boolean value) | |
Whether check restriction of excel file when user modify cells related objects. For example, excel does not allow inputting string value longer than 32K. When you input a value longer than 32K such as by Cell.PutValue(string), if this property is true, you will get an Exception. If this property is false, we will accept your input string value as the cell's value so that later you can output the complete string value for other file formats such as CSV. However, if you have set such kind of value that is invalid for excel file format, you should not save the workbook as excel file format later. Otherwise there may be unexpected error for the generated excel file. | ||
boolean | getConvertDateTimeData() | |
void | setConvertDateTimeData(boolean value) | |
Gets or sets a value that indicates whether the string in text file is converted to date data. | ||
boolean | getConvertNumericData() | |
void | setConvertNumericData(boolean value) | |
Gets or sets a value that indicates whether the string in text file is converted to numeric data. | ||
Encoding | getEncoding() | |
void | setEncoding(Encoding value) | |
Gets and sets the default encoding.Only applies for csv file. | ||
boolean | hasFormula() | |
void | setHasFormula(boolean value) | |
Indicates whether the text is formula if it starts with "=". | ||
boolean | getIgnoreNotPrinted() | → inherited from LoadOptions |
void | setIgnoreNotPrinted(boolean value) | |
Ignore the data which are not printed if directly printing the file | ||
InterruptMonitor | getInterruptMonitor() | → inherited from LoadOptions |
void | setInterruptMonitor(InterruptMonitor value) | |
Gets and sets the interrupt monitor. | ||
boolean | isMultiEncoded() | |
void | setMultiEncoded(boolean value) | |
True means that the file contains several encoding. | ||
boolean | getKeepExactFormat() | |
void | setKeepExactFormat(boolean value) | |
Indicates whether the exact formatting should be kept for the cell when converting string value to number or datetime. When ms excel loading datetime or numeric values from csv file, the formatting of those values may be changed, such as leading/tailing zeros of number, year/month/day order of datetime, ...etc. To simulate ms excel's behavior, please set this property to false. Default value of this property is true, so the cell value will be formatted as the same string value in csv template file. | ||
int | getLanguageCode() | → inherited from LoadOptions |
void | setLanguageCode(int value) | |
Gets or sets the user interface language of the Workbook version based on CountryCode that has saved the file. The value of the property is CountryCode integer constant. | ||
LightCellsDataHandler | getLightCellsDataHandler() | → inherited from LoadOptions |
void | setLightCellsDataHandler(LightCellsDataHandler value) | |
The data handler for processing cells data when reading template file. | ||
boolean | getLoadDataAndFormatting() | → inherited from LoadOptions |
void | setLoadDataAndFormatting(boolean value) | |
If true, only loads data , formulas and formatting from the file, other contents and settings are all discarded. For example : shapes ,validation,conditional formatting,pivotables are not loaded. | ||
int | getLoadDataFilterOptions() | → inherited from LoadOptions |
void | setLoadDataFilterOptions(int value) | |
The filter options to denote what data should be loaded. The value of the property is LoadDataFilterOptions integer constant. | ||
boolean | getLoadDataOnly() | → inherited from LoadOptions |
void | setLoadDataOnly(boolean value) | |
If true, only loads data and formulas from the file, other contents and settings are all discarded. | ||
LoadDataOption | getLoadDataOptions() | → inherited from LoadOptions |
void | setLoadDataOptions(LoadDataOption value) | |
Only effects when OnlyLoadData is true. | ||
LoadFilter | getLoadFilter() | → inherited from LoadOptions |
void | setLoadFilter(LoadFilter value) | |
The filter to denote how to load data. | ||
int | getLoadFormat() | → inherited from LoadOptions |
Gets and set the load format. The value of the property is LoadFormat integer constant. | ||
int | getLoadStyleStrategy() | |
void | setLoadStyleStrategy(int value) | |
Indicates the strategy to apply style for parsed values when converting string value to number or datetime. The value of the property is TxtLoadStyleStrategy integer constant. | ||
java.util.Locale | getLocale() | → inherited from LoadOptions |
void | setLocale(java.util.Locale value) | |
Gets and sets the Locale used for workbook at the time the file was loaded. | ||
int | getMemorySetting() | → inherited from LoadOptions |
void | setMemorySetting(int value) | |
Gets or sets the memory usage options. The value of the property is MemorySetting integer constant. | ||
boolean | getOnlyLoadDocumentProperties() | → inherited from LoadOptions |
void | setOnlyLoadDocumentProperties(boolean value) | |
If true, only loads document properties | ||
boolean | getParsingFormulaOnOpen() | → inherited from LoadOptions |
void | setParsingFormulaOnOpen(boolean value) | |
Indicates whether parsing the formula when reading the file. | ||
java.lang.String | getPassword() | → inherited from LoadOptions |
void | setPassword(java.lang.String value) | |
Gets and set the password of the workbook. | ||
ICustomParser[] | getPreferredParsers() | |
void | setPreferredParsers(ICustomParser[] value) | |
Gets and sets preferred value parsers for loading text file. | ||
int | getRegion() | → inherited from LoadOptions |
void | setRegion(int value) | |
Gets or sets the system regional settings based on CountryCode at the time the file was loaded. The value of the property is CountryCode integer constant. | ||
char | getSeparator() | |
void | setSeparator(char value) | |
Gets and sets char Delimiter of text file. | ||
java.lang.String | getSeparatorString() | |
void | setSeparatorString(java.lang.String value) | |
Gets and sets the a string value as separator. | ||
java.lang.String | getStandardFont() | → inherited from LoadOptions |
void | setStandardFont(java.lang.String value) | |
Sets the default standard font name | ||
double | getStandardFontSize() | → inherited from LoadOptions |
void | setStandardFontSize(double value) | |
Sets the default standard font size. | ||
IWarningCallback | getWarningCallback() | → inherited from LoadOptions |
void | setWarningCallback(IWarningCallback value) | |
Gets or sets warning callback. |
Method Summary | ||
---|---|---|
void | setPaperSize(int type) | → inherited from LoadOptions |
Sets the default print paper size from default printer's setting. |
Constructor Detail |
---|
public TxtLoadOptions()
public TxtLoadOptions(int loadFormat)
loadFormat
- A Property Getters/Setters Detail |
---|
getConvertNumericData/setConvertNumericData | |
public boolean getConvertNumericData() / public void setConvertNumericData(boolean value) |
getSeparator/setSeparator | |
public char getSeparator() / public void setSeparator(char value) |
getSeparatorString/setSeparatorString | |
public java.lang.String getSeparatorString() / public void setSeparatorString(java.lang.String value) |
getEncoding/setEncoding | |
public Encoding getEncoding() / public void setEncoding(Encoding value) |
isMultiEncoded/setMultiEncoded | |
public boolean isMultiEncoded() / public void setMultiEncoded(boolean value) |
getPreferredParsers/setPreferredParsers | |
public ICustomParser[] getPreferredParsers() / public void setPreferredParsers(ICustomParser[] value) |
getConvertDateTimeData/setConvertDateTimeData | |
public boolean getConvertDateTimeData() / public void setConvertDateTimeData(boolean value) |
getLoadStyleStrategy/setLoadStyleStrategy | |
public int getLoadStyleStrategy() / public void setLoadStyleStrategy(int value) |
hasFormula/setHasFormula | |
public boolean hasFormula() / public void setHasFormula(boolean value) |
getKeepExactFormat/setKeepExactFormat | |
public boolean getKeepExactFormat() / public void setKeepExactFormat(boolean value) |
getLoadFormat | → inherited from LoadOptions |
public int getLoadFormat() |
getPassword/setPassword | → inherited from LoadOptions |
public java.lang.String getPassword() / public void setPassword(java.lang.String value) |
getParsingFormulaOnOpen/setParsingFormulaOnOpen | → inherited from LoadOptions |
public boolean getParsingFormulaOnOpen() / public void setParsingFormulaOnOpen(boolean value) |
getLoadDataAndFormatting/setLoadDataAndFormatting | → inherited from LoadOptions |
public boolean getLoadDataAndFormatting() / public void setLoadDataAndFormatting(boolean value) |
getLoadDataOnly/setLoadDataOnly | → inherited from LoadOptions |
public boolean getLoadDataOnly() / public void setLoadDataOnly(boolean value) |
getOnlyLoadDocumentProperties/setOnlyLoadDocumentProperties | → inherited from LoadOptions |
public boolean getOnlyLoadDocumentProperties() / public void setOnlyLoadDocumentProperties(boolean value) |
getLoadDataOptions/setLoadDataOptions | → inherited from LoadOptions |
public LoadDataOption getLoadDataOptions() / public void setLoadDataOptions(LoadDataOption value) |
getLanguageCode/setLanguageCode | → inherited from LoadOptions |
public int getLanguageCode() / public void setLanguageCode(int value) |
getRegion/setRegion | → inherited from LoadOptions |
public int getRegion() / public void setRegion(int value) |
getLocale/setLocale | → inherited from LoadOptions |
public java.util.Locale getLocale() / public void setLocale(java.util.Locale value) |
getStandardFont/setStandardFont | → inherited from LoadOptions |
public java.lang.String getStandardFont() / public void setStandardFont(java.lang.String value) |
getStandardFontSize/setStandardFontSize | → inherited from LoadOptions |
public double getStandardFontSize() / public void setStandardFontSize(double value) |
getInterruptMonitor/setInterruptMonitor | → inherited from LoadOptions |
public InterruptMonitor getInterruptMonitor() / public void setInterruptMonitor(InterruptMonitor value) |
getIgnoreNotPrinted/setIgnoreNotPrinted | → inherited from LoadOptions |
public boolean getIgnoreNotPrinted() / public void setIgnoreNotPrinted(boolean value) |
getCheckExcelRestriction/setCheckExcelRestriction | → inherited from LoadOptions |
public boolean getCheckExcelRestriction() / public void setCheckExcelRestriction(boolean value) |
getLoadFilter/setLoadFilter | → inherited from LoadOptions |
public LoadFilter getLoadFilter() / public void setLoadFilter(LoadFilter value) |
getLoadDataFilterOptions/setLoadDataFilterOptions | → inherited from LoadOptions |
public int getLoadDataFilterOptions() / public void setLoadDataFilterOptions(int value) |
getLightCellsDataHandler/setLightCellsDataHandler | → inherited from LoadOptions |
public LightCellsDataHandler getLightCellsDataHandler() / public void setLightCellsDataHandler(LightCellsDataHandler value) |
getMemorySetting/setMemorySetting | → inherited from LoadOptions |
public int getMemorySetting() / public void setMemorySetting(int value) |
getWarningCallback/setWarningCallback | → inherited from LoadOptions |
public IWarningCallback getWarningCallback() / public void setWarningCallback(IWarningCallback value) |
Method Detail |
---|
setPaperSize | → inherited from LoadOptions |
public void setPaperSize(int type) |
type
- A