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.

GroupingGridExcelConverterControl - Export the values as of Type Text

Thread ID:

Created:

Updated:

Platform:

Replies:

63387 Jul 3,2007 11:27 AM Oct 25,2011 08:02 AM Windows Forms 3
loading
Tags: Grouping
shiju
Asked On July 3, 2007 11:27 AM

Hi ,

I am using the
converter.GroupingGridToExcel(aSelectedGrid, saveFileDialog.FileName, Syncfusion.GridExcelConverter.ConverterOptions.Visible);
to export the values to an spread sheet . While exporting, one of the column value in gridgrouping control is lossing its format because of the excel property.

how can i fix this while exporting ?

for eg a value of '3073E0108 is exported as '3.073E+108'

Thanks,
Shiju

haneefm [Syncfusion]
Replied On July 3, 2007 07:18 PM

Hi Shiju,

Below is a forum that discuss with the simillar issue in a grid.
http://www.syncfusion.com/support/Forums/message.aspx?&MessageID=42662

The ExportElement event has newly added in Essential Studio V5.1.In that event, you can customize the exported element from the grid. Below are the code snippet.

GroupingGridExcelConverterControl converter = new GroupingGridExcelConverterControl();
converter.ExportElement += new GroupingGridExcelConverterControl.GridExportElementEventHandler(converter_ExportElement);

void converter_ExportElement(object sender, GridExportElementEventArgs e)
{
Console.WriteLine(e.Element.Info);
Record rec = e.Element.GetRecord();
if (e.Element.Kind != DisplayElementKind.AddNewRecord
&& rec != null)
{
rec.SetValue("ParentName", "welcome");
}
}

Best regards,
Haneef

Harsh Yarlagadda
Replied On October 12, 2011 05:48 PM

The example does not show, how to retain the formatting. I have a groupinggrid control and I am using GroupingGridToExcel to export it to excel. I cannot use GridExcelConverterControl, since it does not export the hidden rows. I have numeric value formatted as Percentages and Currencies. How to retain this formatting while able to export all the hidden rows?


Ragamathulla B [Syncfusion]
Replied On October 25, 2011 08:02 AM

Hi Harsha,

We deeply regret for the delay,

Please let me know which version you are using which is helpful for us to have a closer look and provide you a better solution.

Appreciate your patience.

Regards,
Ragamathullah B.



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.

;