Forums Ultimate UI for ASP.NET Web Forms
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Madhura
30
Export a UltraTree to Excel
posted

Normal 0 false false false MicrosoftInternetExplorer4

Hi,

I am trying to export a UltraTree to Excel. I am referring to the following post:

http://devcenter.infragistics.com/Support/KnowledgeBaseArticle.aspx?ArticleID=10055

The table which is bind to this ultraTree is self referencing table. For self referencing table Export to Excel is not working. I copied the UltraTree's DataSource to a temperary UltraGrid and try to export this UltraGrid to Excel. But it gives blank Excel. The example of self referencing table tree is given at:

http://devcenter.infragistics.com/Support/KnowledgeBaseArticle.aspx?ArticleID=10084

Is this a known issue? Is there any way to Export a self Referencing tree to Excel? I try to traversing whole tree node by node and then forming a UltraGrid from it and exporting that Grid. But this solution does not allow Expand and Collapse capability. For large data we require expand and collapse capability.

Please suggest some way of exporting self referencing UltraTree to Excel.

Thanks & Regards,

MVB


Parents
No Data
Reply
  • 30
    posted

    Hi All,

    I am waiting for some help on this.

    I further try to analyze the behavior. I capture the events BeginExport, EndExport, ExportingHeaderRow, ExportingCell. After executing command

    ultraGridExcelExporter1.Export(UltraGrid1, filename);

    It hits BeginExport event and the argument has ActualRowsCount as 0. And then it hits EndExport, without hitting any other events. Do we need to set anything extra?

    I am doing following things:

    UltraGrid1.DataSource = ultraTree1.DataSource;

     

     

    String filename = "tempfile.xls";

    ultraGridExcelExporter1.Export(UltraGrid1, filename);

    Any kind of help on this is appreciated.

    Thanks in advance.
    MVB

Children