# All Identifiers

Name | Unit | Description
--- | --- | ---
AxPUCChar | XLSUtils5 |
AxUCChar | XLSUtils5 |
AxUCString | XLSUtils5 |
BoolAsWord | XLSUtils5 |
BytesToHexStr | XLSUtils5 |
CharInSet | XLSUtils5 |
CmToEmu | XLSUtils5 |
ComponentName | XLSUtils5 |
CopyAllCells | XLSSheetData5 | What parts of the data on a worksheet that shall be copied/moved.
CPos | XLSUtils5 |
CPos | XLSUtils5 |
CurrentBuildNumber | XLSUtils5 |
CurrentVersionNumber | XLSUtils5 |
DefaultDeleteOptions | XLSSheetData5 |
ecAssertion | XLSRTFReadWrite5 |
ecBadTable | XLSRTFReadWrite5 |
ecEndOfFile | XLSRTFReadWrite5 |
ecInvalidHex | XLSRTFReadWrite5 |
ecOK | XLSRTFReadWrite5 |
ecStackOverflow | XLSRTFReadWrite5 |
ecStackUnderflow | XLSRTFReadWrite5 |
ecUnmatchedBrace | XLSRTFReadWrite5 |
EmptyGUID | XLSUtils5 |
EmuToCm | XLSUtils5 |
EMU_PER_PT | XLSUtils5 |
ExportCSV | XLSExportCSV5 | This routin will export the content of a worksheet to a text (CSV) file. ˜param XLS The XLSReadWriteII object to export. ˜param SheetIndex Index of the work sheet to export. ˜param QuoteChar Quote character for text strings. ˜param SeparatorChar The character used to separate the cell values (fields) in the file. Common used characters are comma, semicolon and tab. ˜param Options File export options. ˜param Filename The name of the file that the cells shall be exported to.
Fork | XLSUtils5 |
Fork | XLSUtils5 |
FormatSettings | XLSUtils5 |
G_Counter | XLSUtils5 |
G_DirSepChar | XLSUtils5 |
ImportCSV | XLSImportCSV5 |
ImportCSV | XLSImportCSV5 | This routine will import a text (CSV) file into a worksheet. Any existing cells on the worksheet will be overwritten. Correct value for decimal separator is detected automatically. See alse ˜[link ImportCSVAuto] ˜param XLS The target XLSReadWriteII object. ˜param SheetIndex The index to the worksheet where the file will be imported to. ˜param Col Left column where the imported data will be written. ˜param Row Top row where the imported data will be written. ˜param Filename The name of the text file that shall be imported. ˜param SepChar Separator character for the fields (cells) in the source file. ˜param HasQuoteChar Set this to True if strings in the source file are quoted. ˜result The number of cells that where imported.
ImportCSVAuto | XLSImportCSV5 | This routine will import a text (CSV) file into a worksheet. Any existing cells on the worksheet will be overwritten. The routine will try to detect correct values for separator character, quote character and decimal separator. See alse ˜[link ImportCSV] ˜param XLS The target XLSReadWriteII object. ˜param SheetIndex The index to the worksheet where the file will be imported to. ˜param Col Left column where the imported data will be written. ˜param Row Top row where the imported data will be written. ˜param Filename The name of the text file that shall be imported. ˜result The number of cells that where imported.
ImportHTMLTable | XLSImportHTMLTable5 | This routine will import a table <TABLE> tag from a html file into a worksheet. Any existing cells on the worksheet will be overwritten. ˜param XLS The target XLSReadWriteII object. ˜param SheetIndex The index to the worksheet where the file will be imported to. ˜param Col Left column where the imported data will be written. ˜param Row Top row where the imported data will be written. ˜param Filename The name of the text file that shall be imported. ˜param TableIndex The zero based index of which table (if there is more than one) that shall be imported. If TableIndex is set to -1, all tables will be imported. ˜param SpecialDecode Default set to False. Don't change this. ˜param DecSep Decimal separator character. Default is the Delphi DecimalSeparator global variable value. Change this if numeric values not are imported correct. ˜result True if any cells where imported.
MakeIndent | XLSUtils5 |
MakePasswordHash | XLSUtils5 |
MAXDOUBLE | XLSUtils5 |
MINDOUBLE | XLSUtils5 |
NativeInt | XLSUtils5 |
PasswordFromHash | XLSUtils5 |
PDoubleArray | XLSUtils5 |
PixelsPerInchXY | XLSUtils5 |
PSAVE | XLSRTFReadWrite5 |
RCPos | XLSUtils5 |
RCPos | XLSUtils5 |
RGBToTColor | XLSUtils5 |
RoundToDecimal | XLSUtils5 |
SafeTryStrToFloat | XLSUtils5 |
SortDoubleArray | XLSUtils5 |
SplitAtChar | XLSUtils5 |
StrDigits | XLSUtils5 |
StreamIsZIP | XLSUtils5 |
StripQuotes | XLSUtils5 |
TActivePane | XLSSheetData5 |
TACTN | XLSRTFReadWrite5 |
TAddImageEvent97 | XLSDrawing5 |
TBaseCellAreas | XLSCellAreas5 | Virtual base class for objects that manipulates cell areas.
TCellArea | XLSCellAreas5 | Represents a cell area.
TCellAreaImpl | XLSCellAreas5 |
TCellAreas | XLSCellAreas5 | Base class for objects that manipulates cell areas.
TCellEdge | XLSCellAreas5 |
TCellEdges | XLSCellAreas5 |
TCellRef | XLSCellAreas5 |
TCellRefs | XLSCellAreas5 |
TCHP | XLSRTFReadWrite5 |
TCmdBorderSide | XLSCmdFormat5 |
TCmdBorderSidePreset | XLSCmdFormat5 |
TCmdBorderSides | XLSCmdFormat5 |
TCmdFmtFillProp | XLSCmdFormat5 |
TCmdFmtFontProp | XLSCmdFormat5 |
TCmdFmtObject | XLSCmdFormat5 |
TCmdFmtXFProp | XLSCmdFormat5 |
TCmdTriState | XLSCmdFormat5 |
TColorToRGB | XLSUtils5 |
TCopyCellsOption | XLSSheetData5 | Options when copying and moving cells.
TCopyCellsOptions | XLSSheetData5 | Copy merged cells.
TDOP | XLSRTFReadWrite5 |
TDoubleArray | XLSUtils5 |
TDrwOptImagePositioning | XLSDrawing5 |
TDynDoubleArray | XLSUtils5 |
TExportCSVOption | XLSExportCSV5 | Options when exporting to CSV files.
TExportCSVOptions | XLSExportCSV5 | Write the formulas to the file, instead of the values (result) of the formulas.
TFormatSettings | XLSUtils5 |
TIDEST | XLSRTFReadWrite5 |
TIndexFont | XLSRTFReadWrite5 |
TIndexFontList | XLSRTFReadWrite5 |
TIndexObject | XLSUtils5 |
TIndexObjectList | XLSUtils5 |
TIntegerEvent | XLSUtils5 |
TIntegerList | XLSUtils5 |
TIntegerStack | XLSUtils5 |
TIPFN | XLSRTFReadWrite5 |
TIPROP | XLSRTFReadWrite5 |
TJust | XLSRTFReadWrite5 |
TKWD | XLSRTFReadWrite5 |
TPaneType | XLSSheetData5 | Pane type when a worksheet has splitted panes.
TPAP | XLSRTFReadWrite5 |
TPGN | XLSRTFReadWrite5 |
TPointerMemoryStream | XLSUtils5 |
TPrintSetupOption | XLSSheetData5 | Cell values Drawing shapes. Cell notes. Conditional formats. Cell validations. Merged cells.
TPrintSetupOptions | XLSSheetData5 |
TPROP | XLSRTFReadWrite5 |
TPROPTYPE | XLSRTFReadWrite5 |
TRDS | XLSRTFReadWrite5 |
TRIS | XLSRTFReadWrite5 |
TRoundToEXRangeExtended | XLSUtils5 |
TRtfFont | XLSRTFReadWrite5 |
TRtfFonts | XLSRTFReadWrite5 |
TRTFReader | XLSRTFReadWrite5 |
TRTFStack | XLSRTFReadWrite5 |
TRTFStackItem | XLSRTFReadWrite5 |
TryCurrencyStrToFloat | XLSUtils5 |
TSAVE | XLSRTFReadWrite5 |
TSBK | XLSRTFReadWrite5 |
TSelectedAreaHit | XLSSheetData5 |
TSelectedEdgeHit | XLSSheetData5 |
TSelectedEdgeHits | XLSSheetData5 |
TSEP | XLSRTFReadWrite5 |
TSolidCellAreas | XLSCellAreas5 | Base class for objects that manipulates cell areas. Solid areas are areas that not can be splitted by delete/insert/move operations, such as merged cells.
TStringEvent | XLSUtils5 |
TSysCharSet | XLSUtils5 |
TTABLEProperties | XLSExportHTML5 | Settings for the tables created on the destionation file.
TTwoIntegerEvent | XLSUtils5 |
TWorkbookOption | XLSSheetData5 |
TWorkbookOptions | XLSSheetData5 | The workbook tabs are displayed.
TWorkspaceOption | XLSSheetData5 |
TWorkspaceOptions | XLSSheetData5 | Outline symbols are displayed.
TXLSAutofilter | XLSAutofilter5 |
TXLSCell | XLSFormattedObj5 |
TXLSCellSortItem | XLSSheetData5 |
TXLSCFRule | XLSCondFormat5 |
TXLSCFRules | XLSCondFormat5 |
TXLSClassFactoryImpl | XLSReadWriteII5 |
TXLSCmdFormat | XLSCmdFormat5 |
TXLSCmdFormatAlignment | XLSCmdFormat5 |
TXLSCmdFormatBorder | XLSCmdFormat5 |
TXLSCmdFormatColor | XLSCmdFormat5 |
TXLSCmdFormatFill | XLSCmdFormat5 |
TXLSCmdFormatFont | XLSCmdFormat5 |
TXLSCmdFormatMode | XLSCmdFormat5 |
TXLSCmdFormatNumber | XLSCmdFormat5 |
TXLSCmdFormatProtection | XLSCmdFormat5 |
TXLSColumn | XLSColumn5 |
TXLSColumns | XLSColumn5 | Methods for manipulating columns. Please note that these methods has no affect on the cell values. They operate only on the columns heading.
TXLSComment | XLSComment5 |
TXLSComments | XLSComment5 |
TXLSConditionalFormat | XLSCondFormat5 |
TXLSConditionalFormats | XLSCondFormat5 |
TXLSDataSetList | XLSDbRead5 | ˜exclude
TXLSDataValidation | XLSValidate5 |
TXLSDataValidations | XLSValidate5 |
TXLSDbCellEvent | XLSDbRead5 | Event fired when ˜[link TXLSDbRead4] reads a cell. ˜param Sender The TXLSDbRead4 object. ˜param IsFieldNames True if the cell is a field name. ˜param Dataset The source data set. ˜param FieldIndex Index into the source data set's field list. ˜param Col The column in the destination XLSReadWriteII object where the cell is inserted. ˜param Row The row in the destination XLSReadWriteII object where the cell is inserted.
TXLSDbRead5 | XLSDbRead5 | Component for importing data sets (TDataset) into a XLSReadWriteII component.
TXLSDbRecordEvent | XLSDbRead5 |
TXLSDefaultFormat | XLSCmdFormat5 |
TXLSDefaultFormats | XLSCmdFormat5 |
TXLSDeleteOption | XLSSheetData5 |
TXLSDeleteOptions | XLSSheetData5 |
TXLSDrawing | XLSDrawing5 |
TXLSDrawingChart | XLSDrawing5 |
TXLSDrawingCharts | XLSDrawing5 |
TXLSDrawingEditor | XLSDrawing5 |
TXLSDrawingEditorShape | XLSDrawing5 |
TXLSDrawingEditorTextBox | XLSDrawing5 |
TXLSDrawingImage | XLSDrawing5 |
TXLSDrawingImages | XLSDrawing5 |
TXLSDrawingObject | XLSDrawing5 |
TXLSDrawingObjects | XLSDrawing5 |
TXLSDrawingShape | XLSDrawing5 |
TXLSDrawingShapes | XLSDrawing5 |
TXLSDrawingTextBox | XLSDrawing5 |
TXLSDrawingTextBoxes | XLSDrawing5 |
TXLSDrawingWordArt | XLSDrawing5 |
TXLSDrawingWordArts | XLSDrawing5 |
TXLSDrwColor | XLSDrawing5 |
TXLSDrwColorType | XLSDrawing5 |
TXLSDrwFill | XLSDrawing5 |
TXLSDrwFillChoice | XLSDrawing5 |
TXLSDrwFillGradient | XLSDrawing5 |
TXLSDrwFillGradientStop | XLSDrawing5 |
TXLSDrwFillGradientStops | XLSDrawing5 |
TXLSDrwFillNone | XLSDrawing5 |
TXLSDrwFillPictStretchOpts | XLSDrawing5 |
TXLSDrwFillPictTileOpts | XLSDrawing5 |
TXLSDrwFillPicture | XLSDrawing5 |
TXLSDrwFillSolid | XLSDrawing5 |
TXLSDrwFillType | XLSDrawing5 |
TXLSDrwGradientFillDirection | XLSDrawing5 |
TXLSDrwGradientFillType | XLSDrawing5 |
TXLSDrwLineEndStyle | XLSDrawing5 |
TXLSDrwLineFillChoice | XLSDrawing5 |
TXLSDrwLineJoinType | XLSDrawing5 |
TXLSDrwLineStyle | XLSDrawing5 |
TXLSDrwMirrorType | XLSDrawing5 |
TXLSDrwShapeProp | XLSDrawing5 |
TXLSDrwShapeProperies | XLSDrawing5 |
TXLSDrwTextAlign | XLSDrawing5 |
TXLSDrwTextBody | XLSDrawing5 |
TXLSDrwTextFont | XLSDrawing5 |
TXLSDrwTextPara | XLSDrawing5 |
TXLSDrwTextParas | XLSDrawing5 |
TXLSDrwTextRun | XLSDrawing5 |
TXLSDrwTextRuns | XLSDrawing5 |
TXLSDrwTwoPosShape | XLSDrawing5 |
TXLSDrwXMLColorType | XLSDrawing5 |
TXLSErrorEvent | XLSUtils5 |
TXLSErrorLevel | XLSUtils5 |
TXLSErrorLevels | XLSUtils5 |
TXLSErrorManager | XLSUtils5 |
TXLSExport5 | XLSExport5 | Base class for objects that exports TXLSReadWriteII data to other file formats.
TXLSExportHTML5 | XLSExportHTML5 | Exports a workbook to a HTML file. On the destionation file one table is created for each worksheet of the source TXLSReadWriteII object.
TXLSExportOption | XLSExport5 |
TXLSExportOptionHTML | XLSExportHTML5 |
TXLSExportOptions | XLSExport5 |
TXLSExportOptionsHTML | XLSExportHTML5 |
TXLSFormattedObj | XLSFormattedObj5 |
TXLSHeaderFooter | XLSSheetData5 |
TXLSHorizPagebreak | XLSSheetData5 |
TXLSHorizPagebreaks | XLSSheetData5 |
TXLSHyperlink | XLSHyperlinks5 |
TXLSHyperlinks | XLSHyperlinks5 |
TXLSImportSYLK | XLSImportSYLK5 |
TXLSMergedCell | XLSMergedCells5 |
TXLSMergedCells | XLSMergedCells5 |
TXLSMoveCopyItem | XLSMoveCopy5 |
TXLSMoveCopyList | XLSMoveCopy5 |
TXLSName | XLSNames5 |
TXLSNames | XLSNames5 |
TXLSNames_Int | XLSNames5 |
TXLSOptionsDialog | XLSSheetData5 |
TXLSPageBreaks | XLSSheetData5 |
TXLSPane | XLSSheetData5 |
TXLSPrintSettings | XLSSheetData5 |
TXLSProgressEvent | XLSUtils5 |
TXLSProgressState | XLSUtils5 |
TXLSProgressType | XLSUtils5 |
TXLSReadWriteII5 | XLSReadWriteII5 |
TXLSRectXY | XLSUtils5 |
TXLSRow | XLSRow5 |
TXLSRows | XLSRow5 |
TXLSRTFWriter | XLSRTFReadWrite5 |
TXLSSelectedArea | XLSSheetData5 |
TXLSSelectedAreas | XLSSheetData5 |
TXLSSheetOption | XLSSheetData5 |
TXLSSheetOptions | XLSSheetData5 | Show zero values.
TXLSSheetProtection | XLSSheetData5 |
TXLSValidationOption | XLSValidate5 | Validation options.
TXLSValidationOptions | XLSValidate5 | Show an error message when an invalid value is entered. Set of validation options.
TXLSVertPagebreak | XLSSheetData5 |
TXLSVertPagebreaks | XLSSheetData5 |
TXLSWorkbook | XLSSheetData5 |
TXLSWorkbookData | XLSSheetData5 |
TXLSWorksheet | XLSSheetData5 |
TXLSWriteSheetData | XLSWriteXLSX5 |
TXLSWriteXLSX | XLSWriteXLSX5 |
UnicodeIs8Bit | XLSUtils5 |
XLS8Char | XLSUtils5 |
XLS8PChar | XLSUtils5 |
XLS8String | XLSUtils5 |
XLSCalcCRC32 | XLSUtils5 |
XLSERR_BIFF_BADBUILTIN_NAME | XLSUtils5 |
XLSERR_BIFF_CANT_FIND_BUILTIN_NAME | XLSUtils5 |
XLSERR_DIRECTWR_CELL_NOT_INC | XLSUtils5 |
XLSERR_FILENAME_IS_MISSING | XLSUtils5 |
XLSERR_FILEREAD_PASSWORDMISSING | XLSUtils5 |
XLSERR_FILEREAD_UNKNOWENCRYPT | XLSUtils5 |
XLSERR_FILEREAD_WRONGPASSWORD | XLSUtils5 |
XLSERR_FILEREAD_XMLPARSE | XLSUtils5 |
XLSERR_FMLA_BADARRAYCOLS | XLSUtils5 |
XLSERR_FMLA_BADARRAYCONST | XLSUtils5 |
XLSERR_FMLA_BADCELLREF | XLSUtils5 |
XLSERR_FMLA_BADERRORCONST | XLSUtils5 |
XLSERR_FMLA_BADEXPONENT | XLSUtils5 |
XLSERR_FMLA_BADFRACTIONAL | XLSUtils5 |
XLSERR_FMLA_BADR1C1REF | XLSUtils5 |
XLSERR_FMLA_BADSHEETNAME | XLSUtils5 |
XLSERR_FMLA_BADTABLE | XLSUtils5 |
XLSERR_FMLA_BADUSEOFOP | XLSUtils5 |
XLSERR_FMLA_BADUSEOFTABLEOP | XLSUtils5 |
XLSERR_FMLA_BADUSEOFTBLSPEC | XLSUtils5 |
XLSERR_FMLA_BADWORKBOOKNAME | XLSUtils5 |
XLSERR_FMLA_FORMULA | XLSUtils5 |
XLSERR_FMLA_INVALIDUSEOF | XLSUtils5 |
XLSERR_FMLA_MISSING | XLSUtils5 |
XLSERR_FMLA_MISSINGARG | XLSUtils5 |
XLSERR_FMLA_MISSINGEXPR | XLSUtils5 |
XLSERR_FMLA_MISSINGOPERAND | XLSUtils5 |
XLSERR_FMLA_MISSINGQUOTE | XLSUtils5 |
XLSERR_FMLA_MISSINGRPAR | XLSUtils5 |
XLSERR_FMLA_TABLESQBRACKET | XLSUtils5 |
XLSERR_FMLA_TBLSPECNOTFIRST | XLSUtils5 |
XLSERR_FMLA_TOMANYGARGS | XLSUtils5 |
XLSERR_FMLA_UNKNOWNNAME | XLSUtils5 |
XLSERR_FMLA_UNKNOWNSHEET | XLSUtils5 |
XLSERR_FMLA_UNKNOWNTABLE | XLSUtils5 |
XLSERR_FMLA_UNKNOWNTABLECOL | XLSUtils5 |
XLSERR_FMLA_UNKNOWNTBLSPEC | XLSUtils5 |
XLSERR_FMLA_UNKNOWNXBOOK | XLSUtils5 |
XLSERR_HLINK_INVALID_CELLREF | XLSUtils5 |
XLSERR_INVALID_SIMPLE_TAG | XLSUtils5 |
XLSERR_NAME_DUPLICATE | XLSUtils5 |
XLSERR_NAME_EMPTY | XLSUtils5 |
XLSERR_NO_XLS_DEFINED | XLSUtils5 |
XLSHINT_BAD_FORMULA_RESULT | XLSUtils5 |
XLSRoundTo | XLSUtils5 |
XLSWARN_CAN_NOT_CHANGE_MERGED | XLSUtils5 |
XLSWARN_CIRCULAR_FORMULA | XLSUtils5 |
XLSWARN_IMAGEERROR | XLSUtils5 |
XLSWARN_INVALIDCELLREF | XLSUtils5 |
XLSWARN_INVALIDCELLVALUE | XLSUtils5 |
XLSWARN_MULTIPLE_SEL_AREAS | XLSUtils5 |
XLSWARN_SHAPE_CAN_NOT_EDIT | XLSUtils5 |
XLSWARN_SHAPE_EDIT_TEXTBOX | XLSUtils5 |
XLSWARN_UNKNOWNIMAGE | XLSUtils5 |
XLSWARN_UNSUPPORTEDIMAGE | XLSUtils5 |
XLSWARN_USEDSHEETNAME | XLSUtils5 |
XLSWARN_WORKBOOK_NOT_EMPTY | XLSUtils5 |
XLS_MININT | XLSUtils5 |
_XLSReplaceStr | XLSUtils5 |

Generated by PasDoc 0.12.1 on 2013-03-18 12:36:48