Unit rXLSExport

DescriptionUsesClasses, Interfaces, Objects and RecordsFunctions and ProceduresTypesConstantsVariables

Description

rXLSExport is non visual component which provides functionality for exporting of any data directly to XLS file using OLE; it can easily export data from any dataset or DBGrid.

Updated version compatible with Delphi2010+. Splash screen in demo version.

Overview

Classes, Interfaces, Objects and Records

Name Description
Class TrXLSExport non visual component which provides functionality for exporting of any data directly to XLS file using OLE

Types

TXLSCellFormat = (...);
TXLSCellFormats = set of TXLSCellFormat;
TXLSExportOption = (...);
TXLSExportOptions = set of TXLSExportOption;

Constants

xlSYLK = 2;
xlCSV = 6;
xlCSVWindows = 23;
xlCSVMSDOS = 24;
xlTextWindows = 20;
xlUnicodeText = 42;
xlExcel8 = 56;
xlExcel9795 = 43;
xlExcel12 = 50;
xlOpenXMLWorkbook = 51;
xlOpenXMLWorkbookMacroEnabled = 52;
xlXMLSpreadsheet = 46;
xlOpenDocumentSpreadsheet = 60;
xlWorkbookNormal = -4143;
xlTemplate = 17;
xlHairline = 1;
xlMedium = -4138;
xlThick = 4;
xlThin = 2;
xlAllBorders = 0;
xlDiagonalDown = 5;
xlDiagonalUp = 6;
xlEdgeBottom = 9;
xlEdgeLeft = 7;
xlEdgeRight = 10;
xlEdgeTop = 8;
xlInsideHorizontal = 12;
xlInsideVertical = 11;
xlContinuous = 1;
xlDash = -4115;
xlDashDot = 4;
xlDashDotDot = 5;
xlDot = -4118;
xlDouble = -4119;
xlLineStyleNone = -4142;
xlSlantDashDot = 13;
xlLandscape = $00000002;
xlPortrait = $00000001;

Description

Types

TXLSCellFormat = (...);

Defines types of cell format

Values
  • cfNone:  
  • cfBold:  
  • cfItalic:  
  • cfUnderline:  
TXLSCellFormats = set of TXLSCellFormat;

Defines types of cell format

TXLSExportOption = (...);

Defines options for ExportTable function

Values
  • xleExportTitles:  
  • xleBoldTitles:  
  • xleOnlyVisibleFields:  
  • xleAddSumRow:  
  • xleAddAsNewSheet:  
  • xleAddToExistingRows:  
  • xleSetCellFormat:  
  • xleSetColumnWidth:  
  • xleFreezeTitles:  
  • xleSetAutoFilter:  
  • xleSetPageSetup:  
  • xleStringFieldAsText:  
  • xleOnlySelectedRows:  
  • xleSetCellBorders:  
  • xleRealFieldNamesAsTitle:  
TXLSExportOptions = set of TXLSExportOption;

Defines options for ExportTable function

Constants

xlSYLK = 2;

XlFileFormat Enumeration (Excel) see http://msdn.microsoft.com/en-us/library/office/ff198017(v=office.15).aspx for full list

xlCSV = 6;
 
xlCSVWindows = 23;
 
xlCSVMSDOS = 24;
 
xlTextWindows = 20;
 
xlUnicodeText = 42;
 
xlExcel8 = 56;
 
xlExcel9795 = 43;
 
xlExcel12 = 50;
 
xlOpenXMLWorkbook = 51;
 
xlOpenXMLWorkbookMacroEnabled = 52;
 
xlXMLSpreadsheet = 46;
 
xlOpenDocumentSpreadsheet = 60;
 
xlWorkbookNormal = -4143;
 
xlTemplate = 17;
 
xlHairline = 1;

Cell Borders

xlMedium = -4138;
 
xlThick = 4;
 
xlThin = 2;
 
xlAllBorders = 0;
 
xlDiagonalDown = 5;
 
xlDiagonalUp = 6;
 
xlEdgeBottom = 9;
 
xlEdgeLeft = 7;
 
xlEdgeRight = 10;
 
xlEdgeTop = 8;
 
xlInsideHorizontal = 12;
 
xlInsideVertical = 11;
 
xlContinuous = 1;

Line type

xlDash = -4115;
 
xlDashDot = 4;
 
xlDashDotDot = 5;
 
xlDot = -4118;
 
xlDouble = -4119;
 
xlLineStyleNone = -4142;
 
xlSlantDashDot = 13;
 
xlLandscape = $00000002;

Constants for enum XlPageOrientation

xlPortrait = $00000001;
 

Author

Created

Feb 2014

Last Modified

Feb 2017


Generated by PasDoc 0.13.0 on 2017-06-17 14:57:07