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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

After exporting the columns are exported as Text

Thread ID:

Created:

Updated:

Platform:

Replies:

127541 Nov 22,2016 09:28 AM UTC Nov 23,2016 10:39 AM UTC WinForms 1
loading
Tags: GridGroupingControl
sachin
Asked On November 22, 2016 09:28 AM UTC

Hello,

i am using syncfusion gridGroupingControl in my windows application and when i export the grid data to excel ,the data is getting exported nicely but when i open that excel file in excel all the fields are showing as text field in excel even the filed which has number data type in the grid. 
can you please tell how to export grid data to excel without the number field getting changed to text filed?. 


Thanks.

Piruthiviraj Malaimelraj [Syncfusion]
Replied On November 23, 2016 10:39 AM UTC

Hi Sachin, 

Thanks for your interest in Syncfusion products. 

We have analyzed your reported scenario and tested by exporting the grid with numeric columns to excel with GroupingGridExcelConverterControl and GridGroupingExcelConverterControl. Unfortunately we could not able to reproduce the reported scenario at our end. The numeric columns values are exported as Number type in excel sheet. Could you please provide the following details, 
·         Provide the build version details that used in your application project. 
·         Which class is used to export the grid to excel.(GroupingGridExcelConverterControl or GridGroupingExcelConverterControl
·         Ensure the reported issue is reproduced in the attached sample. If the still the issue is exists , please provide the screen shots which represents the reported scenario. 

These above details would be more useful for us to provide the exact solution at the earliest. 

Sample link: 

Regards, 
Piruthiviraj 


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.

Warning Icon 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.Close Icon

;