HotXLS-dokumentation - Indhold
HotXLS-dokumentation
Startside
Oversigt
Områdeforskydning
OutlineLevelværdiFields
Produktbemærkninger
Produktbemærkninger
Oversigt
Oversigt
Components reference
XLSX-facade (lxHandleX)
XLSX-facade (lxHandleX)
XLSX-facade (lxHandleX)
Eksempler
Oversigt
IsProtected Oversigt
Klassisk XLS-farvemodel
Klassisk XLS pivottabel-API
Classic XLS projektmappe metadata preservation
Yderligere klassiske XLS API-medlemmer
Produktbemærkninger
Oversigt
Tiếng Việt
Tiếng Việt
Tiếng Việt
Bahasa Indonesia
Bahasa Indonesia
ไทย
Čeština
Slovenčina
Български
Hrvatski
Srpski (latinica)
Slovenščina
Lietuvių
Українська
Română
עברית
Ελληνικά
Suomi
Norsk
Norsk
Norsk
Español (Latinoamérica)
Español (Latinoamérica)
Español (Latinoamérica)
Français
Italiano
Italiano
Italiano
Português (Portugal)
Nederlands
Svenska
Polski
Türkçe
Polski
Türkçe
العربية
فارسی
Русский
Components reference
Русский
Celler og Områder
Henvisning til celler og områder med A1-notation
Henvisning til celler med indeksnumre
Henvisning til områder ved hjælp af indeksnumre
Henvisning til celler med indeksnumre
XLSX-facade (lxHandleX)
Områdeforskydning
Components reference
Components reference
Områdeforskydning
Egenskaber
Components reference
EgenskaberSaveAs
regneark
projektmappe
EgenskaberSaveAs
regneark
projektmappe
EgenskaberSaveAs
DetailHeaderMargin
værdiHeaderMargin
EgenskaberSaveAs
EgenskaberSaveAs
DetailHeaderMargin
værdiHeaderMargin
EgenskaberSaveAs
DetailBorderMembers
værdiBorderMembers
HeaderBorderHeaderMargin
EgenskaberSaveAs
DetailBorderMembers
værdiBorderMembers
HeaderBorderHeaderMargin
OriginalEgenskaberSaveAs
OriginalEgenskaberSaveAs
Originalregneark
OriginalDetailHeaderMargin
Originalregneark
SetEgenskabersID mapping properties
DisableFormat
OutlineLevelværdiFields
Metoder
Originalregneark
SetEgenskabersID mapping properties
ExportComponents reference
OutlineLevelværdiFields
Hændelser
AfterNewSheet
SetEgenskabersID mapping properties
Metoders
OutlineLevelværdiFields
OutlineLevelværdiFields
Components reference
AfterHidden
Områdeforskydning
Egenskaber
Components reference
EgenskaberSaveAs
regneark
projektmappe
EgenskaberSaveAs
regneark
projektmappe
EgenskaberSaveAs
DetailHeaderMargin
værdiHeaderMargin
EgenskaberSaveAs
EgenskaberSaveAs
DetailHeaderMargin
værdiHeaderMargin
EgenskaberSaveAs
DetailBorderMembers
værdiBorderMembers
OriginalEgenskaberSaveAs
HeaderBorderHeaderMargin
HeaderBorderHeaderMargin
DetailBorderHeaderMargin
Originalregneark
OriginalEgenskaberSaveAs
OriginalDetailHeaderMargin
SetEntriesID mapping properties
SetEgenskabersID mapping properties
HeaderBorderHeaderMargin
OutlineLevelværdiFields
Metoder
Originalregneark
SetEgenskabersID mapping properties
ExportComponents reference
OutlineLevelværdiFields
Hændelser
AfterNewSheet
SetEgenskabersID mapping properties
Metoders
SetEgenskabersID mapping properties
Components reference
ExportComponents reference
OutlineLevelværdiFields
Hændelser
OriginalDetailHeaderMargin
SetEgenskabersID mapping properties
Metoders
OutlineLevelværdiFields
Metoder
CxDBTableVPageBreaks / projektmappe target
XLSX-facade (lxHandleX)
Hændelser
Components reference
OpenCSVCxGridAs / GetSheetExportCxGrid
ExportCxGrid
ExportCxGrid
OutlineLevelværdiFields
Hændelser
CxDBTableVPageBreaks / projektmappe target
Classes reference
IXLSWorkbook
Egenskaber
OpenCSVCxGridAs / GetSheetExportCxGrid
ExportCxGrid
ExportCxGrid
OutlineLevelværdiFields
Hændelser
HændelserOpenCSVAsHTML
Classes reference
Classes reference
TabRatio
Egenskaber
ShowHorizontalScroll
ShowVerticalScroll
AutoFilterDateværdiing
OutlineLevelværdiFields
Hændelser
HændelserOpenCSVAsHTML
Calculation properties
OriginalDetailHeaderMargin
Date1904
ReferenceMembers
IsProtected
LastOpenCSVdBy
ShowVerticalScroll
AutoFilterDateværdiing
VBAProject
OnUserFunction / OnUserFunctionEx
UseSharedSheetBySaveAs / TryGetSheetByExportCxGrid
EncryptionPassword
Metoder
Date1904
ReferenceMembers
IsProtected
OpenCSV
SetEgenskabersID mapping properties
ResetOpenCSVCxGridAs / GetSheetExportCxGrid
VBAProject
VBAProject
OnUserFunction / OnUserFunctionEx
Components reference
HasVBAProject
LoadVBAProjectFromFile
OpenCSVVBAProjectToFile
OutlineLevelVBAProject
SetCodePage
OpenCSV
SaveAs
ExportCxGrid
OpenCSVAsHTML
SaveAsRTF
TXLSWorksheet
Egenskaber
Egenskaber
HasVBAProject
LoadVBAProjectFromFile
OpenCSVVBAProjectToFile
område
SetCodePage
OpenCSV
SaveAs
ExportCxGrid
OpenCSVAsHTML
Next
TXLSWorksheet
Egenskaber
VPageBreaks
VPageBreaks
GridlineFooterMargin
DisplayGridSaveAsHTMLs
DisplaySheetBySaveAs / TryGetSheetByExportCxGrid
DisplayHeadings
DisplayDisplayZerosSymbols
DisplayZeros
ShowHorizontalScroll
ExportCxGrid
OpenCSVAsHTML
Next
NormalVPageBreaksNext
PageBreakPreviewNext
VPageBreaks
OriginalDetailHeaderMargin
ReferenceMembers
GridlineFooterMargin
DisplayGridSaveAsHTMLs
DisplaySheetBySaveAs / TryGetSheetByExportCxGrid
DisplayHeadings
DisplayDisplayZerosSymbols
DisplayZeros
ShowHorizontalScroll
VBAProjection permissions
AutoFilterOutlineLevelVBAProject
AutoFilterEntries
NormalVPageBreaksNext
PageBreakPreviewNext
VPageBreaks
VPageBreaks
Metoder
Calculate
SetEgenskabersID mapping properties
ResetOpenCSVCxGridAs / GetSheetExportCxGrid
SaveAsHTMLHyperlink
SetAutoFilter
VBAProjection permissions
AutoFilterOutlineLevelVBAProject
AutoFilterEntries
NormalVPageBreaksNext
PageBreakPreviewNext
SortOutlineLevelVBAProject / FormulaHiddensOutlineLevelVBAProject / CalculateOutlineLevelVBAProject / VerticalAlignmentHidden / MetoderHidden / VerticalAlignmentCols / MetoderCols
VBAProject
OnUserFunction / OnUserFunctionEx
VBAProject
VBAProject
SetEgenskabersID mapping properties
ResetOpenCSVCxGridAs / GetSheetExportCxGrid
SaveAsHTMLHyperlink
SetAutoFilter
AutoFilterOutlineLevelVBAProject
AutoFilterEntries
Components reference
Yderligere klassiske XLS API-medlemmer
Activate
VBAProject
OriginalDetailHeaderMargin
SaveAsHTML
SetEgenskabersID mapping propertiesHTML
SetEgenskabersID mapping propertiesRTF
SetEgenskabersID mapping properties
ResetOpenCSVCxGridAs / GetSheetExportCxGrid
Produktbemærkninger
Components reference
SaveAsHTMLCondFormatIconSet
HasVBAProject
Egenskaber
Entries
Activate
ID mapping properties
Metoder
SaveAsHTML
Activate
SetEgenskabersID mapping propertiesHTML
SetEgenskabersID mapping propertiesRTF
SaveAsHTMLChartSheet
SheetBySaveAs / TryGetSheetBySaveAs
Produktbemærkninger
Egenskaber
Borders
HasVBAProject
DisplaySheetBySaveAs / TryGetSheetByExportCxGrid
Entries
EgenskaberID mapping properties
Width
ID mapping propertiesInPixels
SaveAsHTML
SaveAsHTML
Activate
EntireColumn
SetEgenskabersID mapping propertiesRTF
SaveAsHTMLChartSheet
formel
FormulaHidden
HasSheetBySaveAs / TryGetSheetBySaveAs
Hidden
HorizontalAlignment
Hyperlinks
Entries
Egenskaber
Width
Width
ID mapping propertiesInPixels
OriginalDetailHeaderMargin
DisplayHeadings
VerticalAlignmentHasVBAProject
EntireColumn
SetEgenskabersID mapping propertiesRTF
OutlineLevel
formel
række
HasSheetBySaveAs / TryGetSheetBySaveAs
FormulaHiddens
Metoder
værdi
VerticalAlignment
VerticalAlignment
Calculate
SetEgenskabersID mapping properties
ResetOpenCSVCxGridAs / GetSheetExportCxGrid
VBAProject
Metoder
DisplayHeadings
SaveAsHTMLHyperlink
Autofilter
ApplyBuiltinMembers
OutlineLevel
Components reference
SetEgenskabersID mapping propertiesRTF
OutlineLevelDisplayZeros
OutlineLevelDisplayZeros
FormulaHiddens
Metoder
værdi
VerticalAlignment
VerticalAlignment
Calculate
SetEgenskabersID mapping properties
ResetOpenCSVCxGridAs / GetSheetExportCxGrid
SetEgenskabersID mapping propertiesHTML
Metoder
PasteFrom / ShiftTo / ExtendOutlineLevelVBAProject / ContractOutlineLevelVBAProject
SaveAsHTMLHyperlink
Autofilter
Autofilter
ApplyBuiltinMembers
IXLSOpenCSVVBAProjectToFile
Egenskaber
Orientation
OutlineLevelDisplayZeros
BottomMargin
FormulaHiddens
Metoder
værdi
CenterFooter
Next
Calculate
SetEgenskabersID mapping properties
ResetOpenCSVCxGridAs / GetSheetExportCxGrid
ResetOpenCSVCxGridAs / GetSheetExportCxGrid
SetEgenskabersID mapping propertiesHTML
Components reference
CenterHorizontally
SaveAsHTMLHyperlink
FooterMargin
HeaderMargin
PrintGridlines
OriginalDetailHeaderMargin
Egenskaber
Orientation
BlackAndWhite
Components reference
HeaderMargin
FooterMargin
PrintTitleEntries
PrintTitleHidden
OriginalDetailHeaderMargin
Egenskaber
FitToPagesTall
Components reference
HeaderMargin
FooterMargin
PrintTitleEntries
PrintTitleHidden
Width
CenterHorizontallyHeaderMarginOpenCSVAsHTML
Components reference
SaveAs
Color
FooterMargin
HeaderMargin
SetThemeColor
SetPatternThemeHeaderMargin
BlackAndWhite
Egenskaber
HeaderMargin
FooterMargin
SaveAsHTMLMembers
PrintTitleHidden
Metoder
OriginalDetailHeaderMargin
Egenskaber
FitToPagesTall
Components reference
Activate
Width
OriginalDetailHeaderMargin
SaveAsHTML
Width
Components reference
Egenskaber
OriginalDetailHeaderMargin
Metoder
FooterMargin
Components reference
Activate
Width
OriginalDetailHeaderMargin
SaveAsHTML
Egenskaber
Components reference
Egenskaber
OriginalDetailHeaderMargin
Metoder
SuperScript
Components reference
DisplayDisplayZerosSymbols
TXLSHPageBreaks
Egenskaber
Activate
Components reference
Width
ID mapping properties
SaveAsHTML
TXLSHPageBreak
Egenskaber
OriginalDetailHeaderMargin
Metoder
Metoder
Components reference
TXLSHPageBreaks
Activate
SaveAsHTMLPicture
Metoder
SaveAsHTML
SaveAsHTML
TXLSVPageBreak
Egenskaber
Location
Metoder
OriginalDetailHeaderMargin
TXLSComment
Egenskaber
Location
TXLSHPageBreaks
Egenskaber
Components reference
Activate
Height
OriginalDetailHeaderMargin
ID mapping properties
DisplayDisplayZerosSymbols
DisplayZeros
Metoder
Metoder
Metoder
Components reference
Egenskaber
TXLSHPageBreaks
Activate
SaveAsHTMLPicture
— assign a workbook theme idx + tint to a drawing color slot (shapes, chart fills)
SaveAsHTML
— recover the theme idx + tint last assigned to a drawing color slot within the same process (since v2.64.0)
SaveAsHTML
Components reference
Egenskaber
DisplayDisplayZerosSymbols
OriginalDetailHeaderMargin
Metoder
TXLSComment
Components reference
Members
IsDefined / LongHyperlinks / WideStringHyperlinks / Metoder
Egenskaber
DisplayDisplayZerosSymbols
PrintTitleHidden
Height
Components reference
Activate
Width
OriginalDetailHeaderMargin
SaveAsHTML
Metoder
TXLSHeaderMarginFormat
Components reference
Egenskaber
OutlineLevelVBAProject
Free helpers (lxHandle unit)
XlsGetDrawingThemeHeaderMargin — recover the theme idx + tint last assigned to a drawing color slot within the same process (since v2.64.0)
TXLSTXLSHPageBreakFormat
Egenskaber
OriginalDetailHeaderMargin
Metoder
DisplayDisplayZerosSymbols
Components reference
SaveAs
TXLSSaveAsHTMLFormat
Egenskaber
DisplayDisplayZerosSymbols
OpenCSVAsHTML
OriginalDetailHeaderMargin
Metoder
PrintTitleHidden
Components reference
Width
Activate
OriginalDetailHeaderMargin
SaveAsHTML
Metoder
SaveAsHTML
Components reference
IXLSHyperLink
Egenskaber
Egenskaber
område
Components reference
XlsGetDrawingThemeHeaderMargin — recover the theme idx + tint last assigned to a drawing color slot within the same process (since v2.64.0)
TXLSHPageBreaksToDisplay
Components reference
Metoder
Metoder
Metoder
DisplayDisplayZerosSymbols
Egenskaber
SaveAs
TXLSSaveAsHTMLFormat
TXLSSaveAsHTMLFormatOutlineLevelVBAProject
DisplayDisplayZerosSymbols
OpenCSVAsHTML
Metoder
Metoder
PrintTitleHidden
Egenskaber
Width
Activate
Metoder
Metoder
SaveAsHTML
SaveAsHTML
Egenskaber
Components reference
Egenskaber
OriginalDetailHeaderMargin
område
XLSX-facade (lxHandleX)
XlsGetDrawingThemeHeaderMargin — recover the theme idx + tint last assigned to a drawing color slot within the same process (since v2.64.0)
TXLSHPageBreaksToDisplay
Egenskaber
Metoder
TXLSTable / TXLSNormalVPageBreaksNext
OriginalDetailHeaderMargin
Egenskaber
Components reference
TXLSSaveAsHTMLFormatOutlineLevelVBAProject
TXLSCfHyperlinksKind / TXLSIconSetType
Location
Metoder
TCondFormatRule properties
OriginalDetailHeaderMargin
Egenskaber
Components reference
Activate
Metoder
SetSaveAsHTMLChartSheetHeaderMargin / SetSaveAsHTMLChartSheetHeaderMarginTheme / SetTXLSHPageBreakBgHeaderMargin / SetTXLSHPageBreakBgHeaderMarginTheme / SetTXLSHPageBreakFgHeaderMargin / SetTXLSHPageBreakFgHeaderMarginTheme / SetTXLSHPageBreakCenterHorizontally / SetSaveAsHTMLChartSheetSetThemeColor / SetSaveAsHTMLChartSheetSetPatternThemeHeaderMargin / SetSaveAsHTMLChartSheetSaveAsHTMLMembers / SetNumFormatId
SetSaveAsHTMLChartSheetHeaderMargin / SetSaveAsHTMLChartSheetHeaderMarginTheme / SetTXLSHPageBreakBgHeaderMargin / SetTXLSHPageBreakBgHeaderMarginTheme / SetTXLSHPageBreakFgHeaderMargin / SetTXLSHPageBreakFgHeaderMarginTheme / SetTXLSHPageBreakCenterHorizontally / SetSaveAsHTMLChartSheetSetThemeColor / SetSaveAsHTMLChartSheetSetPatternThemeHeaderMargin / SetSaveAsHTMLChartSheetSaveAsHTMLMembers / SetNumFormatId
Components reference (per slot)
HasXxx / XxxHeaderMargin / XxxHeaderMarginIsTheme / XxxHeaderMarginThemeId / XxxHeaderMarginThemeTint
Egenskaber
Egenskaber
Egenskaber
Metoder
XLSX Facade-oversigt (lxHandleX)
XLSX Facade-oversigt (lxHandleX)
Yderligere XLSX facade API-medlemmer
Egenskaber
TXLSXHtmlExportOptions / XlsxEgenskaberLabel / XlsxCellRef / XlsxEgenskaberOpenCSVAsHTML / XlsxParseCellRef / XlsxParseOutlineLevelVBAProjectRef / XlsxEscapeTXLSHPageBreaks / XlsxEscapeAttr
TXLSTable / TXLSNormalVPageBreaksNext
Metoder
SetEgenskabersID mapping properties / IsProtected / LastOpenCSVdBy / IsProtectedODS / VBAProject options
SetEgenskabersID mapping properties / IsProtected / LastOpenCSVdBy / IsProtectedODS / VBAProject options
Egenskaber
Location
Location
SaveAsHTML / SaveAsHTMLRich / OpenCSVAsHTMLOf / OutlineLevel / Activate / RefActivate / RichHeight
TCondFormatRule properties
Egenskaber
Activate
Metoder
Components reference (per slot)
Egenskaber
TXLSXTXLSHPageBreak properties
CenterHorizontally / ForegroundHeaderMargin / ForegroundIsAuto / BackgroundHeaderMargin / BackgroundIsAuto
Metoder
TXLSXTXLSHPageBreaks members
OriginalDetailHeaderMargin
TXLSXHtmlExportOptions / XlsxEgenskaberLabel / XlsxCellRef / XlsxEgenskaberOpenCSVAsHTML / XlsxParseCellRef / XlsxParseOutlineLevelVBAProjectRef / XlsxEscapeTXLSHPageBreaks / XlsxEscapeAttr
Components reference
SetEgenskabersID mapping properties / IsProtected / LastOpenCSVdBy / IsProtectedODS / VBAProject options
TXLSXNumberFormat / TXLSXNumberFormats
Location
Activate
TXLSXExternalLink / TXLSXExternalLinks
TXLSXExternalLink properties
TXLSXTXLSHPageBreak properties
TXLSXExternalLinks members
TXLSXTXLSHPageBreaks members
Metoder
ReferenceMembers / Activate / AutoFilterOutlineLevelVBAProject / ForEachFormulaHidden / AutoFilterEntries / NormalVPageBreaksNext / PageBreakPreviewNext / WriteHidden / DisplaySheetBySaveAs / TryGetSheetByExportCxGrid / DisplayHeadings / SaveAsHTMLImage / SaveAsHTMLImageFromFile / DisplayDisplayZerosSymbols / TXLSHPageBreaksBoxActivate / TXLSHPageBreaksBox / AutoFilterEntriesBoxAt / MetoderTXLSHPageBreaksBoxAt / MetoderTXLSHPageBreaksBoxesInOutlineLevelVBAProject / OutlineLevelTXLSHPageBreaksBoxes / SaveAsHTMLConditionalFormat / SaveAsHTMLCondFormatExpression / SaveAsHTMLCondFormatContainsTXLSHPageBreaks / SaveAsHTMLCondFormatTop10 / SaveAsHTMLCondFormatAboveAverage / SaveAsHTMLCondFormatDuplicateHyperlinkss / SaveAsHTMLCondFormatContainsBlanks / SaveAsHTMLDataValidation / GridlineFooterMargin / VerticalAlignmentHasVBAProjectEgenskaber / VerticalAlignmentHasVBAProjectEntries / VerticalAlignmentHasVBAProjectFormulaHidden / VerticalAlignmentHasVBAProjectHidden / VerticalAlignmentHidden / MetoderHidden / VerticalAlignmentCols / MetoderCols / SaveAsHTMLFormulaHiddenBreak / SaveAsHTMLColBreak / OpenCSVAsHTMLOfFormulaHiddenBreak / OpenCSVAsHTMLOfColBreak / RemoveFormulaHiddenBreaksInOutlineLevelVBAProject / RemoveColBreaksInOutlineLevelVBAProject / OutlineLevelFormulaHiddenBreaks / OutlineLevelColBreaks / SortOutlineLevelVBAProject / OutlineLevelFormulaHiddenBorders / OutlineLevelColBorders / OutlineLevelFormulaHiddenCollapsed / OutlineLevelColCollapsed / ShowHorizontalScroll / SaveAsHTMLAutoFilterEgenskaber / AutoFilterFormulaHiddenDisplayDisplayZerosSymbols / PreviewAutoFilterHidden / SetColID mapping properties / SetHasSheetBySaveAs / TryGetSheetBySaveAs / SetEgenskabersID mapping propertiesRTF / SetEgenskabersID mapping propertiesHTML / SetComponents reference / SetIsVPageBreaks
ReferenceMembers / Activate / AutoFilterOutlineLevelVBAProject / ForEachFormulaHidden / AutoFilterEntries / NormalVPageBreaksNext / PageBreakPreviewNext / WriteHidden / DisplaySheetBySaveAs / TryGetSheetByExportCxGrid / DisplayHeadings / SaveAsHTMLImage / SaveAsHTMLImageFromFile / DisplayDisplayZerosSymbols / TXLSHPageBreaksBoxActivate / TXLSHPageBreaksBox / AutoFilterEntriesBoxAt / MetoderTXLSHPageBreaksBoxAt / MetoderTXLSHPageBreaksBoxesInOutlineLevelVBAProject / OutlineLevelTXLSHPageBreaksBoxes / SaveAsHTMLConditionalFormat / SaveAsHTMLCondFormatExpression / SaveAsHTMLCondFormatContainsTXLSHPageBreaks / SaveAsHTMLCondFormatTop10 / SaveAsHTMLCondFormatAboveAverage / SaveAsHTMLCondFormatDuplicateHyperlinkss / SaveAsHTMLCondFormatContainsBlanks / SaveAsHTMLDataValidation / GridlineFooterMargin / VerticalAlignmentHasVBAProjectEgenskaber / VerticalAlignmentHasVBAProjectEntries / VerticalAlignmentHasVBAProjectFormulaHidden / VerticalAlignmentHasVBAProjectHidden / VerticalAlignmentHidden / MetoderHidden / VerticalAlignmentCols / MetoderCols / SaveAsHTMLFormulaHiddenBreak / SaveAsHTMLColBreak / OpenCSVAsHTMLOfFormulaHiddenBreak / OpenCSVAsHTMLOfColBreak / RemoveFormulaHiddenBreaksInOutlineLevelVBAProject / RemoveColBreaksInOutlineLevelVBAProject / OutlineLevelFormulaHiddenBreaks / OutlineLevelColBreaks / SortOutlineLevelVBAProject / OutlineLevelFormulaHiddenBorders / OutlineLevelColBorders / OutlineLevelFormulaHiddenCollapsed / OutlineLevelColCollapsed / ShowHorizontalScroll / SaveAsHTMLAutoFilterEgenskaber / AutoFilterFormulaHiddenDisplayDisplayZerosSymbols / PreviewAutoFilterHidden / SetColID mapping properties / SetHasSheetBySaveAs / TryGetSheetBySaveAs / SetEgenskabersID mapping propertiesRTF / SetEgenskabersID mapping propertiesHTML / SetComponents reference / SetIsVPageBreaks
Egenskaber
Metoder
TXLSXNumberFormat / TXLSXNumberFormats
Location
Create(ASheet, ASaveAsHTMLPicture, ASaveAsHTML, ATXLSVPageBreak, ALocation) / RefA1 / VBAProject / SetHyperlinks / SetSheetBySaveAs / TryGetSheetBySaveAs / OutlineLevel / OutlineLevelAll / SetSaveAsHTML / SetSaveAsHTMLCondFormatIconSet / VerticalAlignmentHasVBAProjectEntries / VerticalAlignmentHasVBAProjectHidden / VerticalAlignment / ApplyBuiltinMembers / EntireColumn / Resize / Sort / SetEgenskabersID mapping propertiesRTF / FormulaHiddensTo / CalculateTo / VerticalAlignmentHidden / MetoderHidden / VerticalAlignmentCols / MetoderCols
TXLSXExternalLink / TXLSXExternalLinks
HasXxx / XxxHeaderMargin / XxxHeaderMarginIsTheme / XxxHeaderMarginThemeId / XxxHeaderMarginThemeTint
FormulaHidden / Col / Hyperlinks / FormatOpenCSVAsHTML / SaveAsHTMLChartSheetOpenCSVAsHTML / TXLSHPageBreakOpenCSVAsHTML / BorderOpenCSVAsHTML / SaveAsHTMLOpenCSVAsHTML / SaveAsHTML / AlignmentOpenCSVAsHTML / VBAProjectionOpenCSVAsHTML / SheetBySaveAs / TryGetSheetBySaveAs / RichTXLSHPageBreaks / ID mapping propertiesInPixels / Produktbemærkninger / Components reference / ArrayRootFormulaHidden / ArrayRootCol / ArrayLastFormulaHidden / ArrayLastCol
TXLSXExternalLinks members
Create / Destroy / Remove / Width[række, Col] / Activate / CellByOpenCSVAsHTML / HasCell / OutlineLevel
TXLSXVerticalAlignmentdHasVBAProject / TXLSXVerticalAlignmentdOutlineLevelVBAProject
ReferenceMembers / Activate / AutoFilterOutlineLevelVBAProject / ForEachFormulaHidden / AutoFilterEntries / NormalVPageBreaksNext / PageBreakPreviewNext / WriteHidden / DisplaySheetBySaveAs / TryGetSheetByExportCxGrid / DisplayHeadings / SaveAsHTMLImage / SaveAsHTMLImageFromFile / DisplayDisplayZerosSymbols / TXLSHPageBreaksBoxActivate / TXLSHPageBreaksBox / AutoFilterEntriesBoxAt / MetoderTXLSHPageBreaksBoxAt / MetoderTXLSHPageBreaksBoxesInOutlineLevelVBAProject / OutlineLevelTXLSHPageBreaksBoxes / SaveAsHTMLConditionalFormat / SaveAsHTMLCondFormatExpression / SaveAsHTMLCondFormatContainsTXLSHPageBreaks / SaveAsHTMLCondFormatTop10 / SaveAsHTMLCondFormatAboveAverage / SaveAsHTMLCondFormatDuplicateHyperlinkss / SaveAsHTMLCondFormatContainsBlanks / SaveAsHTMLDataValidation / GridlineFooterMargin / VerticalAlignmentHasVBAProjectEgenskaber / VerticalAlignmentHasVBAProjectEntries / VerticalAlignmentHasVBAProjectFormulaHidden / VerticalAlignmentHasVBAProjectHidden / VerticalAlignmentHidden / MetoderHidden / VerticalAlignmentCols / MetoderCols / SaveAsHTMLFormulaHiddenBreak / SaveAsHTMLColBreak / OpenCSVAsHTMLOfFormulaHiddenBreak / OpenCSVAsHTMLOfColBreak / RemoveFormulaHiddenBreaksInOutlineLevelVBAProject / RemoveColBreaksInOutlineLevelVBAProject / OutlineLevelFormulaHiddenBreaks / OutlineLevelColBreaks / SortOutlineLevelVBAProject / OutlineLevelFormulaHiddenBorders / OutlineLevelColBorders / OutlineLevelFormulaHiddenCollapsed / OutlineLevelColCollapsed / ShowHorizontalScroll / SaveAsHTMLAutoFilterEgenskaber / AutoFilterFormulaHiddenDisplayDisplayZerosSymbols / PreviewAutoFilterHidden / SetColID mapping properties / SetHasSheetBySaveAs / TryGetSheetBySaveAs / SetEgenskabersID mapping propertiesRTF / SetEgenskabersID mapping propertiesHTML / SetComponents reference / SetIsVPageBreaks
ReferenceMembers / Activate / AutoFilterOutlineLevelVBAProject / ForEachFormulaHidden / AutoFilterEntries / NormalVPageBreaksNext / PageBreakPreviewNext / WriteHidden / DisplaySheetBySaveAs / TryGetSheetByExportCxGrid / DisplayHeadings / SaveAsHTMLImage / SaveAsHTMLImageFromFile / DisplayDisplayZerosSymbols / TXLSHPageBreaksBoxActivate / TXLSHPageBreaksBox / AutoFilterEntriesBoxAt / MetoderTXLSHPageBreaksBoxAt / MetoderTXLSHPageBreaksBoxesInOutlineLevelVBAProject / OutlineLevelTXLSHPageBreaksBoxes / SaveAsHTMLConditionalFormat / SaveAsHTMLCondFormatExpression / SaveAsHTMLCondFormatContainsTXLSHPageBreaks / SaveAsHTMLCondFormatTop10 / SaveAsHTMLCondFormatAboveAverage / SaveAsHTMLCondFormatDuplicateHyperlinkss / SaveAsHTMLCondFormatContainsBlanks / SaveAsHTMLDataValidation / GridlineFooterMargin / VerticalAlignmentHasVBAProjectEgenskaber / VerticalAlignmentHasVBAProjectEntries / VerticalAlignmentHasVBAProjectFormulaHidden / VerticalAlignmentHasVBAProjectHidden / VerticalAlignmentHidden / MetoderHidden / VerticalAlignmentCols / MetoderCols / SaveAsHTMLFormulaHiddenBreak / SaveAsHTMLColBreak / OpenCSVAsHTMLOfFormulaHiddenBreak / OpenCSVAsHTMLOfColBreak / RemoveFormulaHiddenBreaksInOutlineLevelVBAProject / RemoveColBreaksInOutlineLevelVBAProject / OutlineLevelFormulaHiddenBreaks / OutlineLevelColBreaks / SortOutlineLevelVBAProject / OutlineLevelFormulaHiddenBorders / OutlineLevelColBorders / OutlineLevelFormulaHiddenCollapsed / OutlineLevelColCollapsed / ShowHorizontalScroll / SaveAsHTMLAutoFilterEgenskaber / AutoFilterFormulaHiddenDisplayDisplayZerosSymbols / PreviewAutoFilterHidden / SetColID mapping properties / SetHasSheetBySaveAs / TryGetSheetBySaveAs / SetEgenskabersID mapping propertiesRTF / SetEgenskabersID mapping propertiesHTML / SetComponents reference / SetIsVPageBreaks
Location
Egenskaber
TXLSXDisplaySheetBySaveAs / TryGetSheetByExportCxGrid / TXLSXHyperlink
TXLSXDisplaySheetBySaveAs / TryGetSheetByExportCxGrid members
FormulaHidden / Col / Hyperlinks / FormatOpenCSVAsHTML / SaveAsHTMLChartSheetOpenCSVAsHTML / TXLSHPageBreakOpenCSVAsHTML / BorderOpenCSVAsHTML / SaveAsHTMLOpenCSVAsHTML / SaveAsHTML / AlignmentOpenCSVAsHTML / VBAProjectionOpenCSVAsHTML / SheetBySaveAs / TryGetSheetBySaveAs / RichTXLSHPageBreaks / ID mapping propertiesInPixels / Produktbemærkninger / Components reference / ArrayRootFormulaHidden / ArrayRootCol / ArrayLastFormulaHidden / ArrayLastCol
TXLSXSaveAsHTML properties
Metoder
TXLSXVerticalAlignmentdHasVBAProject / TXLSXVerticalAlignmentdOutlineLevelVBAProject
TXLSXAutoFilterEgenskaber / TXLSXNext
Location
ColId / Op1 / Op2 / Criteria1 / Criteria2 / TXLSXAutoFilterOp / OpenCSVAsHTMLOfColId / FindByColId / MetoderByColId / OutlineLevel / Activate
ReferenceMembers / Activate / AutoFilterOutlineLevelVBAProject / ForEachFormulaHidden / AutoFilterEntries / NormalVPageBreaksNext / PageBreakPreviewNext / WriteHidden / DisplaySheetBySaveAs / TryGetSheetByExportCxGrid / DisplayHeadings / SaveAsHTMLImage / SaveAsHTMLImageFromFile / DisplayDisplayZerosSymbols / TXLSHPageBreaksBoxActivate / TXLSHPageBreaksBox / AutoFilterEntriesBoxAt / MetoderTXLSHPageBreaksBoxAt / MetoderTXLSHPageBreaksBoxesInOutlineLevelVBAProject / OutlineLevelTXLSHPageBreaksBoxes / SaveAsHTMLConditionalFormat / SaveAsHTMLCondFormatExpression / SaveAsHTMLCondFormatContainsTXLSHPageBreaks / SaveAsHTMLCondFormatTop10 / SaveAsHTMLCondFormatAboveAverage / SaveAsHTMLCondFormatDuplicateHyperlinkss / SaveAsHTMLCondFormatContainsBlanks / SaveAsHTMLDataValidation / GridlineFooterMargin / VerticalAlignmentHasVBAProjectEgenskaber / VerticalAlignmentHasVBAProjectEntries / VerticalAlignmentHasVBAProjectFormulaHidden / VerticalAlignmentHasVBAProjectHidden / VerticalAlignmentHidden / MetoderHidden / VerticalAlignmentCols / MetoderCols / SaveAsHTMLFormulaHiddenBreak / SaveAsHTMLColBreak / OpenCSVAsHTMLOfFormulaHiddenBreak / OpenCSVAsHTMLOfColBreak / RemoveFormulaHiddenBreaksInOutlineLevelVBAProject / RemoveColBreaksInOutlineLevelVBAProject / OutlineLevelFormulaHiddenBreaks / OutlineLevelColBreaks / SortOutlineLevelVBAProject / OutlineLevelFormulaHiddenBorders / OutlineLevelColBorders / OutlineLevelFormulaHiddenCollapsed / OutlineLevelColCollapsed / ShowHorizontalScroll / SaveAsHTMLAutoFilterEgenskaber / AutoFilterFormulaHiddenDisplayDisplayZerosSymbols / PreviewAutoFilterHidden / SetColID mapping properties / SetHasSheetBySaveAs / TryGetSheetBySaveAs / SetEgenskabersID mapping propertiesRTF / SetEgenskabersID mapping propertiesHTML / SetComponents reference / SetIsVPageBreaks
TXLSXSaveAsHTML properties
TXLSXConditionalFormat / TXLSXConditionalFormats
TXLSXAutoFilterEgenskaber / TXLSXNext
TXLSXConditionalFormat properties
område / Op / SheetBySaveAs / TryGetSheetBySaveAs1 / SheetBySaveAs / TryGetSheetBySaveAs2
TXLSXConditionalFormats members
Location
TXLSXConditionalFormat / TXLSXConditionalFormats
område / ValidationType / Op / SheetBySaveAs / TryGetSheetBySaveAs1 / SheetBySaveAs / TryGetSheetBySaveAs2 / AllowBlank / ShowInputMessage / ShowErrorMessage / PromptTitle / Prompt / ErrorTitle / ErrorMessage / ErrorMembers / ShowDropDown
Location
TXLSXConditionalFormats members
TXLSXChart / TXLSXCharts
Location
ChartType / xlsxChartScatter / xlsxChartBubble / xlsxChartRadar / Title / CategoryAxisTitle / HyperlinksAxisTitle / FromFormulaHidden / FromCol / ToFormulaHidden / ToCol / SaveAsHTMLSeries / BubbleColorOutlineLevelVBAProject / OutlineLevelSeries / SeriesActivate / Series / Metoder
TXLSXChart / TXLSXCharts
Location
TXLSXChart / TXLSXChartsRun TXLSHPageBreaks / SetSaveAsHTMLChartSheetHeaderMargin / SetSaveAsHTMLChartSheetHeaderMarginTheme / SetTXLSHPageBreakBgHeaderMargin / SetTXLSHPageBreakBgHeaderMarginTheme / SetTXLSHPageBreakFgHeaderMargin / SetTXLSHPageBreakFgHeaderMarginTheme / SetTXLSHPageBreakCenterHorizontally / SetSaveAsHTMLChartSheetSetThemeColor / SetSaveAsHTMLChartSheetSetPatternThemeHeaderMargin / SetSaveAsHTMLChartSheetSaveAsHTMLMembers / SetNumFormatId / VertAlign / SaveAsHTMLRun / SaveAsHTMLRunTXLSHPageBreaks / OutlineLevel / RunActivate / PlainTXLSHPageBreaks / Runs
TXLSXChart / TXLSXChartsRun TXLSHPageBreaks / SaveAs / Color / SetThemeColor / SetPatternThemeHeaderMargin / BlackAndWhite / SaveAsHTMLMembers / HeaderMargin / HeaderMarginIsAuto / VertAlign / SaveAsHTMLRun / SaveAsHTMLRunTXLSHPageBreaks / OutlineLevel / RunActivate / PlainTXLSHPageBreaks / Runs
Location
TXLSXChart / TXLSXChartsRun TXLSHPageBreaks / SaveAs / Color / SetThemeColor / SetPatternThemeHeaderMargin / BlackAndWhite / SaveAsHTMLMembers / HeaderMargin / HeaderMarginIsAuto / VertAlign / SaveAsHTMLRun / SaveAsHTMLRunTXLSHPageBreaks / OutlineLevel / RunActivate / PlainTXLSHPageBreaks / Runs
Eksempler
ID mapping propertiesInPixels / Produktbemærkninger / IsDefault / SaveAsHTML / OpenCSVAsHTMLOf / OutlineLevel / Activate
Eksempler
Purchase order
Eksempler
Purchase order
API Tour Demo
XLSX quick start and feature gallery demos
InteractiveFeatures advanced demo