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.

Reg: GridGroupingControl to Excel sheet

Thread ID:





32079 Jul 21,2005 06:23 AM Jul 21,2005 07:35 AM Windows Forms 1
Tags: GridControl
Anna Srinivasan
Asked On July 21, 2005 06:23 AM

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 07:35 AM

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.

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.