JVCL Help:TJvDBGridExcelExport

 JVCL Help: TJvDBGridExcelExport Class

JVCL Classes

JVCL.DBAware

► JvDBGridExport.pas Classes

[+] JvDBGridExport.pas Classes

► TJvDBGridExcelExport Events

[+] TJvDBGridExcelExport Events

► TJvDBGridExcelExport Methods

[+] TJvDBGridExcelExport Methods

► TJvDBGridExcelExport Properties

[+] TJvDBGridExcelExport Properties

JEDI Visual Component Library Help

• Packages
• Files
  • Classes
  • Interfaces
  • Functions
  • Variables
  • Constants
  • Types
  • Records
• Project summary
• License

Search in JVCL Help

 

Search in all projects

 

Class Hierarchy

TJvCustomDBGridExport

    TJvCustomDBGridOleExport

        TJvDBGridExcelExport

run\JvDBGridExport.pas

Summary

Write here a summary (1 line)

run\JvDBGridExport.pas

Pascal

 run\JvDBGridExport.pas

 TJvDBGridExcelExport = class(TJvCustomDBGridOleExport);

Description

1. JVCLInfo

run\JvDBGridExport.pas

Examples

procedure ExportToMSExcel(DBGridExcelExport : TJvDBGridExcelExport; SaveDialog : TJvSaveDialog; DBUltimGrid : TJvDBUltimGrid; ProgressDialog: TJvProgressDialog); begin

 SaveDialog.Title := 'Exportar a Microsoft Excel...'; 
 SaveDialog.Filter := 'Microsoft Excel 97-2003 [*.xls]|*.xls|Microsoft Excel 2007 [*.xlsx]|*.xlsx|Todos los Archivos [*.*]|*.*'; 
 SaveDialog.FilterIndex := 1; 
 SaveDialog.DefaultExt := '*.xls'; 
 if SaveDialog.Execute Then 
 begin 
   DBGridExcelExport.FileName := SaveDialog.FileName; 
 //DBGridExcelExport.UseFieldGetText := true; 
   DBGridExcelExport.Grid := DBUltimGrid; 
   ProgressDialog.Position := 0; 
   ProgressDialog.Max := DBUltimGrid.DataSource.DataSet.RecordCount-1; 
   ProgressDialog.Show;
   DBGridExcelExport.ExportGrid; 
   ProgressDialog.Hide; 
 end; 

end;

run\JvDBGridExport.pas

About

Navigation

▼ TJvDBGridExcelExport

  TJvDBGridExcelExport

  TJvDBGridExcelExport.AutoFit

  TJvDBGridExcelExport.Caption

  TJvDBGridExcelExport.Close

  TJvDBGridExcelExport.Create@TComponent

  TJvDBGridExcelExport.Destroy

  TJvDBGridExcelExport.DoClose

  TJvDBGridExcelExport.DoExport

  TJvDBGridExcelExport.DoSave

  TJvDBGridExcelExport.FileName

  TJvDBGridExcelExport.Grid

  TJvDBGridExcelExport.OnProgress

  TJvDBGridExcelExport.Orientation

  TJvDBGridExcelExport.Visible

run\JvDBGridExport.pas

Contribute to this help topic

This documentation wiki is based on the collaborative effort of Project JEDI users. Your edits are welcome in order to improve documentation quality: edit this page

The JEDI Visual Component Library source is hosted at : link to view the current source code, link to the subversion repository