Hello,

Thank you for your question.

By default, WebGrid didn’t have feature to export the Hierarchical WebGrid with its hierarchical structure.
However you could export the Root table and Child table separately.
But WebGrid only export the selected Child table from a row (one row) in Root table, not all Child table rows.

For further information regarding exporting WebGrid data from JavaScript, please kindly follow this link below:
http://www.intersoftpt.com/Support/WebGrid/KB/Export-WebGrid-Data-Using-Javascript/

Hope this helps.
Thank you.

Regards,
Hans K.

Hi Hans,

Thanks for the reply.
I saw the above link, I want to know how to export the child table using javascript i.e. how to pass the parent row parameter in ExportGrid javascript function.
Give me some sample for the Exporting Child table data using "ExportGrid" javascript function.

Waiting for your reply..

Thanks and Regards,
Ganesh Nayak K

Hello,

I try to modify one of WebGrid Samples Solution, HierarchicalGrid.aspx page, by adding a couple of buttons to export WebGrid data.

Here’s snippet example code how to export the root table:

function ExportRootTable() {    var WebGrid1 = ISGetObject("WebGrid1");

    //export grid data to Microsoft Excel
    WebGrid1.ExportGrid("Customers", "EXCEL", "PORTRAIT");
            
    return true;
}

Here’s snippet example code how to export the child table:

function ExportSelectedChildTable_Orders() {
    var WebGrid1 = ISGetObject("WebGrid1");

    //export grid data to Microsoft Excel
    WebGrid1.ExportGrid("Orders", "EXCEL", "PORTRAIT", WebGrid1.GetSelectedObject().ToRowObject().GetParentRow().RowElement);

    return true;
}

I attached the page that show how implement the JavaScript code.
Please try to add the page to the WebGrid Samples Solution to see the result.

Regards,
Hans K.

Hi Hans,

Thanks for the Reply..

Can u provide me the javascript code for exporting the self referenced grid data to excel.

We are facing an issue with WebGrid (7.0.7200.431 & 8.0.7200.259). When we are exporting the Self referenced Grid data to ‘Excel’ file, self referenced data is not exporting.

We have altered below sample file provided with the Intersoft installation to reproduce the issue.

C:\Program Files (x86)\Intersoft Solutions\Intersoft Premier Studio 2014 R1\Samples\For ASP.NET\ISNet.WebUI.Samples\vb\WebGrid\SelfReferencingGrid.aspx

To simulate please click on the export icon select ‘Excel’ then click “Export Now” button.
Open exported file, see only Root row is exported.

Regards,
Ganesh Nayak K

Hello,

I apologize, currently WebGrid doesn’t have any feature to export child table in SelfReferencing mode.

I will forward this to the developer team to consider this as a feature request.

Thank you.

Regards,
Hans K.

Hi Han,

Thank u so much for the Reply..

In Intersoft, Export to Excel – Unable to Export to Excel when webgrid is binded with help of webservice.

Hi Support Team,
We are facing an issue with WebGrid (7.0.7200.431 & 8.0.7200.259). When we are exporting the Grid data to ‘Excel’ file, we are getting the javascript error “Invalid Client Service Command.”

We have altered below sample file provided with the Intersoft installation to reproduce the issue.

C:\Program Files (x86)\Intersoft Solutions\Intersoft Premier Studio 2014 R1\Samples\For ASP.NET\ISNet.WebUI.Samples\vb\WebGrid\ClientBinding_WebService.aspx
To simulate please click on the export icon select ‘Excel’ then click “Export Now” button.
Check the JavaScript error, we have attached the below image files as well.
“WebGrid - JavaScript Runtime Error 1” and WebGrid – “JavaScript Runtime Error 2”

I saw the forum it is the default drawback of the clientside binding.

Can u give me the sample for exporting if the grid is binded with webservice

Hello,

Exporting is not supported when binding mode is set to either WCF, WebService or Astoria. It is due to the datasource is handled externally from other external source, then return the data to Client-side directly to be processed. As for exporting, the data source needs to be on the Server-side in order to export the data and perform additional Server-side binding and processing.

Please have review on the documentation for further information.

Thank you.

Regards,
Hans K.