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

Reg: GridGroupingControl to Excel sheet

Thread ID:





32079 Jul 21,2005 10:23 AM UTC Jul 21,2005 11:35 AM UTC WinForms 1
Tags: GridControl
Anna Srinivasan
Asked On July 21, 2005 10:23 AM UTC

Hi, I am using this code in my export to excel function. I have taken code from syncfusion.(Export to excel sample) string text = grid.TableModel[i, j].FormattedText.Replace("\n"," "); sheet.Range[i+1,j+1].Value2 = text; Here i am taking formatted text.(for ex 3 decimal place).In debug mode also iam getting 3 decimal place. But,In excel sheet i not getting 3 decimal place why..? Thanks, Anna

Administrator [Syncfusion]
Replied On July 21, 2005 11:35 AM UTC

If you want to pass the Format property to excel, then I think you woul dneed to set the .NumberFormat as well. sheet.Range[i+1,j+1].NumberFormat = grid.TableModel[i, j].Format; Here is a link to a sample using a GridDataBoundGrid that works ok with formats. http://www.syncfusion.com/Support/user/uploads/GDBG_WriteExcel_10516b47.zip


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.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

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