How do I programmatically create Excel row groups with the +/- box at the top of the group, not bottom
I am creating an Excel 开发者_JAVA百科sheet programmatically. I like to show group totals above each group, and for this to look best the +/- sign that opens and closes the rows should be at the top, where the total row is.
Is there a way to accomplish this?
TIA,
Alex
Put the formulas in the row, then group the rows below with the option - Data->Group and Outline -> Group.
Hope this helps..
精彩评论