Thierry Seunevel Thierry 
 Tech Corner       
  Home   Missions Tech corner Download Resume Contact
Home > Tech Corner > Excel Report

ExcelReport : Using Excel to print from Lotus Notes (2)

. Principle
. 1st example
. Excel Model
. ExcelReport
. More
. New with V1
The Excel Model for our Example
The Excel model is shown below

Modele Excel

Excel Model Opened in Excel

The model includes the look of the target report, and a way to fill the data from the Notes documents.
To achieve this, the Excel cells are given the same name than the source Notes items.
The second figure shows the same model, with the dialog box insert>names>define opened.

Modele Excel

Dialog Box Insert>Names>Define names

The names starting with Sup are the names of the Notes fields.

ReportLine is the default name used by ExcelReport to define the cell range to be inserted in the file for each Notes document. On the model, this range is colored in blue.

The names dialog box includes aCol.6, which defines the use of the 6th absolute column of the source view, column defined by a Notes formula (@Elements(supPlage)).
The use of vCol.x allows to address the visible columns of a view.

The Excel columns H and I are outside the print zone, but inside the ReportLine range.
They are used to compute intermediate values used in the total rows of the file.
The cell H7 has an Excel formula =1, and is used to compute the number of documents printed (cell C8 formula SUM(H5:H7)).

All computation are done by Excel.

    Top  Top  Previous  Principle | Excel Model  Next

©  Thierry Seunevel (2004)