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.

After exporting the columns are exported as Text

Thread ID:

Created:

Updated:

Platform:

Replies:

127541 Nov 22,2016 04:28 AM Nov 23,2016 05:39 AM Windows Forms 1
loading
Tags: GridGroupingControl
sachin
Asked On November 22, 2016 04:28 AM

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 05:39 AM

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.

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.

;