TFlexCelImport Properties

The properties of the TFlexCelImport class are listed here.

	Name	Description
	ActiveFileName	The name of the loaded file.
	ActiveSheet	The Active Sheet.
	ActiveSheetCodeName	Returns the codename of a sheet, that is an unique identifier assigned to the sheet when it is created.
	ActiveSheetName	This is the name of the active sheet, you can read it or change it.
	ActiveSheetVisible	Sets the visibility of the active sheet.
	AutoRowHeight	True if Excel AutoFit is on.
	Cell	Returns or sets the Cell value and format of the cell at the same time.
	CellFormat	Cell Format for a given cell
	CellFormatDef	This method has been deprecated. Use GetCellFormatDef instead.
	CellFormula	Formula on a cell, as a string.
	CellMergedBounds	When the cell at (aRow, aCol)is a merged cell, this method will return the first and last cell on the merged range.
	CellMergedList	Returns the Merged cell at position index on the mergedcell list
	CellValue	Value of a given cell.
	ColByIndex	Column position given an index on the array of used columns.
	ColIndex	Index on the array of used columns for a given column position.
	ColIndexCount	Total used columns on a row.
	ColorPalette	Associates an index into a color palette with a real color.
	ColorPaletteCount	The number of entries on the color palette.
	ColumnFormat	This is the XF format index associated to a column.
	ColumnHidden	Gets/Sets if a column is hidden or not.
	ColumnWidth	Gets or sets the current Column width, in Excel internal units. (Character width of "font 0" / 256)
	Comments	Comment at the Index position
	CommentsCount	Number of comments on the worksheet.
	DefaultColWidth	Default column width
	DefaultRowHeight	Default row height
	FontList	This property has been deprecated. Use GetFontList and SetFontList instead.
	FontListCount	Number of fonts in the workbook font list.
	FormatList	This property has been deprecated. Use GetFormatList and SetFormatList instead.
	FormatListCount	Total number of XF structures on the workbook
	InvalidateFormulas	Read this property to learn if you have modified since you opened it in FlexCel.
	IsFormula	True if the cell contains a formula.
	IsXltTemplate	Determines if the file is a template (xlt format instead of xls). Both file formats are nearly identical, but there is an extra record needed so the file is a proper xlt template.
	MaxCol	Number of used columns on the active sheet.
	MaxRow	Number of used rows on the active sheet.
	Options1904Dates	Sets and Gets the value of the Dates 1904 setting for this file.
	OptionsPrecisionAsDisplayed	Sets and Gets the value of the Precision as displayed setting for this file.
	OptionsR1C1	Sets and Gets the value of the R1C1 setting for this file.
	OptionsSaveExternalLinkValues	Sets and Gets the value of the SaveExternal Link Values setting for this file.
	OutlineAutomaticStyles	This handles the setting of Automatic Styles inside the outline options.
	OutlineSummaryColsRightOfDetail	Determines whether the summary columns should be right to or left to the details on outline.
	OutlineSummaryRowsBelowDetail	Determines whether the summary rows should be below or above details on outline.
	PageFooter	Footer to print on each page.
	PageHeader	Header to print on each page.
	PictureName	Picture Name for a given index
	PicturesCount	Number of images on the active sheet.
	PrintCopies	Number of copies to print.
	PrinterDriverSettings	Reads and writes the printer driver settings of a file. This property is used to copy printer driver information from one file to other.
	PrintGridLines	True if grid lines will be printed.
	PrintMargins	Margins used when printing the sheet
	PrintNumberOfHorizontalPages	Number of horizontal pages to fit the printing.
	PrintNumberOfVerticalPages	Number of vertical pages to fit the printing.
	PrintOptions	Miscellaneous printing options.
	PrintPaperSize	Pre-defined standard paper size.
	PrintScale	Scale to print the page.
	PrintToFit	Specifies whether to use the PrintScale or the PrintNumberOfHorizontalPages and PrintNumberOfVerticalPages properties to scale the printed page.
	PrintXResolution	Horizontal printer resolution in DPI.
	PrintYResolution	Vertical printer resolution in DPI.
	RangeC1	Returns the first column for a named range, and allows you to modify it.
	RangeC2	Returns the second column for a named range, and allows you to modify it.
	RangeCount	The number of named ranges in the workbook.
	RangeName	Returns the name of the named range at position index.
	RangeR1	Returns the first row for a named range, and allows you to modify it.
	RangeR2	Returns the second column for a named range, and allows you to modify it.
	RangeSheet	Returns the sheet where the range is located. A value of 0 means that the range is global to all the workbook.
	RowFormat	This is the XF format index associated to a row.
	RowHeight	Gets or sets the current Row Height, in Excel internal units. (1/20th of a point)
	RowHidden	Gets or sets if a row is hidden or visible.
	RTFRuns	Use this property to read or write rich format on a cell.
	SheetCount	Number of sheets in the workbook.
	SheetZoom	Returns/ set the zoom for a sheet.
	ShowGridHeaders	If true, Excel will show the A, B, C and 1, 2, 3 row and column headers.
	ShowGridLines	True if showing grid lines.

Published Properties

	Name	Description
	Adapter	Adapter this component will use to access the actual file.

Links

TFlexCelImport Class, Legend, Public Properties, Published Properties

What do you think about this topic? Send feedback!