Problem in Excel grouping

A

Amit

Hi,

I am generating report in excel sheet programmatically using C#.
Now i am grouping the rows based on some criteria.

rows in excel is organized as:

Agent
Row1
Row2..
Dealer1
Row1
Row2..
SubDealer
Row1..
Dealer2
Row1
Row2..
SubDealer
Row1
Row2..

(each row is a single customer of Agent/Dealer(s)/SubDealer(s). )

Now i want to group rows for each Agent/Dealer(s)/SubDealer(s))
Is grouping possible in hierarchical scenario like here through
programmatically.

I am doing it but different group levels gets merged with each other
although i am giving space between
the levels.

any solution will be appreciable.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2013 Merge Data 2
grouping inside a macro 1
At each change in data concatenate text values in contiguous ranges 2
VB Script Code needed for Grouping Rows 0
Grouping Names in Mail Merge 0
Conditional Formatting Problem - Dynamic Formula?? 2
need help creating masterid's for duplicate records with unique id's. 1
Convert Cell w/ Manual Breaks into New Rows 4

Top