Click or drag to resize
NanoXLSX

XlsxWriter Class

Class for low level handling (XML, formatting, packing)
Inheritance Hierarchy
SystemObject
  NanoXLSX.LowLevelXlsxWriter

Namespace: NanoXLSX.LowLevel
Assembly: NanoXLSX (in NanoXLSX.dll) Version: 2.6.7+3223c8b99fcd3402b4ae016daa480abac16f8a9f
Syntax
C#
Copy
internal class XlsxWriter

The XlsxWriter type exposes the following members.

Constructors
 NameDescription
Private methodStatic memberXlsxWriter 
Public methodXlsxWriter Constructor with defined workbook object
Top
Methods
 NameDescription
Private methodAppendSharedString Method to append shared string values and to handle leading or trailing white spaces
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 methodCalculatePaneHeight Method to calculate the pane height, based on the number of rows
Private methodCalculatePaneWidth Method to calculate the pane width, based on the number of columns
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 methodCreatePaneString Method to create the (sub) part of the pane (splitting and freezing) within the worksheet XML document
Private methodCreateRowsString Method to create the enclosing part of the rows
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 methodCreateSheetViewString Method to create the (sub) part of the sheet view (selected cells and panes) within the worksheet XML document
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 methodCreateWorkbookProtectionString Method to create the (sub) part of the workbook protection within the workbook XML document
Private methodCreateWorksheetPart Method to create a worksheet part as a raw XML string
Public methodEqualsDetermines 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 methodFinalizeAllows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object)
Public methodGetHashCodeServes as the default hash function.
(Inherited from Object)
Private methodGetSortedSheetData Method to sort the cells of a worksheet as preparation for the XML document
Public methodGetTypeGets the Type of the current instance.
(Inherited from Object)
Private methodHasPaneSplitting Checks whether pane splitting is applied in the given worksheet
Protected methodMemberwiseCloneCreates a shallow copy of the current Object.
(Inherited from Object)
Private methodStatic memberNormalizeNewLines Method to normalize all newlines to CR+LF
Public methodSave Method to save the workbook
Public methodSaveAsStream Method to save the workbook as stream
Public methodSaveAsStreamAsync Method to save the workbook as stream asynchronous.
Public methodSaveAsync Method to save the workbook asynchronous.
Public methodToStringReturns 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