<Pivot table>.ToExcel (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

<Pivot table>.ToExcel (Function)

In french: <Tableau croisé dynamique>.VersExcel

Creates an Excel file with data from a Pivot Table control.

Example

sFile is string

// Builds the file name
sFile = SysDir(srAppData) + ["\"] + "StatsByCountry.xls"

PVT_Statistics.ToExcel(sFile)
ShellExecute(SysDir(srAppData) + ["\"] + "StatsByCountry.xls")

Syntax

<Result> = <Pivot Table control>.ToExcel(<XLS file> [, <Options>])

<Result>: Boolean

True if the file was created,
False otherwise. For more details about the error, use the ErrorInfo function.

<Pivot Table control>: Control name

Name of Pivot Table control to use.

<XLS file>: Character string (with quotes)

Name and full path of Excel file to create. The file is replaced by the new file if it already exists.

<Options>: Optional constant

Configuration of XLS file to create.
taWithLayout Exports the color and font of the Pivot Table control.
taNoTitle Only the data is copied into the file.
taColumnsTitles
(default value) The title of columns is inserted into the file.

Remarks

The Excel files cannot exceed 65536 rows and 256 columns if the extension used is ".xls". This limit can be exceeded by using the ".xlsx" extension in order to create files in Excel 2007 format. Caution: in this case, the former versions of Excel must be equipped with the "Compatibility Pack Office 2007" that can be freely downloaded from the Microsoft site in order to open the generated documents.
The created file can be opened by Excel 97 (or later) or by OpenOffice Calc 2 (or later).

Component: wd260xls.dll