LowLevel Class

PicoXLSX

PicoXLSX

LowLevel Class

Class for low level handling (XML, formatting, packing)
Inheritance Hierarchy
SystemObject  PicoXLSXLowLevel

Namespace:  PicoXLSX
Assembly:  PicoXLSX (in PicoXLSX.dll) Version: 2.4.0.0 (2.4.0)
Syntax
C#
internal class LowLevel

The LowLevel type exposes the following members.

Constructors
  NameDescription
Private methodStatic memberLowLevel
Public methodLowLevel
Constructor with defined workbook object
Top
Properties
  NameDescription
Public propertyInterceptDocuments
Gets or set whether XML documents are intercepted during creation
Public propertyInterceptedDocuments
Gets the intercepted documents if interceptDocuments is set to true
Top
Methods
  NameDescription
Private methodAppendXmlTag
Method to append a simple XML tag with an enclosed value to the passed StringBuilder
Private methodAppendXmlToPackagePart
Writes raw XML strings into the passed Package Part
Private methodCreateAppPropertiesDocument
Method to create the app-properties (part of meta data) as raw XML string
Private methodCreateAppString
Method to create the XML string for the app-properties document
Private methodCreateColsString
Method to create the columns as XML string. This is used to define the width of columns
Private methodCreateCorePropertiesDocument
Method to create the core-properties (part of meta data) as raw XML string
Private methodCreateCorePropertiesString
Method to create the XML string for the core-properties document
Private methodCreateMergedCellsString
Method to create the merged cells string of the passed worksheet
Private methodCreateMruColorsString
Method to create the XML string for the color-MRU part of the style sheet document (recent colors)
Private methodCreateRowString
Method to create a row string
Private methodCreateSharedStringsDocument
Method to create shared strings as raw XML string
Private methodCreateSheetProtectionString
Method to create the protection string of the passed worksheet
Private methodCreateStyleBorderString
Method to create the XML string for the border part of the style sheet document
Private methodCreateStyleFillString
Method to create the XML string for the fill part of the style sheet document
Private methodCreateStyleFontString
Method to create the XML string for the font part of the style sheet document
Private methodCreateStyleNumberFormatString
Method to create the XML string for the number format part of the style sheet document
Private methodCreateStyleSheetDocument
Method to create a style sheet as raw XML string
Private methodCreateStyleXfsString
Method to create the XML string for the Xf part of the style sheet document
Private methodCreateWorkbookDocument
Method to create a workbook as raw XML string
Private methodCreateWorksheetPart
Method to create a worksheet part as a raw XML string
Public methodEquals
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
Public methodStatic memberEscapeXmlAttributeChars
Method to escape XML characters in an XML attribute
Public methodStatic memberEscapeXmlChars
Method to escape XML characters between two XML tags
Protected methodFinalize
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object.)
Public methodStatic memberGeneratePasswordHash
Method to generate an Excel internal password hash to protect workbooks or worksheets
This method is derived from the c++ implementation by Kohei Yoshida (http://kohei.us/2008/01/18/excel-sheet-protection-password-hash/)
Public methodGetHashCode
Serves as a hash function for a particular type.
(Inherited from Object.)
Public methodStatic memberGetOADateTimeString
Method to convert a date or date and time into the internal Excel time format (OAdate)
Private methodGetSortedSheetData
Method to sort the cells of a worksheet as preparation for the XML document
Public methodGetType
Gets the Type of the current instance.
(Inherited from Object.)
Protected methodMemberwiseClone
Creates a shallow copy of the current Object.
(Inherited from Object.)
Public methodSave
Method to save the workbook
Public methodSaveAsStream
Method to save the workbook as stream
Public methodToString
Returns a string that represents the current object.
(Inherited from Object.)
Top
Remarks
This class is only for internal use. Use the high level API (e.g. class Workbook) to manipulate data and create Excel files
See Also