Forum Discussion

Aure's avatar
Aure
Occasional Contributor
10 years ago

Export data from RadTreeListView (Telerik ThirdParty)

Hi Everyone, I need to export the results contained in a RadTreeListView object. There is a lot of data inside and i can't afford to process cells and rows one by one (in terms of testing time) ...
  • HKosova's avatar
    HKosova
    10 years ago

    Try using the dotNET object obtained directly from the tree list object. Maybe the global dotNET object uses a different .NET version than that used in the app, and that causes conflicts.

    Also note that Export needs a Stream object, not a StreamWriter. A FileStream should work.

     

    var dotNET2 = RootApp.Grid.ContentControl.ContentPresenter.RadTreeListView.ClrAppDomain.dotNET;

    // Use dotNET2 to create parameters for the Export method call

// Initialize GridViewExportOptions
var options = dotNET2.Telerik_Windows_Controls.GridViewExportOptions.zctor();
options.Encoding = dotNET2.System_Text.Encoding.Unicode;
options.ShowColumnHeaders = true;
options.ShowColumnFooters = true;

// Initialize the FileStream
var fileStream = dotNET2.System_IO.File.Create(path);

RootApp.Grid.ContentControl.ContentPresenter.RadTreeListView.Export(fileStream, options);
fileStream.Close();
HKosova's avatar
HKosova
SmartBear Alumni (Retired)

You can create a GridViewExportOptions object like this:

// JScript

// Get the dotNET object from the app,
// so that it's compatible with the app's .NET version
var dotNET2 = Sys.Process("YourApp").AppDomain("YourApp.exe").dotNET;

var options = dotNET2.Telerik_Windows_Controls.GridViewExportOptions.zctor();
options.Format = dotNET2.Telerik_Windows_Controls.ExportFormat.Xlsx;
options.Encoding = dotNET2.System_Text.Encoding.Unicode;
options.ShowColumnHeaders = true;

 

Aure's avatar
Aure
Occasional Contributor
10 years ago

Thousands thanks for you answer HKosova!
I did not know about this trick, it will help me a lot in the future.

Unfortunately i am getting exception while calling the Export method.
Here is the exception:

Invalid procedure call or argument
Error location:
Unit: "TestProject2\TestProject2\Script\Unit1"
Line: 28 Column: 3. (Where i call the Export method)
 
 
Here is my code:
  //Initialize GridViewExportOptions  
var dotNET2=Aliases.MachiningCloudApp.AppDomain("MachiningCloudApp.exe").dotNET;
  var options = dotNET2.Telerik_Windows_Controls.GridViewExportOptions.zctor();
  options.Format = dotNET2.Telerik_Windows_Controls.ExportFormat.Csv;
  options.Encoding = dotNET2.System_Text.Encoding.Unicode;
  options.ShowColumnHeaders = true;
  options.ShowColumnFooters= true;
  
  //Initialize the StreamWriter
  var sw =dotNET.System_IO.StreamWriter.zctor_5(path);
  sw.AutoFlush=true;

  //Call Export method (RootApp represents the parent aliases). RootApp.Grid.ContentControl.ContentPresenter.RadTreeListView.Export(sw,options);
  
  //Close the stream
  sw.Close();

 

I am not really sure if i missed somthing or if the issue is on the app side.

Thanks for you help!

  • HKosova's avatar
    HKosova
    SmartBear Alumni (Retired)
    10 years ago

    Try using the dotNET object obtained directly from the tree list object. Maybe the global dotNET object uses a different .NET version than that used in the app, and that causes conflicts.

    Also note that Export needs a Stream object, not a StreamWriter. A FileStream should work.

     

    var dotNET2 = RootApp.Grid.ContentControl.ContentPresenter.RadTreeListView.ClrAppDomain.dotNET;

    // Use dotNET2 to create parameters for the Export method call

// Initialize GridViewExportOptions
var options = dotNET2.Telerik_Windows_Controls.GridViewExportOptions.zctor();
options.Encoding = dotNET2.System_Text.Encoding.Unicode;
options.ShowColumnHeaders = true;
options.ShowColumnFooters = true;

// Initialize the FileStream
var fileStream = dotNET2.System_IO.File.Create(path);

RootApp.Grid.ContentControl.ContentPresenter.RadTreeListView.Export(fileStream, options);
fileStream.Close();
    • Aure's avatar
      Aure
      Occasional Contributor
      10 years ago

      Working perfectly! Thanks a lot!