We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Importing Excel to Grid

Thread ID:

Created:

Updated:

Platform:

Replies:

68937 Oct 5,2007 12:23 PM Oct 26,2007 01:47 AM ASP.NET Web Forms (Classic) 3
loading
Tags: GridGroupingControl
Samantha Johnson
Asked On October 5, 2007 12:23 PM

I am in the process of evaluating your product and I see that there is a converter to export grid data to Excel. I also see that you can use xml as a datasource for the grid. I am curious if there is a parser to read the Excel XML data in to a grid.

Mohamed Suhaib Fahad A. [Syncfusion]
Replied On October 8, 2007 06:23 AM

Hi Samantha,

Thanks for evaluating Syncfusion products.

The Excel exporter converts the resultant data that is bound to the GridGroupingControl into an excel file. We don't have any specific parser to import data from Excel XML type. You can define your own schema in reading data from the SpreadsheetML (Excel XML) to an xml which corresponds to the heirarchy structure of XML Datasource. Then you can apply the transformation and bind the XML to the Grid.

Please let me know if you want any more details.

Thanks,
Fahad

Samantha Johnson
Replied On October 8, 2007 12:50 PM

I want to make sure I understand this. I see that the Windows form as an Excel converter, there is not the same idea for .net?

>Hi Samantha,

Thanks for evaluating Syncfusion products.

The Excel exporter converts the resultant data that is bound to the GridGroupingControl into an excel file. We don't have any specific parser to import data from Excel XML type. You can define your own schema in reading data from the SpreadsheetML (Excel XML) to an xml which corresponds to the heirarchy structure of XML Datasource. Then you can apply the transformation and bind the XML to the Grid.

Please let me know if you want any more details.

Thanks,
Fahad

Saravanan A [Syncfusion]
Replied On October 26, 2007 01:47 AM

Hi Samantha,

Similar to the windows forms we have the option to export the Grid content to Excel file in ASP.NET also. Please refer to the following sample, that demonstrate this.

http://www.syncfusion.com/Support/user/uploads/ExcelExport_80324f5d.zip

Let me know if you need any further assistance.

Regards,
Saravanan

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;