Online Documentation for Advanced Data Export for RAD Studio VCL
|
|
Welcome to Advanced Data Export for RAD Studio VCL! |
|
|
Overview |
|
|
What's new |
|
|
Installation |
|
|
Registration |
|
|
How to register Advanced Data Export |
|
|
Version history |
|
|
Other EMS Products |
|
|
Advanced Data Export |
|
|
TQExport4 |
|
|
TQExport4 Reference |
|
|
Properties |
|
|
_Version |
|
|
Aborted |
|
|
About |
|
|
AllowCaptions |
|
|
AutoCalcColWidth |
|
|
AutoCalcStrType |
|
|
CaptionRow |
|
|
Captions |
|
|
ColumnsAlign |
|
|
ColumnsWidth |
|
|
CurrentRecordOnly |
|
|
CustomSource |
|
|
DataSet |
|
|
DBGrid |
|
|
ExportedFields |
|
|
ExportEmpty |
|
|
ExportRecCount |
|
|
ExportSource |
|
|
Footer |
|
|
Formats |
|
|
GoToFirstRecord |
|
|
Header |
|
|
ListView |
|
|
OnlyVisibleFields |
|
|
SkipRecCount |
|
|
StringGrid |
|
|
UserFormats |
|
|
Methods |
|
|
Abort |
|
|
Execute |
|
|
ExportToStream |
|
|
LoadPropertiesFromFile |
|
|
SavePropertiesToFile |
|
|
Events |
|
|
OnBeforeExportRow |
|
|
OnBeginExport |
|
|
OnEndExport |
|
|
OnExportedRecord |
|
|
OnGetCellParams event |
|
|
OnGetExportText |
|
|
OnSkippedRecord |
|
|
OnStopExport |
|
|
TADO_QExport4Access |
|
|
TADO_QExport4Access Reference |
|
|
Properties |
|
|
AppendDateTimeToDatabaseName |
|
|
AutoCreateDatabase |
|
|
AutoCreateTable |
|
|
DatabaseName |
|
|
ExportedDatabaseName |
|
|
FileVersion |
|
|
PrintFile |
|
|
ShowFile |
|
|
TableName |
|
|
TQExport4ASCII |
|
|
TQExport4ASCII Reference |
|
|
Properties |
|
|
CSVComma |
|
|
CSVQuote |
|
|
CSVQuoteStrings |
|
|
ExportType |
|
|
TXTSpacing |
|
|
Methods |
|
|
TQExport4DBF |
|
|
TQExport4DBF Reference |
|
|
Properties |
|
|
ColumnsPrecision |
|
|
DefaultFloatSize |
|
|
DefaultFloatDigital |
|
|
NullValue |
|
|
TQExport4Clipboard |
|
|
TQExport4Clipboard Reference |
|
|
Properties |
|
|
ClipboardViewer |
|
|
ExportType |
|
|
Separator |
|
|
Spacing |
|
|
TQECustomSource |
|
|
TQECustomSource Reference |
|
|
Properties |
|
|
ColCount |
|
|
Columns |
|
|
Eof |
|
|
RecNo |
|
|
Methods |
|
|
ColumnByName |
|
|
First |
|
|
Next |
|
|
Events |
|
|
OnGetColumnValue |
|
|
OnGetNextRecord |
|
|
TQExport4Dialog |
|
|
TQExport4Dialog Reference |
|
|
Properties |
|
|
_Version |
|
|
About |
|
|
AllowCaptions |
|
|
AllowedExports |
|
|
AutoCalcStrType |
|
|
AutoChangeFileExt |
|
|
AutoLoadOptions |
|
|
AutoSaveOptions |
|
|
Captions |
|
|
ColumnsAlign |
|
|
ColumnsWidth |
|
|
CommonOptions |
|
|
ConfirmAbort |
|
|
CSVOptions |
|
|
DataSet |
|
|
DBGrid |
|
|
ExportedFields |
|
|
ExportRecCount |
|
|
ExportSource |
|
|
FileName |
|
|
Footer |
|
|
Formats |
|
|
GoToFirstRecord |
|
|
Header |
|
|
HTMLMultiFileOptions |
|
|
HTMLPageOptions |
|
|
HTMLTableOptions |
|
|
ListView |
|
|
OnlyVisibleFields |
|
|
OptionsFileName |
|
|
PDFOptions |
|
|
PrintFile |
|
|
RTFOptions |
|
|
SaveLoadButtons |
|
|
ShowFile |
|
|
SkipRecCount |
|
|
SQLOptions |
|
|
StringGrid |
|
|
TXTOptions |
|
|
UserFormats |
|
|
XLSOptions |
|
|
XMLOptions |
|
|
Methods |
|
|
Execute |
|
|
Events |
|
|
OnBeginExport |
|
|
OnEndExport |
|
|
OnExportedRecord |
|
|
OnGetExportText |
|
|
OnGetFooter |
|
|
OnGetHeader |
|
|
OnSkippedRecord |
|
|
TQExport4Docx |
|
|
TQExportDocx Reference |
|
|
Properties |
|
|
Options |
|
|
TQExport4HTML |
|
|
TQExport4HTML Reference |
|
|
Properties |
|
|
BoolAsCheckBox |
|
|
CSSFileName |
|
|
GenerateIndex |
|
|
HTMLOptions |
|
|
HTMLTemplate |
|
|
MaxRecords |
|
|
Navigation |
|
|
TableOptions |
|
|
OverwriteCSSFile |
|
|
Title |
|
|
UsingCSS |
|
|
InterpretTags |
|
|
Methods |
|
|
LoadTemplateFromFile |
|
|
SaveTemplateToFile |
|
|
Events |
|
|
TQExport4LaTeX |
|
|
TQExport4LaTeX Reference |
|
|
Properties |
|
|
Options |
|
|
Preambula |
|
|
Methods |
|
|
TQExport4ODS |
|
|
TQExport4ODS Reference |
|
|
Properties |
|
|
SheetName |
|
|
ODSOptions |
|
|
TQExport4ODT |
|
|
TQExport4ODT Reference |
|
|
Properties |
|
|
TableName |
|
|
ODTOptions |
|
|
TQExport4PDF |
|
|
TQExport4PDF Reference |
|
|
Properties |
|
|
Options |
|
|
BreakString |
|
|
TQExport4RTF |
|
|
TQExport4RTF Reference |
|
|
Properties |
|
|
Options |
|
|
Methods |
|
|
Events |
|
|
OnGetCaptionStyle |
|
|
OnGetDataStyle |
|
|
OnGetHeaderStyle |
|
|
OnGetFooterStyle |
|
|
TQExport4SQL |
|
|
TQExport4SQL Reference |
|
|
Properties |
|
|
CommitAfterScript |
|
|
CommitRecCount |
|
|
CommitStatement |
|
|
CreateTable |
|
|
FormatValues |
|
|
MultipleInsert |
|
|
NullValue |
|
|
StatementTerm |
|
|
TableName |
|
|
Types conversion |
|
|
DB2 |
|
|
Interbase/Firebird |
|
|
MS SQL Server |
|
|
MY SQL |
|
|
Oracle |
|
|
Postgresql |
|
|
ANSI SQL |
|
|
TQExport4XLS |
|
|
TQExport4XLS Reference |
|
|
Properties |
|
|
AutoAddSheet |
|
|
AutoTruncateValue |
|
|
Header |
|
|
Cells |
|
|
Charts |
|
|
DefColWidth |
|
|
DefRowHeight |
|
|
ExportStage |
|
|
FieldFormats |
|
|
FooterRows |
|
|
HeaderRows |
|
|
HyperLinks |
|
|
Images |
|
|
MergedCells |
|
|
Pictures |
|
|
Notes |
|
|
Options |
|
|
Sheets |
|
|
SplitByRows |
|
|
StartDataCol |
|
|
StripStyles |
|
|
StripType |
|
|
PageSetup |
|
|
Methods |
|
|
AddBooleanCell |
|
|
AddDateTimeCell |
|
|
AddMergedCells |
|
|
AddNumericCell |
|
|
AddStringCell |
|
|
Events |
|
|
OnAfterExportSheet event |
|
|
OnBeforeExportSheet event |
|
|
OnGetDataParams |
|
|
OnGetAggregateParams |
|
|
OnGetBeforeDataParams |
|
|
OnGetCaptionParams |
|
|
OnGetFooterParams |
|
|
OnGetHeaderParams |
|
|
OnAdvancedExportedRecord |
|
|
OnAdvancedGetExportText |
|
|
TQExport4Xlsx |
|
|
TQExport4Xlsx Reference |
|
|
Properties |
|
|
SheetName |
|
|
XlsxOptions |
|
|
Events |
|
|
OnGetDataParams |
|
|
TQExport4XML |
|
|
TQExport4XML Reference |
|
|
Properties |
|
|
Options |
|
|
DocumentType |
|
|
ExportXSDSchema |
|
|
Units |
|
|
QExport4 unit |
|
|
TQExport4Text component |
|
|
Properties |
|
|
AppendDateTimeToFileName |
|
|
ExportedFileName |
|
|
FileName |
|
|
PrintFile |
|
|
ShowFile |
|
|
TQExportCol object |
|
|
Properties |
|
|
Name |
|
|
Value |
|
|
TQExportFormats object |
|
|
Properties |
|
|
BooleanFalse |
|
|
BooleanTrue |
|
|
CurrencyFormat |
|
|
DateFormat |
|
|
DateTimeFormat |
|
|
FloatFormat |
|
|
IntegerFormat |
|
|
NullString |
|
|
TimeFormat |
|
|
KeepOriginalFormat |
|
|
Methods |
|
|
ResetFormats |
|
|
TQExportRow object |
|
|
Properties |
|
|
Items |
|
|
TExportedRecordEvent type |
|
|
TGetCellParamsEvent type |
|
|
TGetExportTextEvent type |
|
|
TQExportStopEvent type |
|
|
QExport4Access unit |
|
|
QExport4ASCII unit |
|
|
QExport4DBF unit |
|
|
QExport4Clipboard unit |
|
|
QExport4CustomSource unit |
|
|
TqeCustomColumn object |
|
|
Properties |
|
|
Caption |
|
|
ColumnName |
|
|
ColumnType |
|
|
Size |
|
|
Width |
|
|
TqeCustomColumns object |
|
|
Properties |
|
|
Items |
|
|
QExport4Dialog unit |
|
|
TQExportGetColonEvent type |
|
|
TQGetExportTextEvent type |
|
|
TQRecordExportedEvent type |
|
|
QExport4Docx unit |
|
|
TDocxOptions object |
|
|
Properties |
|
|
HeaderStyle |
|
|
CaptionRowStyle |
|
|
DataStyle |
|
|
FooterStyle |
|
|
StripStyleType |
|
|
StripStylesList |
|
|
TDocxStripStyle object |
|
|
Properties |
|
|
Options |
|
|
TDocxCellStyle object |
|
|
Properties |
|
|
Font |
|
|
BackgroundColor |
|
|
UseBackground |
|
|
Alignment |
|
|
QExport4HTML unit |
|
|
TTableOptions object |
|
|
Properties |
|
|
AdvancedAttributes |
|
|
Border |
|
|
BorderColor |
|
|
CellPadding |
|
|
CellSpacing |
|
|
HeadersRowBgColor |
|
|
HeadersRowFontColor |
|
|
OddRowBgColor |
|
|
TableBgColor |
|
|
TableFontColor |
|
|
BackgroundFileName |
|
|
THTMLOptions object |
|
|
Properties |
|
|
LinkColor |
|
|
AdvancedAttributes |
|
|
ALinkColor |
|
|
BackgroundColor |
|
|
BackgroundFileName |
|
|
DefaultOptions |
|
|
TextFont |
|
|
VLinkColor |
|
|
TQExportHTMLNavigation object |
|
|
Properties |
|
|
FirstLinkTitle |
|
|
IndexLinkTemplate |
|
|
IndexLinkTitle |
|
|
LastLinkTitle |
|
|
NextLinkTitle |
|
|
OnBottom |
|
|
OnTop |
|
|
PriorLinkTitle |
|
|
THTMLTemplate type |
|
|
TUsingCSS type |
|
|
QExport4LaTeX unit |
|
|
TLaTeXOptions component |
|
|
Properties |
|
|
CodePage |
|
|
DocumentParams |
|
|
DocumentStyle |
|
|
Languages |
|
|
LaTeXVersion |
|
|
BaseODSClass4 unit |
|
|
TODSCellParagraphStyle |
|
|
Properties |
|
|
VerticalAligment |
|
|
Border |
|
|
TODSParagraphStyle |
|
|
Properties |
|
|
Font |
|
|
BackgroundColor |
|
|
AllowBackground |
|
|
Alignment |
|
|
TODFBorder |
|
|
Properties |
|
|
BorderStyle |
|
|
BorderWidth |
|
|
BorderColor |
|
|
BaseODTClass4 unit |
|
|
TODTCellParagraphStyle |
|
|
Properties |
|
|
VerticalAligment |
|
|
Border |
|
|
TODTParagraphStyle |
|
|
Properties |
|
|
HighlightColor |
|
|
AllowHighlight |
|
|
TODFBorder |
|
|
Properties |
|
|
BorderStyle |
|
|
BorderWidth |
|
|
BorderColor |
|
|
QExport4ODS unit |
|
|
TQExport4ODSOptions object |
|
|
Properties |
|
|
HeaderStyle |
|
|
FooterStyle |
|
|
CaptionRowStyle |
|
|
DataStyle |
|
|
StripStyle |
|
|
StripStylesList |
|
|
QExport4ODT unit |
|
|
TQExportODTOptions object |
|
|
Properties |
|
|
HeaderStyle |
|
|
FooterStyle |
|
|
CaptionRowStyle |
|
|
DataStyle |
|
|
StripStyle |
|
|
StripStylesList |
|
|
QExport4PDF unit |
|
|
TPDFFont object |
|
|
Properties |
|
|
BaseFont |
|
|
FontColor |
|
|
FontEncoding |
|
|
FontSize |
|
|
Charset |
|
|
TPDFOptions object |
|
|
Properties |
|
|
CaptionFont |
|
|
ColSpacing |
|
|
DataFont |
|
|
FooterFont |
|
|
GridLineColor |
|
|
GridLineWidth |
|
|
HeaderFont |
|
|
RowSpacing |
|
|
QExport4RTF unit |
|
|
TRTFOptions object |
|
|
Properties |
|
|
PageOrientation |
|
|
CaptionAligns |
|
|
CaptionStyle |
|
|
DataStyle |
|
|
FooterStyle |
|
|
HeaderStyle |
|
|
StripStyles |
|
|
StripType |
|
|
TrtfStyle object |
|
|
Properties |
|
|
Alignment |
|
|
AllowBackground |
|
|
AllowHighlight |
|
|
BackgroundColor |
|
|
Font |
|
|
HighlightColor |
|
|
TrtfStyles object |
|
|
Properties |
|
|
Items |
|
|
QExport4SQL unit |
|
|
QExport4XLS unit |
|
|
TxlsFormat object |
|
|
Properties |
|
|
Alignment |
|
|
Borders |
|
|
Fill |
|
|
Font |
|
|
Wrap |
|
|
TxlsFormats object |
|
|
Properties |
|
|
Items |
|
|
TxlsFieldFormat object |
|
|
Properties |
|
|
Aggregate |
|
|
FieldName |
|
|
Width |
|
|
TxlsFieldFormats object |
|
|
Properties |
|
|
Items |
|
|
TxlsFont object |
|
|
Properties |
|
|
Charset |
|
|
Color |
|
|
Name |
|
|
Script |
|
|
Size |
|
|
Style |
|
|
Underline |
|
|
TxlsBorder object |
|
|
Properties |
|
|
Color |
|
|
Style |
|
|
TxlsBorders object |
|
|
Properties |
|
|
Bottom |
|
|
DiagDown |
|
|
DiagUp |
|
|
Left |
|
|
Right |
|
|
Top |
|
|
TxlsFill object |
|
|
Properties |
|
|
Background |
|
|
Foreground |
|
|
Pattern |
|
|
TxlsAlignment object |
|
|
Properties |
|
|
Horizontal |
|
|
Vertical |
|
|
TxlsHyperLink object |
|
|
Properties |
|
|
Col |
|
|
Format |
|
|
Row |
|
|
ScreenTip |
|
|
Style |
|
|
Target |
|
|
Title |
|
|
TxlsHyperLinks object |
|
|
Properties |
|
|
Items |
|
|
TxlsNote object |
|
|
Properties |
|
|
Col |
|
|
Format |
|
|
Lines |
|
|
Row |
|
|
TxlsNotes object |
|
|
Properties |
|
|
Items |
|
|
TxlsChartSeries object |
|
|
Properties |
|
|
Color |
|
|
DataColumn |
|
|
DataRange |
|
|
DataRangeType |
|
|
Title |
|
|
TxlsChartSeriesList object |
|
|
Properties |
|
|
Items |
|
|
TxlsChart object |
|
|
Properties |
|
|
AutoColor |
|
|
CategoryLabels |
|
|
CategoryLabelsType |
|
|
CategoryLabelsColumn |
|
|
LegendPlacement |
|
|
Position |
|
|
Series |
|
|
ShowLegend |
|
|
Style |
|
|
Title |
|
|
TxlsCharts object |
|
|
Properties |
|
|
Items |
|
|
TxlsPicture object |
|
|
Properties |
|
|
Name |
|
|
FileName |
|
|
TxlsPictures object |
|
|
Properties |
|
|
Items |
|
|
TxlsImage object |
|
|
Properties |
|
|
Col |
|
|
PictureName |
|
|
Row |
|
|
Title |
|
|
Zoom |
|
|
TxlsImages object |
|
|
Properties |
|
|
Items |
|
|
TxlsCell object |
|
|
Properties |
|
|
CellType |
|
|
Col |
|
|
DateTimeFormat |
|
|
Format |
|
|
IsBoolean |
|
|
IsDateTime |
|
|
IsNumeric |
|
|
IsString |
|
|
NumericFormat |
|
|
Row |
|
|
Value |
|
|
TxlsCells object |
|
|
Properties |
|
|
Items |
|
|
TxlsMergedCells object |
|
|
Properties |
|
|
FirstCol |
|
|
FirstRow |
|
|
LastCol |
|
|
LastRow |
|
|
TxlsMergedCellList component |
|
|
Properties |
|
|
Items |
|
|
TxlsNoteFormat object |
|
|
Properties |
|
|
Alignment |
|
|
BackgroundColor |
|
|
FillType |
|
|
Font |
|
|
ForegroundColor |
|
|
Gradient |
|
|
Orientation |
|
|
Transparency |
|
|
TxlsDataRange object |
|
|
Properties |
|
|
Col1 |
|
|
Col2 |
|
|
Row1 |
|
|
Row2 |
|
|
TxlsChartPosition object |
|
|
Properties |
|
|
X1 |
|
|
X2 |
|
|
Y1 |
|
|
Y2 |
|
|
TXLSOptions object |
|
|
Properties |
|
|
AggregateFormat |
|
|
CaptionsFormat |
|
|
DataFormat |
|
|
FooterFormat |
|
|
HeaderFormat |
|
|
PageFooter |
|
|
PageHeader |
|
|
SheetTitle |
|
|
HyperLinkFormat |
|
|
NoteFormat |
|
|
TxlsPageSetup object |
|
|
Properties |
|
|
PaperSize |
|
|
Scale |
|
|
PageStart |
|
|
FitWidth |
|
|
FitHeight |
|
|
CopiesCount |
|
|
LeftToRight |
|
|
PortraitOrient |
|
|
NoColor |
|
|
DraftQuality |
|
|
PrintNotes |
|
|
PrintNotesAtEnd |
|
|
TGetAggregateParamsEvent type |
|
|
TGetCaptionParamsEvent type |
|
|
TGetHeaderFooterParamsEvent type |
|
|
TGetDataParamsEvent type |
|
|
TxlsColor type |
|
|
TxlsBorderStyle type |
|
|
TxlsPattern type |
|
|
QExport4Xlsx unit |
|
|
TXlsxOptions object |
|
|
Properties |
|
|
HeaderStyle |
|
|
CaptionRowStyle |
|
|
DataStyle |
|
|
FooterStyle |
|
|
StripStyleType |
|
|
StripStylesList |
|
|
TXlsxStripStyle object |
|
|
Properties |
|
|
Options |
|
|
TXlsxCellStyle object |
|
|
Properties |
|
|
Font |
|
|
BackgroundColor |
|
|
UseBackground |
|
|
Alignment |
|
|
VerticalAligment |
|
|
WrapText |
|
|
UseBorder |
|
|
Border |
|
|
TOnGetDataParamsEvent type |
|
|
QExport4XML unit |
|
|
TXMLOptions object |
|
|
Properties |
|
|
Encoding |
|
|
StandAlone |
|
|
Version |
|
|
Appendix |
|
|
Supported file formats |
|
|
Color Using Notes |
© 1999-2025 EMS Software Development