Element Details: Excel+Column+Format
 Back


Available in: Logi Info Source code name: ExcelColumnFormat

Excel Column Format works with Action.ExportToNativeExcel and Target.ExportToNativeExcel. It controls the details of how a column will be exported to Excel, including the column width, display format, and font.



ATTRIBUTES

Click attribute Name to drill down for more information.

NamePossible ValuesDescription
DataType
Text
Number
Date
Boolean
Specifies the type of data present.
ExcelAutoFitRow
True
False
When set to True for any column, the height of the Excel rows is automatically adjusted to fit the data.
ExcelColumnWidth
UserDefined
Auto
The width of the Excel column. The number represents the average character width for the current font. For example, a value of 10 would indicate a column that is usually able to contain 10 characters.
ExcelFormat
UserDefined
Specifies an Excel data format string. It's important to set the column's Data Type for the Excel Format to work.
ExcelShrinkToFit
True
False
When True, the cell font of text that is too long to be displayed in a single cell will be shrunk to make it fit.
ExcelWrapText
True
False
When True, text that is too long to be displayed in a single Excel cell is wrapped into additional rows.
FontBold
True
False
The bold font.
FontItalic
True
False
When True, selects the italic font.
FontName
UserDefined
Specifies the name of a font.
FontSize
UserDefined
Specifies the size of the text.



PARENT ELEMENTS

Click element to drill down for more information.

Analysis Grid Column
Column Cell 		Crosstab Table Header Column
Crosstab Table Label Column 		Crosstab Table Summary Column
Crosstab Table Value Columns 		Data Table Column


CHILD ELEMENTS

Click element to drill down for more information.



 Back to top


Chart Debug