Syncfusion.XlsIO.Base
Properties  Methods  Events

Syncfusion.XlsIO Namespace : IApplication Interface

IApplication Interface Members

The following tables list the members exposed by IApplication.

Public Properties
 NameDescription
 Property Returns a Range object that represents the active cell in the active window (the window on top) or in the specified window. If the window isn't displaying a worksheet, this property fails. Read-only.  
 Property Returns an object that represents the active sheet (the sheet on top) in the active workbook or in the specified window or workbook. Returns Nothing if no sheet is active. Read-only.  
 Property Returns a Workbook object that represents the workbook in the active window (the window on top). Read-only. Returns Nothing if there are no windows open or if either the Info window or the Clipboard window is the active window.  
 Property Gets the application object. (Inherited from Syncfusion.XlsIO.IParentApplication)
 Property Formula arguments separator.  
 Property Returns the Microsoft Excel build number. Read-only.  
 Property If this property is set to True, then if some cells have reference to the same style, changes will influence all these cells. Default value: False  
 Property Represents the chart to image converter instance.  
 Property Compression level for workbooks serialization.  
 Property Gets or sets the qualifier to put around the results with separator or record delimiter.  
 Property Gets or sets the record delimiter to put at the end of each record.  
 Property Represents CSV Separator. Using for Auto recognize file type.  
 Property Changes data provider type for all operations after it.  
 Property Sets or returns the character used for the decimal separator as a String. Read/write.  
 Property Returns or sets the default path that Microsoft Excel uses when it opens files. Read/write String.  
 Property Gets / sets default excel version. This value is used in create methods.  
 Property Indicates whether XlsIO should delete destination file before saving into it. Default value is TRUE.  
 Property Specifies whether to increment the references in formula automatically. Default value is false.  
 Property Specifies whether to run Partial trust code.  
 Property Flag to ignore exception and exclude characters more than 32767 (maximum allowed characters) in a cell text.  
 Property All data entered after this property is set to True will be formatted with the number of fixed decimal places set by the FixedDecimalPlaces property. Read/write Boolean.  
 Property Returns or sets the number of fixed decimal places used when the FixedDecimal property is set to True. Read/write.  
 Property  
 Property Gets or sets a boolean value which indicates whether the chart caches are enabled or not Default value is false.  
 Property Indicates whether to optimize fonts count. This option will take effect only on workbooks that will be added after setting this property. WARNING: Setting this property to True can decrease performance significantly, but will reduce resulting file size.  
 Property Indicates whether to optimize Import data. This option will take effect only on Import methods that are available with the worksheet WARNING: Setting this property to True can decrease memory significantly, but will increase the performance of data import .  
 Property Gets the parent object. (Inherited from Syncfusion.XlsIO.IParentApplication)
 Property Returns the path separator character ("\"). Read-only String.  
 Property Indicates whether to preserve the datatypes for the CSV file formats.  
 Property Returns a Range object that represents a cell or a range of cells.  
 Property Specifies whether the range should be accessed from worksheet or within the range object scope..  
 Property Gets / sets row separator for array parsing.  
 Property Gets / sets memory allocation block for single row. Each row will allocate memory block that can be divided on this number. Smaller value means smaller memory usage but slower speed when changing cell's value. Default value is 128. That is enough to allocate 9 string records, or 9 integer numbers (or floating numbers with 1 or 2 digits after decimal point) or 7 double numbers.  
 Property Returns or sets the number of sheets that Microsoft Excel automatically inserts into new workbooks. Read/write Long.  
 Property  
 Property This flag controls behavior of workbook save methods. Each flag controls one aspect of the save code. Can be set one or more flags which will influence the output produced by the library.  
 Property Returns or sets the name of the standard font. Read/write String.  
 Property Returns or sets the standard font size, in points. Read/write.  
 Property Returns or sets the standard (default) height of all the rows in the worksheet, in points. This value is used only for newly created worksheets. Read/write Double.  
 Property Returns or sets the standard (default) height option flag, which defines that standard (default) row height and book default font height do not match. This value is used only for newly created worksheets. Read/write Bool.  
 Property Returns or sets the standard (default) width of all the columns in the worksheet. This value is used only for newly created worksheets. Read/write Double.  
 Property Sets or returns the character used for the thousands separator as a String. Read / write.  
 Property Specifies whether to remove worksheet reference in formulas on removing and reattaching the worksheet. Default value is TRUE.  
 Property Indicates whether to try fast record parsing.  
 Property Indicates is use unsafe code.  
 Property Indicates whether we should use native storage (standard windows COM object) or our .Net implementation to open excel 97-2003 files.  
 Property Returns or sets the name of the current user. Read/write String.  
 Property Gets or sets a boolean value indicating whether to add string delimiter for all the text values. Default value is FALSE.  
 Property True (default) if the system separators of Microsoft Excel are enabled. Read/write Boolean.  
 Property For the Application object, always returns "Microsoft Excel". For the CubeField object, the name of the specified field. For the Style object, the name of the specified style. Read-only String.  
 Property Returns a Workbooks collection that represents all the open workbooks. Read-only.  
 Property For an Application object, returns a Sheets collection that represents all the worksheets in the active workbook. For a Workbook object, returns a Sheets collection that represents all the worksheets in the specified workbook. Read-only Sheets object.  
Top
Public Methods
 NameDescription
 Method Converts a measurement from centimeters to points (one point equals 0.035 centimeters).  
 Method Converts units.  
 Method Converts a measurement from inches to points.  
 MethodOverloaded.  Check whether the file version is supported by XlsIO.  
 Method Saves changes to the active workbook.  
Top
Public Events
 NameDescription
 Event This event is fired when user tries to open password protected workbook without specifying password. It is used to obtain password.  
 Event This event is fired when user specified wrong password when trying to open password protected workbook. It is used to obtain correct password.  
 Event When workbook is read from stream and position of the stream changed, this event is raised.  
 Event This event is fired to substitute an alternate font when a specified font is not installed in the production environment in Excel to PDF/Image conversion.  
 Event  
Top
See Also