<Pivot Table>.ToExcel (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help / WLanguage / WLanguage functions / Controls, pages and windows / Pivot Table functions

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

sFichier is string

// Construit le nom du fichier
sFichier = SysDir(srAppData) + ["\"] + "StatsParPays.xls"

TCD_Statistiques.VersExcel(sFichier)
ShellExecute(SysDir(srAppData) + ["\"] + "StatsParPays.xls")

Syntax

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

<Result>: Boolean

True if the file was created,
False otherwise. To get more details on the error, use ErrorInfo.

<Pivot Table control>: Control name

Name of the Pivot Table control to be used.

<XLS file>: Character string

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

<Options>: Optional constant

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

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. Please note: in this case, older versions of Excel will need to be equipped with the "Office 2007 Compatibility Pack", which can be downloaded free of charge from the Microsoft website, in order to be able to open the generated documents.
The created file can be opened by Excel 97 (or later) or by OpenOffice Calc 2 (or later).

Component: wd300xls.dll