ExportToExcelFile method

ExportToExcelFile method

Applies to
TProfGrid component

Declaration
function ExportToExcelFile(const FileName: TFileName; FileFormat: DWORD = 0): Boolean;

Description

Works in the same way as the ExportToExcel method, but performs output to the specified file and does not open the Microsoft Excel application window.

The second optional parameter of the method (FileFormat) can be used to export to a non-default file format. (A value of 0 indicates the default Microsoft Excel format).

Following is the list of constants that may be passed as the FileFormat parameter.

Excel97 compatible:
xlAddIn
xlCSV
xlCSVMac
xlCSVMSDOS
xlCSVWindows
xlDBF2
xlDBF3
xlDBF4
xlDIF
xlExcel2
xlExcel2FarEast
xlExcel3
xlExcel4
xlExcel5
xlExcel7
xlExcel9795
xlExcel4Workbook
xlIntlAddIn
xlIntlMacro
xlWorkbookNormal
xlSYLK
xlTemplate
xlCurrentPlatformText
xlTextMac
xlTextMSDOS
xlTextPrinter
xlTextWindows
xlWJ2WD1
xlWK1
xlWK1ALL
xlWK1FMT
xlWK3
xlWK4
xlWK3FM3
xlWKS
xlWorks2FarEast
xlWQ1
xlWJ3
xlWJ3FJ3

Excel2000 or higher required:
xlUnicodeText
xlHtml

ExcelXP or higher required:
xlWebArchive
xlXMLSpreadsheet