ExcelXMLFile

📊 Overview: 7 Properties

1 Constructor

7 Functions

📝 Description

Converts a 4D selection-based listbox to Excel rows with styled cells matching listbox appearance

🕐 Last updated: 2025-12-10T11:45:22.894Z

---

📑 Table of Contents

• 📋 Properties (7)
• 🏗️ Constructor
• ⚙️ Functions
  • Regular Functions
    • addSelectionBasedListbox (1 param)
    • setFreezePanes (2 params)
    • addColumn (2 params)
    • addRow (1 param)
    • addStyle (1 param) → Text
    • saveToClipboard (2 params)
    • generate

---

Properties

Property	Type	Default	Description
Styles	Collection	[]	Collection of ExcelXMLFileStyle objects for cell formatting
Rows	Collection	[]	Collection of ExcelXMLFileRow objects representing worksheet rows
Columns	Collection	[]	Collection of column width definitions
FileContents	Text	""	Generated XML content for Excel file
FreezeRowsAbove	Integer	0	Number of rows to freeze at top of worksheet
FreezeRowsToLeft	Integer	0	Number of columns to freeze at left of worksheet
ConditionalFormatting	Object	-	Conditional formatting rules for cells

Constructor

constructor

[🏗️ constructor]

Class constructor

Creates a new Excel XML file object with empty collections

---

Functions

Regular Functions

addSelectionBasedListbox

Function addSelectionBasedListbox($ListboxName : Text)

Converts a 4D selection-based listbox to Excel rows with styled cells matching listbox appearance

Parameters:

Name	Type	Optional	Description
$ListboxName	Text	-	-

---

setFreezePanes

Function setFreezePanes($RowsAbove : Integer; $RowsToLeft : Integer)

Parameters:

Name	Type	Optional	Description
$RowsAbove	Integer	-	-
$RowsToLeft	Integer	-	-

---

addColumn

Function addColumn($Width : Real; $Span : Integer)

Parameters:

Name	Type	Optional	Description
$Width	Real	-	-
$Span	Integer	-	-

---

addRow

Function addRow($ExcelXMLFileRow : cs.ExcelXMLFileRow)

Parameters:

Name	Type	Optional	Description
$ExcelXMLFileRow	cs.ExcelXMLFileRow	-	-

---

addStyle

Function addStyle($NewExcelXMLFileStyle : cs.ExcelXMLFileStyle) -> Text

Parameters:

Name	Type	Optional	Description
$NewExcelXMLFileStyle	cs.ExcelXMLFileStyle	-	-

Returns: Text

---

saveToClipboard

Function saveToClipboard($FileNameWithoutExtension : Text; $ShowAlert : Boolean)

Parameters:

Name	Type	Optional	Description
$FileNameWithoutExtension	Text	-	-
$ShowAlert	Boolean	-	-

---

generate

Function generate

---

---

Generated from ExcelXMLFile.4dm