<<1>> Employee:ByName  // Quick start

  Quick start

        Bands.
EXLReport      .

       .
   (Master Data)     
    ,    DataSet. 
    .
    (Summary)    
 (,  EXLReport ; .  "User fields").
         . , 
     ,    ,
  ,     ,   - 
   -  - ,  .
   (Title)      
   .
      , 
     .

  DataSet   ,   
    - Title,     
(.  "Label report").

<<2>> Employee:ByName  // Label report

  Label report

    DataSet ,  
      - Title,   
 ,       ,  
,   -  ,  
       .
(   .  "User fields").

<<3>> Employee  // Summary report

  Summary report

        .
    ,     
(Master data),      Range  
.

<<4>> Employee:ByName  // User fields

  User fields

 EXLReport        
  .    
     OnGetFieldValue,  
  Dictionary.

        FieldSign.
       ,
,  , ,  .  
    ,      
. ,
  #Name1  - ,
  #Form.Table.Field  - ,
  #"User field" - ,
  #Form. Table. Field  -  .
      Delphi,   
     FieldSign,      
   EXLReport,      .

   Excel    ,   
   EXLReport,    
 Excel "  ",    "=" 
   -      
.

      :
  <  >.<   >.<  >
  EXLReport       
,       .   
,    DataSet,    
   .

   (Detail Footer, Group Footer  Summary)  
EXLReport      , 
   Excel: SUM, AVG, MIN, MAX, COUNT.
      , 
  .    :
  #<EXLReport >(< EXLReport>)
, #SUM(Salary).
       .   
     .    
 .
  Options   qxoTotalsAsFormula, 
     Excel ( ,
      ),  -
.

     .
1.  Dictionary. (,    
).
2.  .       
   .    ,    
   DataSet,     .
3.  OnGetFieldValue.
    ,  .

<<5>> Employee:ByName  // Formatting cells in program

  Formatting cells in program

       OnFormatCell.
     ,    
    ,  ,   
ExcelWorksheet,       .

 ,      OnGetFieldValue 
OnSetCellValue,     OnFormatCell 
    Master  Detail  .  
       
 Master  Detail.

.     OnFormatCell 
   Excel.

<<6>> Employee:ByName  // Conditional formatting cells

  Conditional formatting cells

    ,  ,
    OnFormatCell 
  Excel (  "" \ "
...").

<<7>> Clients.dbf  // Row height

  Row height

        . 
        , 
     "" \ "" \
" ",        
  ;     
   .  ,  ,
    ,     ,
     , 
       .

  ,  ,     
,        21 .
  A3:D3     ,
    ;   3 
 .     
  OnFormatCell.

<<8>> Clients.dbf  // Changing cell data

  Changing cell data

 EXLReport   OnSetCellValue,  
   .   , 
      ,
,    ,     
.

<<9>> Employee:ByName  // Totals

  Totals

    EXLReport    
EXLReport: SUM, AVG, MIN, MAX, COUNT (.  "User fields").

       , 
   ,   
 OnGetFieldValue   -  Excel
.        OnSetCellValue
 OnFormatCell.

    Excel ( ) 
  Excel       
 ,     OnGetFieldValue 
OnSetCellValue     
 Excel.
     Excel  
  OnFormatCell.     Formula
 Range  Report    
Excel    .   
   .

        
  OnSetCellValue  OnFormatCell  
      
EXLReport.

    EXLReport   ,
         ,
      Excel ( Options 
 qxoTotalsAsFormula).
1.  ,    Excel - 1023
.
2.      - 900.
,  -      ( ,
   ,    ,  
  ),      .

<<10>> Employee:ByName  // Totals in data band

  Totals in data band

       
    .      
  ,    
       ; 
  Summary     EXLReport, 
   OnFormatCell    
    FormulaLocal -   
Title  Excel -    ,   
       Title.  
   .

<<11>> Customer:ByCompany Orders:CustNo  // Master - detail

  Master - detail

   master - detail   
 .

 Master Data      ,  Detail Header /
Detail Footer -       .

<<12>> Events  // Groupping

  Groupping

        
 .

         
  DataSet ( FieldName  Group Header), 
   OnCalcExpression  Group Header.
     .

 Group Footer    Group Header  
 FooterBand .

<<13>> // User data

  User data

      ,   TDataSet
,      
OnDataXXX.

<<14>> Employee:ByName  // Change sheet properties

  Change sheet properties

       , 
 Excel  ..,    Report 
ExcelWorksheet   OnAfterBuild  OnFormatCell.

  ,     
Excel    Excel.

<<15>> Employee:ByName  // Multi-sheet

  Multi-sheet report

   ,  
  ExcelReport,    .

   ,    , 
    Template  TemplSheet.   
 SubReport     
    ExcelReport. , 
SubReport       
ExcelReport,   .

  ,  ,   Template
 ,       
TemplSheet.

       
 .

  ,    Show  
ExcelReport.

