excel How to make the "+"symbol at the left side of the outline

c# excel range outline
singa picture singa · Apr 1, 2011 · Viewed 7.3k times · Source

I am using range.group method from the Microsoft.Office.Interop.Excel.dll and it works to group up the columns or rows as the outline level in the Excel document; but there comes the question of how to set the "+"symbol at the left side, but not it's default position at the right side according to the last columns or rows.

What method is used for controlling the direction and how to use this method. It would be best if that's an example,.

Answer

Stijn Bollen picture Stijn Bollen · Feb 15, 2012

In excel: Data/Group and Outline/Settings...

In code:

range.Group(oMissing, oMissing, oMissing, oMissing);

//for rows
worksheet.Outline.SummaryRow = Excel.XlSummaryRow.xlSummaryAbove;

//for columns
worksheet.Outline.SummaryColumn = Excel.XlSummaryColumn.xlSummaryOnLeft;

Related questions

How to get specific Range in Excel through COM Interop?

I have to read an excel file through a COM interop. I search for a specific string using this: this.sheet = (Excel.Worksheet)this.excelApp.Workbook.Sheets.Item[this.sheetname]; this.sheet.Activate(); Excel.Range firstRow = this.sheet.Range["A1", "…

Read More
how to set values to a two-dimensional Excel range?

I need to build an excel sheet from a list of test-cases in a specific format in order to upload it it to the server. I've trubles to populate the two dimensional range of "expected" and "actual" in the file. …

Read More
How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?

How can I create an Excel spreadsheet with C# without requiring Excel to be installed on the machine that's running the code?

Read More