Intersoft Community - WebGrid Enterprise - How to Export Hierarchical Grid Data to Excel using javascript.

How to Export Hierarchical Grid Data to Excel using javascript.

Hans — Wed, 16 Jul 2014 22:34:09 GMT

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.

How to Export Hierarchical Grid Data to Excel using javascript.

GaneshNayakK — Wed, 16 Jul 2014 05:50:44 GMT

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

How to Export Hierarchical Grid Data to Excel using javascript.

Hans — Tue, 15 Jul 2014 23:12:13 GMT

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.

How to Export Hierarchical Grid Data to Excel using javascript.

GaneshNayakK — Tue, 15 Jul 2014 11:09:45 GMT

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

How to Export Hierarchical Grid Data to Excel using javascript.

Hans — Tue, 15 Jul 2014 02:25:41 GMT

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.

How to Export Hierarchical Grid Data to Excel using javascript.

GaneshNayakK — Mon, 14 Jul 2014 03:07:31 GMT

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

How to Export Hierarchical Grid Data to Excel using javascript.

Hans — Mon, 14 Jul 2014 02:56:26 GMT

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.

How to Export Hierarchical Grid Data to Excel using javascript.

GaneshNayakK — Fri, 11 Jul 2014 03:05:24 GMT

Hi,

Please provide the javascript to export the Hierarchical Grid Data to Excel. I have the below javscript code for Exporting the Root table. I have attached my sample.

In my sample I have integrated the excel icon to the status bar and onclick of it i am calling the below javascript function

function ExportToExcel(gridId)
{
var webGridId = ISGetObject(gridId);
webGridId.ExportGrid(webGridId.RootTable.Id, "EXCEL", "PORTRAIT");
}

Please can u provide the javscript code or some sample to export the Hierarchical Grid Data or child table data.

Regards,

Ganesh Nayak K