Name 

Description 

 

AddFont 

Adds a new font to the excel font list. If it already exists, it doesn't add a new one, so you can use this method for searching too.  

 

AddFormat 

Adds a new format to the global format list.  

 

AddHyperLink 

Adds a new hyperlink to the Active sheet. Use SetHyperLink to modify an existing one.  

 

AddPicture 

This is the overview for the AddPicture method overload. 

 

AssignCellFormulaX 

Enters a Formula into a cell.  

 

AssignPicture 

This is the overview for the AssignPicture method overload. 

 

AssignPictureProperties 

Changes the properties of an existing image.  

 

AutofitCol 

This is the overview for the AutofitCol method overload. 

 

AutofitRow 

This is the overview for the AutofitRow method overload. 

 

AutofitRowsOnWorkbook 

Autofits all rhe rows on all sheets on a workbook that are set to autofit so they adapt their height to show all the text inside. Note that due to GDI+ / GDI incompatibilities, the heights calculated by FlexCel will not be exactly the same than the ones calculated by Excel. So when you open this workbook in Excel, Excel might re calculate the row heights to what it believe is best. You can change this behaviour specifying keepSizesAutomatic = false.  

 

CanOptimizeRead 

Internal use.  

 

CellMergedListCount 

For using with CellMergedList on a loop: for i:=0 to CellMergedListCount-1 do CellMergedList[i]...  

 

ClearPicture 

Clears an image on the active sheet.  

 

ClearSheet 

Clears all data on the active sheet, but does not delete it.  

 

CloseFile 

Closes an open Excel Workbook.  

 

CopyToClipboard 

This is the overview for the CopyToClipboard method overload. 

 

DefaultFormat 

This method has been deprecated. Use GetDefaultFormat instead.
 

 

DeleteCols 

Deletes a range of columns  

 

DeleteHPageBreak 

Deletes the Horizontal page breaks at the specified row  

 

DeleteHyperLink 

Deletes an existing hyperlink.  

 

DeletePicture 

Deletes an image on the active sheet.  

 

DeleteRows 

Deletes a range of rows  

 

DeleteSheet 

Deletes the active sheet and SheetCount-1 sheets more to the right.  

 

DeleteVPageBreak 

Deletes the Vertical page breaks at the specified column.  

 

FillPageHeaderFooter 

Splits a string containing an Excel header/footer into 3 members, the right middle and left parts.  

 

FreezePanes 

Freezes the panes on the active sheet.  

 

GetCellComment 

Returns the comment at cell (Row, Column)  

 

GetCellFormatDef 

Returns the default format for an empty cell.  

 

GetColOutlineLevel 

Returns the Outline level for a column.  

 

GetDefaultFormat 

Returns the Excel standard format for an empty cell.  

 

GetFontList 

Returns the font definition for a given font index. (0 based)  

 

GetFormatList 

Returns a TFlxFormat structure where you can read the borders/color/font/etc for an existing XF format index (0 based).  

 

GetFrozenPanes 

Returns the cell that is freezing the window.  

 

GetHyperLink 

Returns the hyperlink at position index on the list.  

 

GetHyperLinkCellRange 

Returns the cell range a hyperlink refers to.  

 

GetPicture 

Retrieves an image from a sheet.  

 

GetRowOutlineLevel 

Returns the Outline level for a row.  

 

GetSplitWindow 

Returns the horizontal and vertical offsets for the split windows.  

 

GetUsedPaletteColors 

Returns a list of the colors in the Excel palette that are actually used in your file.  

 

GetWorkbook 

GetWorkbook will return the internal XlsAdapter instance used by FlexCelImport. You should not use this value.  

 

HasHPageBreak 

True if there is a page break at the specified row  

 

HasVPageBreak 

True if there is a page break at the specified column  

 

HyperLinkCount 

The count of hyperlinks on the active sheet.  

 

InsertAndCopyCols 

Copies a range of columns aCount times, inserting it into a new location  

 

InsertAndCopyRows 

Copies a range of rows aCount times, inserting it into a new location  

 

InsertAndCopySheets 

Inserts and copies sheet "CopyFromShet", SheetCount times before InsertBeforeSheet. To insert empty sheets, set CopyFromSheet=0.  

 

InsertEmptySheets 

Inserts a number of empty sheets at the specified position.
 

 

InsertHPageBreak 

Inserts an Horizontal Page Break at the specified row.  

 

InsertVPageBreak 

Inserts a Vertical Page Break at the specified column.  

 

IsEmptyRow 

True when the row contains no cells.  

 

IsLoaded 

True if a spreadsheet has been loaded.  

 

LoadFromStream 

This method is similar to OpenFile, but it reads a stream instead of a file.  

 

LoadFromTextStream 

This is the overview for the LoadFromTextStream method overload. 

 

MergeCells 

Merges multiple cells into one.  

 

NearestColorIndex 

This is the overview for the NearestColorIndex method overload. 

 

NewFile 

This method will create an empty Excel file, that you can fill with the API.
 

 

OpenFile 

This opens an Excel file for reading/writing. If you are using a TemplateStore, the file will be read from there.  

 

OpenText 

This is the overview for the OpenText method overload. 

 

PasteFromClipboard 

This method will paste data from the clipboard into a FlexCel sheet, beginning at the specified row and column.  

 

Save 

This method saves the file with the specified filename on Excel format.  

 

SaveAsText 

Saves the file as Text.  

 

SaveToStream 

This method saves the file to the specified stream.  

 

SaveToStreamAsText 

Saves the file as Text to a stream.  

 

SetCellComment 

This is the overview for the SetCellComment method overload. 

 

SetCellString 

This is the overview for the SetCellString method overload. 

 

SetColOutlineLevel 

Sets the Outline level for a column range.  

 

SetFontList 

Changes a font entry on the font list for the workbook.  

 

SetFormatList 

Changes a style on the global list of styles on an Excel file.  

 

SetHyperLink 

Modifies an existing Hyperlink.  

 

SetHyperLinkCellRange 

Changes the cells an hyperlink is linked to.  

 

SetNamedRange 

Modifies or adds a Named Range. If the named range exists, it will be modified, else it will be added. If the range is not user defined (like "Print_Range") it will have a one-char name, and the value is one of the constants: InternalNameRange_... Look at the example for more information.  

 

SetRowOutlineLevel 

Sets the Outline level for a row range.  

 

SplitWindow 

This command is equivalent to Menu->Window->Split.  

 

UnMergeCells 

Unmerges the range of cells.