Welcome to the Xceed Community | Help
Community Search  
More Search Options

Exporting detail rows using ExcelExporter to appear using Outline feature in Excel

Sort Posts: Previous Next
  •  03-09-2010, 8:35 PM Post no. 26047

    Exporting detail rows using ExcelExporter to appear using Outline feature in Excel

    When using the ExcelExporter to export a grid containing detail rows to Excel, the resultant spreadsheet shows the detail rows as extra columns.  Is there any way to make this appear using the Outline feature in Excel which would be a more appropriate way to display detail rows?  I'm using the following code:

    var exporter = new ExcelExporter(dgc)
    {
        DetailDepth = int.MaxValue,
        StatFunctionDepth = 1,
        ShowStatsInDetails = true,
        ExportStatFunctionsAsFormulas = true,
    };

    exporter.Export(fileName);


    Associate, .NET Development
    Morgan Stanley, UK
  •  03-10-2010, 4:44 PM Post no. 26065 in reply to 26047

    Re: Exporting detail rows using ExcelExporter to appear using Outline feature in Excel

     

    Unfortunately, it is not possible to not export the detail rows as extra columns. There is no method to make this appear using the Outline feature in Excel. I have no workaround that I could propose for your request.


    Xceed - Software Developer and Technical Support
  •  03-11-2010, 6:14 AM Post no. 26068 in reply to 26065

    Re: Exporting detail rows using ExcelExporter to appear using Outline feature in Excel

    "it is not possible to not export the detail rows as extra columns."

    I'm not sure what you mean by this, because this is exactly how it does work at the moment.

    However, to demonstrate what I require, I have attached a zip file containing two Excel files - one containing the current way it is done, the other containing the proposed method.  The proposed method uses the Outline feature to display details rows, but it must be saved in .xls format, not .xml.

    Could this be raised as a feature request please?


    Associate, .NET Development
    Morgan Stanley, UK
  •  03-25-2010, 5:36 PM Post no. 26285 in reply to 26068

    Re: Exporting detail rows using ExcelExporter to appear using Outline feature in Excel

    Support, could you please reply to my last post?

    Thanks.


    Associate, .NET Development
    Morgan Stanley, UK
  •  03-30-2010, 7:10 AM Post no. 26326 in reply to 26285

    Re: Exporting detail rows using ExcelExporter to appear using Outline feature in Excel

    Support, could you please reply to my last post - I need to know whether a feature request will be raised on this.
    Associate, .NET Development
    Morgan Stanley, UK
  •  04-26-2010, 12:04 PM Post no. 26617 in reply to 26326

    Re: Exporting detail rows using ExcelExporter to appear using Outline feature in Excel

    Support, any chance of a reply on this please?
    Associate, .NET Development
    Morgan Stanley, UK
  •  04-30-2010, 11:49 AM Post no. 26664 in reply to 26617

    Re: Exporting detail rows using ExcelExporter to appear using Outline feature in Excel

    Support, could I please get some feedback on this?
    Associate, .NET Development
    Morgan Stanley, UK
  •  05-05-2010, 8:20 PM Post no. 26731 in reply to 26664

    Re: Exporting detail rows using ExcelExporter to appear using Outline feature in Excel

    Support, could you PLEASE reply on this!?
    Associate, .NET Development
    Morgan Stanley, UK
  •  05-11-2010, 2:51 PM Post no. 26796 in reply to 26731

    Re: Exporting detail rows using ExcelExporter to appear using Outline feature in Excel

    Hi,

    Currently, there is no plan in updating the export details feature in order to appear using Outline feature in Excel.

     

     

    Xceed - Software Developer and Technical Support
View as RSS news feed in XML
Contact | Site Map | Reviews | Legal Terms of Use | Trademarks | Privacy Statement Copyright 2011 Xceed Software Inc.