exporting to excel: how to group rows?

[davikokar]

hallo,

my export function takes data from a treeview and export them to a excel worksheet. After that I would like to group some rows, but I cannot find a way to do it. Does anyone has an example? Thanks

 

[matt23lucier]

Try something like this.

worksheet.Rows.get_Range("Your row range").Group(Type.Missing, Type.Missing , Type.Missing, Type.Missing);