This is a migrated thread and some comments may be shown as answers.

Excel Reporting from RadGridView

5 Answers 73 Views

General Discussions

This is a migrated thread and some comments may be shown as answers.

5 Answers, 1 is accepted

answered on 01 May 2013, 06:51 PM

public static void SaveToExcel(object parameter, RadGridView radGridView, params string[] columnsRequiredFormatting)

{

try

{

string newLine = "\n";

string tab = "\t";

SaveFileDialog saveFileDialog = new SaveFileDialog();

saveFileDialog.Filter = "Excel Files (.xls)|*.xls|All Files (*.*)|*.*";

var objectList = (IList)parameter;

bool? dialogResult = saveFileDialog.ShowDialog();

if (dialogResult.Value)

{

TextWriter writer = new StreamWriter(saveFileDialog.OpenFile());

try

{

IList<string> binders = new List<string>();

writer.Write(string.Format("<html xmlns:x=\"urn:schemas-microsoft-com:office:excel\"> <table border=\"1\" width=\"100%\">"));

if (radGridView != null)

{

writer.Write(string.Format("<thead>"));

writer.Write(string.Format("<tr>"));

binders = radGridView.Columns.Where(c => c.Visibility == Visibility.Visible).Select(c =>

{

writer.Write("<th bgcolor=\"#5882FA\">" + c.Header.ToString() + "</th>");

writer.Write(tab);

return c.ClipboardContentBinding.Path.Path.ToString();

}).ToList();

writer.Write(string.Format("</tr>"));

writer.Write(string.Format("</thead>"));

}

writer.Write(newLine);

if (objectList.Count == 0)

{

writer.Write(string.Format("<tbody>"));

writer.Write(string.Format("<tr>"));

writer.WriteLine("There are no rows to be written under this section");

writer.Write(string.Format("</tr>"));

writer.Write(string.Format("</tbody>"));

writer.Write(newLine);

return;

}

string tdFormat = "<td x:str=\"'{0}\">{0}</td>";

string tdSimple = "<td>{0}</td>";

writer.Write(string.Format("<tbody>"));

if (columnsRequiredFormatting == null)

{

foreach (var reportData in objectList)

{

writer.Write(string.Format("<tr>"));

foreach (string binder in binders)

{

//Bar the properties which should not go

string propVal = string.Empty;

PropertyInfo propertyInfo = reportData.GetType().GetProperty(binder);

object prop = reportData.GetType().GetProperty(binder).GetValue(reportData, null);

if (prop != null)

propVal = prop.ToString();

writer.Write(String.Format(tdSimple, propVal));

}

writer.Write(string.Format("</tr>"));

}

else

{

foreach (var reportData in objectList)

{

writer.Write(string.Format("<tr>"));

//IEnumerable<bool> a = binders.Select(c =>

// {

// object propVal = "";

// bool formatReq = false;

// PropertyInfo prop = reportData.GetType().GetProperty(c);

// propVal = prop.GetValue(reportData, null);

// if (columnsRequiredFormatting.Contains(prop.Name.ToString()))

// formatReq = true;

// if (formatReq)

// writer.Write(String.Format(tdFormat, propVal.ToString()));

// else

// writer.Write(String.Format(tdSimple, propVal.ToString()));

// return true;

// });

foreach (string binder in binders)

{

//Bar the properties which should not go

string propVal = string.Empty;

PropertyInfo propertyInfo = reportData.GetType().GetProperty(binder);

object prop = reportData.GetType().GetProperty(binder).GetValue(reportData, null);

if (prop != null)

propVal = prop.ToString();

if (columnsRequiredFormatting.Contains(propertyInfo.Name.ToString()))

writer.Write(String.Format(tdFormat, propVal));

else

writer.Write(String.Format(tdSimple, propVal));

}

writer.Write(string.Format("</tr>"));

}

writer.Write(string.Format("</tbody>"));

writer.Write("</table> </html>");

}

finally

{

if (writer != null)

{

writer.Flush();

writer.Close();

}

catch (Exception ex)

{

//MessageBox.Show(ex.ToString());

throw;

}

I am using Save to excel code above Parameter, for That Save to excel even i put this code in view model,

#region

Public Methods

public void SaveToExcel(object parameter)

{

DataGrid dg = parameter as DataGrid;

Utils.SaveToExcel(PaymentDataList, dg, "xyz", "abc", "mno");

}

public bool SaveToExcelCanExecute(object parameter)

{

return true;

}

i am still not getting into it,to catch save to excel.

Thanks
Siddharth

answered on 02 May 2013, 03:21 PM

Hi,
i saw it, far better than typical exporting..but i quickl question how do you denote Examples, What exactly you mean by this??

<Examples:GridViewExample.Resources>
<local:ExportingModel x:Key="context" />

I simply start my code like this and below down after defining user control resources i define grid and underthat radgridview.

<UserControl x:Class="Sid.Modules.Views.CurrentYearDenomView"

xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

xmlns:d="http://schemas.microsoft.com/expression/blend/2008"

xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"

xmlns:i="clr-namespace:System.Windows.Interactivity;assembly=System.Windows.Interactivity"

xmlns:telerik="http://schemas.telerik.com/2008/xaml/presentation"

xmlns:local="clr-namespace:TaxReporting.Modules.Views"

xmlns:sdk="http://schemas.microsoft.com/winfx/2006/xaml/presentation/sdk"

xmlns:sys="clr-namespace:System;assembly=mscorlib"

mc:Ignorable="d"

d:DesignHeight="660" d:DesignWidth="440"

xmlns:conv="clr-namespace:TaxReporting.Modules.Converters"

xmlns:data="clr-namespace:TaxReporting.Modules.ViewModels"

xmlns:telerikGrp="clr-namespace:Telerik.Windows.Controls.GridView;assembly=Telerik.Windows.Controls.GridView"

xmlns:type="clr-namespace:System;assembly=mscorlib"

>

<UserControl.Resources>

<!--<Style x:Key="NewStyle"

TargetType="telerik:GridViewRow"

BasedOn="{StaticResource GridViewRowStyle}">

<Setter Property="Background"

Value="{StaticResource AccentBrush}" />

<Setter Property="Foreground"

Value="{StaticResource MainBrush}" />

</Style>

<Style x:Key="ExistingStyle"

TargetType="telerik:GridViewRow"

BasedOn="{StaticResource GridViewRowStyle}" />

Thanks
Sid

Product Bundles

DevCraft

Web

Mobile

Document Management

Desktop

Reporting & Mocking

Automated Testing

CMS

UI/UX Tools

Debugging

Free Tools

Support and Learning

Excel Reporting from RadGridView

5 Answers, 1 is accepted