TdxCustomChartControl.ExportToXLSX(string,Integer,Integer) Method

Exports content as an image container in an XLSX document and saves it to a file.

Declaration

procedure ExportToXLSX(const AFileName: string; AImageWidth: Integer = 0; AImageHeight: Integer = 0); overload;

Parameters

Name	Type	Description
AFileName	string	The absolute or relative path to the resulting XLSX file.
AImageWidth	Integer	Optional. The width (in pixels) of the chart image inserted into the resulting XLSX document. If this parameter is omitted, the pixel width of the resulting image container in the created spreadsheet document matches the current pixel width of the Chart control client area on the parent form. The export procedure stretches or shrinks the Chart control layout horizontally to fit the resulting image in a spreadsheet into the target width. All font sizes remain unchanged. If title or label text does not fit into the corresponding visual Chart element, the Chart control crops the text and ends it with an ellipsis in the exported layout.
AImageHeight	Integer	Optional. The height (in pixels) of the chart image inserted into the resulting XLSX document. If this parameter is omitted, the pixel height of the resulting image container in the created spreadsheet document matches the current pixel height of the Chart control client area on the parent form. All font sizes remain unchanged. If title or label text does not fit into the corresponding visual Chart element, the Chart control crops the text and ends it with an ellipsis in the exported layout.

Remarks

Call the ExportToXLSX procedure to save content of the Chart control client area as a floating image container in an XLSX file. The resulting image size matches the actual pixel dimensions of the Chart control client area on a form.

Exported Content Example

The following image demonstrates an XLSX document with exported chart content opened in a VCL SpreadSheet-based application:

Adjust Target Image Dimensions

You can pass required target pixel dimensions for the resulting image as optional AImageWidth and AImageHeight parameters. In this case, the ExportToXLSX procedure resizes all visible diagrams to fit into the target dimensions. All font sizes remain unchanged.

Code Example

The following code example exports shrunk content of the Chart control client area whose original dimensions on the parent form are 600 by 700 pixels:

Delphi

begin
  dxSavePictureDialog1.Execute(Handle);
  if dxSavePictureDialog1.FileName = '' then Exit;
  dxChartControl1.ExportToXLSX(dxSavePictureDialog1.FileName, 315, 385);
end;

C++

  // ...
  dxSavePictureDialog1->Execute(Handle);
  if(dxSavePictureDialog1->FileName == "") { return; }
  dxChartControl1->ExportToXLSX(dxSavePictureDialog1->FileName, 315, 385);

Related Compiled Demo

To see the export to spreadsheet functionality in action, run the Chart Control demo in the VCL Demo Center installed with compiled VCL DevExpress demos. Click Export and choose the Export to XLSX item.

Download: Compiled VCL Demos

Tip

You can find full source code for the installed compiled Chart control demo in the following folder:

%PUBLIC%\Documents\DevExpress VCL Demos\MegaDemos\Product Demos\ExpressChart