Board index » delphi » Excel rows grouping

Excel rows grouping


2005-05-05 04:24:29 PM
delphi35
Hi,
How to do grouping when writing to Excel? I am using the instance of
TExcelApplication.
I need to group few of the rows and display their group total.
Can anyone help me do this?
TIA,
Dorothy
 
 

Re:Excel rows grouping

If by grouping You mean merge, then use
expression.Merge(Across)
expression Required. An expression that returns the Range object.
Across Optional Variant. True to merge cells in each row of the
specified range as separate merged cells. The default value is False.
Rimvydas
Dorothy writes:
Quote
Hi,

How to do grouping when writing to Excel? I am using the instance of
TExcelApplication.
I need to group few of the rows and display their group total.
Can anyone help me do this?

TIA,
Dorothy