Remove images when exporting grid?

[Alan T]

Hi, i've got a radgrid with some template columns in that contain images.

Although when exporting the images aren't displayed, a missing image icon is displayed in its place. What i'd like to do is at the point of exporting, remove any images in each row if any are present, replacing them, ideally with their alt tag, resulting in just text.


Is this possible ?

Also i'm pretty sure this isn't possible but are you able to include data from another control in the page such as a header for example ?

e.g. i've got a radgrid of hits and their associated item. It'd be nice if i could put some totals in the exported file, which at the moment i'm showing in a seperate table inside a panel.


thanks, Alan

[Shinu]

Hello Alan,

Try the following code snippet.
C#:

protected void Button1_Click(object sender, EventArgs e)
{

RadGrid1.ExportSettings.ExportOnlyData = true;

foreach (GridDataItem item in RadGrid1.Items)
{

   TableCell cell = (TableCell)item["TemplateColumnUniqueName"];

   cell.Text = "your text";

}

RadGrid1.MasterTableView.ExportToExcel();
}

-Shinu.

[Alan T]

if i adapt the code you've written below, to check each rows controls collection for an 'Image' type then remove the image;

won't that then remove them from the grid itself though ?

i only want them removed from the exported file.

[Daniel]

Hi Alan,

Any changes you perform before exporting will not have any effect on your page - they will be applied to the exported file only.
By the way, have you tried to use the ExportOnlyData option?

Kind regards,
Daniel
the Telerik team

[Alan T]

sorry seem to have got posts mixed up here;

http://www.telerik.com/community/forums/aspnet-ajax/grid/radgrid-read-gridtemplatecolumn.aspx#1967246