# All Functions and Procedures

Name | Unit | Description
--- | --- | ---
BoolAsWord | XLSUtils5 |
BytesToHexStr | XLSUtils5 |
CharInSet | XLSUtils5 |
CmToEmu | XLSUtils5 |
CPos | XLSUtils5 |
CPos | XLSUtils5 |
EmptyGUID | XLSUtils5 |
EmuToCm | 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 |
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 |
PasswordFromHash | XLSUtils5 |
PixelsPerInchXY | XLSUtils5 |
RCPos | XLSUtils5 |
RCPos | XLSUtils5 |
RGBToTColor | XLSUtils5 |
RoundToDecimal | XLSUtils5 |
SafeTryStrToFloat | XLSUtils5 |
SortDoubleArray | XLSUtils5 |
SplitAtChar | XLSUtils5 |
StreamIsZIP | XLSUtils5 |
StripQuotes | XLSUtils5 |
TColorToRGB | XLSUtils5 |
TryCurrencyStrToFloat | XLSUtils5 |
UnicodeIs8Bit | XLSUtils5 |
XLSCalcCRC32 | XLSUtils5 |
XLSRoundTo | XLSUtils5 |
_XLSReplaceStr | XLSUtils5 |

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