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

Radgrid doesnt export image in excel

30 Answers 773 Views

Grid

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

30 Answers, 1 is accepted

answered on 04 May 2010, 08:32 AM

Hi All,
I have a radgrid and I load image data by html tag <img> in GridTemplateColumn. I tried to use library NPOI, but can not display columns image in excel.
Here my code:

<telerik:GridTemplateColumn HeaderText="" UniqueName="Images">
<ItemTemplate>
<img src="<%=Global.Root %>/<%= Global.GetConfigKey("PresentationPath") %>/<%#DataBinder.Eval(Container.DataItem, "IconPath")%>" alt="" title="<%#DataBinder.Eval(Container.DataItem, "ResourceName")%>" style="width:128px; height:128px;" />
</ItemTemplate>
</telerik:GridTemplateColumn>

Please help me,
Thanks
Nguyen Trung Tin

answered on 08 May 2010, 05:02 AM

Hi Daniel,

Thanks for your reply. I tried to edit code in RadGridExporter.cs (function CreateExcelRow), convert img to Image object and I was successful. :). But the images in excel file have incorrect image size (the width is correct maybe, but the height not).

Here is my edit code:

    
            private void CreateExcelRow(int rowNum, GridItem item, HSSFSheet sheet) 
        
                { 
        
                    sheet.CreateRow(rowNum); 
        
                    for (int cellNum = 0; cellNum < item.Cells.Count; cellNum++) 
        
                    { 
        
                        TableCell cell = item.Cells[cellNum]; 
        
                        //The command item is handled separately since its cells should be merged 
        
                        if (item is GridCommandItem) 
        
                        { 
        
                            sheet.GetRow(rowNum).CreateCell(cellNum).SetCellValue(StripText(cell.Text)); 
        
                            sheet.AddMergedRegion(new NPOI.HSSF.Util.Region(0, 0, 0, item.OwnerTableView.RenderColumns.Length - 1)); 
        
                        } 
        
                        if (cell.HasControls()) 
        
                        { 
        
                            foreach (Control ctrl in cell.Controls) 
        
                            { 
        
                                //Handle TextBox controls 
        
                                //if (ctrl is ITextControl) 
        
                                //    sheet.GetRow(rowNum).CreateCell(cellNum).SetCellValue(StripText((ctrl as ITextControl).Text)); 
        
                                if (ctrl is ITextControl) 
        
                                { 
        
                                    if (!(ctrl as ITextControl).Text.Contains(".jpg") && !(ctrl as ITextControl).Text.Contains(".gif") && !(ctrl as ITextControl).Text.Contains(".png")) 
        
                                    { 
        
                                        if (!(ctrl as ITextControl).Text.Contains("tr>") && !(ctrl as ITextControl).Text.Contains("td>") && !(ctrl as ITextControl).Text.Contains("/>")) 
        
                                            sheet.GetRow(rowNum).CreateCell(cellNum).SetCellValue(StripText((ctrl as ITextControl).Text)); 
        
                                    } 
        
                                    else 
        
                                    { 
        
                                        string textTemp = (ctrl as ITextControl).Text.Replace("\r\n", "@"); 
        
                                        string[] listText = textTemp.Split('@'); 
        
                                        foreach (string text in listText) 
        
                                        { 
        
                                            if (!text.Contains("tr>") && !text.Contains("td>") && !text.Contains("/>") && !text.Trim().Equals(string.Empty)) 
        
                                            { 
        
                                                textTemp = Global.Root + "/" + Global.GetConfigKey("PresentationPath") + text.Replace("\"", "").Replace("\\", ""); 
        
                                                System.Web.UI.WebControls.Image img = new System.Web.UI.WebControls.Image(); 
        
                                                img.ImageUrl = textTemp; 
        
                                                img.Height = 128; 
        
                                                img.Width = 128; 
        
                                                if (!String.IsNullOrEmpty(img.ImageUrl)) 
        
                                                { 
        
                                                    //expand the row height when the picture overflows 
        
                                                    if ((img.Height.Value / 1.33333f) > 16) //assuming 75dpi 
        
                                                        sheet.GetRow(rowNum).HeightInPoints = (float)img.Height.Value / 1.33333f; //assuming 75dpi 
        
                                                    HSSFClientAnchor anchor = new HSSFClientAnchor(0, 0, 0, 0, cellNum, rowNum, cellNum, rowNum); 
        
                                                    anchor.AnchorType = 2; 
        
                                                    string path = ctrl.Page.Server.MapPath(img.ImageUrl); 
        
                                                    HSSFPicture picture = patriarch.CreatePicture(anchor, LoadImage(path, workbook)); 
        
                                                    picture.Resize(); 
        
                                                    break; 
        
                                                 } 
        
                                            } 
        
                                        } 
        
                                    } 
        
                                } 
        
                                //Handle Button controls (except ImageButton) 
        
                                if (ctrl is IButtonControl && !(ctrl is ImageButton)) 
        
                                    sheet.GetRow(rowNum).CreateCell(cellNum).SetCellValue(StripText((ctrl as IButtonControl).Text)); 
        
                                //Handle Images (including ImageButton) 
        
                                if (ctrl is System.Web.UI.WebControls.Image) 
        
                                { 
        
                                    if (!(item is GridCommandItem)) 
        
                                        sheet.GetRow(rowNum).CreateCell(cellNum); 
        
                                    System.Web.UI.WebControls.Image img = ctrl as System.Web.UI.WebControls.Image; 
        
                                    if (!String.IsNullOrEmpty(img.ImageUrl)) 
        
                                    { 
        
                                        //expand the row height when the picture overflows 
        
                                        if ((img.Height.Value / 1.33333f) > 16) //assuming 75dpi 
        
                                            sheet.GetRow(rowNum).HeightInPoints = (float)img.Height.Value / 1.33333f; //assuming 75dpi 
        
                                        HSSFClientAnchor anchor = new HSSFClientAnchor(0, 0, 0, 0, cellNum, rowNum, cellNum, rowNum); 
        
                                        anchor.AnchorType = 2; 
        
                                        string path = ctrl.Page.Server.MapPath(img.ImageUrl); 
        
                                        HSSFPicture picture = patriarch.CreatePicture(anchor, LoadImage(path, workbook)); 
        
                                        picture.Resize(); 
        
                                    } 
        
                                } 
        
                            } 
        
                        } 
        
                        else 
        
                        { 
        
                            sheet.GetRow(rowNum).CreateCell(cellNum).SetCellValue(StripText(cell.Text)); 
        
                        } 
        
                        ////Set the global styles for each cell - ItemStyle, AlternatingItemStyle, etc 
        
                        //if (item.ItemType == GridItemType.Item && globalStyles.ContainsKey("ItemStyle")) 
        
                        //    sheet.GetRow(rowNum).GetCell(cellNum).CellStyle = workbook.GetCellStyleAt(globalStyles["ItemStyle"]); 
        
                        //if (item.ItemType == GridItemType.AlternatingItem && globalStyles.ContainsKey("AlternatingItemStyle")) 
        
                        //    sheet.GetRow(rowNum).GetCell(cellNum).CellStyle = workbook.GetCellStyleAt(globalStyles["AlternatingItemStyle"]); 
        
                        //if (item.ItemType == GridItemType.Header && globalStyles.ContainsKey("HeaderStyle")) 
        
                        //    sheet.GetRow(rowNum).GetCell(cellNum).CellStyle = workbook.GetCellStyleAt(globalStyles["HeaderStyle"]); 
        
                        //if (item.ItemType == GridItemType.CommandItem && globalStyles.ContainsKey("CommandItemStyle")) 
        
                        //    sheet.GetRow(rowNum).GetCell(cellNum).CellStyle = workbook.GetCellStyleAt(globalStyles["CommandItemStyle"]); 
        
                        //if (item.ItemType == GridItemType.Footer && globalStyles.ContainsKey("FooterStyle")) 
        
                        //    sheet.GetRow(rowNum).GetCell(cellNum).CellStyle = workbook.GetCellStyleAt(globalStyles["FooterStyle"]); 
        
                    } 
        
                }

OK. Who help me this problem. Thanks all.

The programmer in Vietnam
Nguyen Trung Tin

answered on 09 Nov 2010, 01:31 PM

Hi everyone!

I needed a solution for exporting GridBinaryImageColumn's image, so i modified the RadGridExported class. I thought it could be useful for you guys and maybe telerik could insert it into the export code library:

//extend the createExcelRow method with the following lines (insert it after the '//Handle Images (including ImageButton)' code:

//Handle binary images

if (ctrl is Telerik.Web.UI.RadBinaryImage)

{

if (!(item is GridCommandItem))

{

sheet.GetRow(rowNum).CreateCell(cellNum);

}

RadBinaryImage img = ctrl as RadBinaryImage;

if (!String.IsNullOrEmpty(img.ImageUrl))

{

//240, 130 are hardcoded values (size of the image

sheet.SetColumnWidth(cellNum, 8640); //8640 = 240 * 36 | 36: magic number

sheet.GetRow(rowNum).HeightInPoints = 130;

HSSFClientAnchor anchor = new HSSFClientAnchor(0, 0, 0, 0, cellNum, rowNum, cellNum, rowNum);

anchor.AnchorType = 2;

HSSFPicture picture = patriarch.CreatePicture(anchor, LoadImage_Binary(img.DataValue, workbook));

picture.Resize();

picture.LineStyle = HSSFPicture.LINEWIDTH_ONE_PT; //single line border

}

----------------------------------------

/// <summary>

/// Loads the binary imamge for the workbook | Returns the index of the picture added to the workbook

/// </summary>

/// <param name="buffer">Binary image</param>

/// <param name="wb"></param>

/// <returns>The index of the picture added</returns>

private static int LoadImage_Binary(byte[] buffer, HSSFWorkbook wb)

{

int pictureType = 0;

pictureType = HSSFWorkbook.PICTURE_TYPE_JPEG;

return wb.AddPicture(buffer, pictureType);

}

I had problems with resizing the image, that's why i have hardcoded values for the cell size.
Do you guys have any idea why it won't display the image in other then the original size?

Thanks for the answer!
All the best,
Sergio

answered on 30 Sep 2011, 11:37 AM

http://www.aspsnippets.com/Articles/Export-GridView-with-Images-to-Word-Excel-and-PDF-Formats-in-ASP.Net.aspx

private void Excel_Export()

{

Response.Clear();

Response.Buffer = true;

Response.AddHeader("content-disposition",

"attachment;filename=GridViewExport.xls");

Response.Charset = "";

Response.ContentType = "application/vnd.ms-excel";

StringWriter sw = new StringWriter();

HtmlTextWriter hw = new HtmlTextWriter(sw);

GridView1.AllowPaging = false;

GridView1.DataBind();

for (int i = 0; i < GridView1.Rows.Count; i++)

{

GridViewRow row = GridView1.Rows[i];

//Apply text style to each Row

row.Attributes.Add("class", "textmode");

}

GridView1.RenderControl(hw);

//style to format numbers to string

string style = @"<style> .textmode { mso-number-format:\@; } </style>";

Response.Write(style);

Response.Output.Write(sw.ToString());

Response.Flush();

Response.End();

}

VB.Net

Private Sub Excel_Export()

Response.Clear()

Response.Buffer = True

Response.AddHeader("content-disposition", _

"attachment;filename=GridViewExport.xls")

Response.Charset = ""

Response.ContentType = "application/vnd.ms-excel"

Dim sw As New StringWriter()

Dim hw As New HtmlTextWriter(sw)

GridView1.AllowPaging = False

GridView1.DataBind()

For i As Integer = 0 To GridView1.Rows.Count - 1

Dim row As GridViewRow = GridView1.Rows(i)

'Apply text style to each Row

row.Attributes.Add("class", "textmode")

GridView1.RenderControl(hw)

'style to format numbers to string

Dim style As String = "<style> .textmode " _

& "{ mso-number-format:\@; } </style>"

Response.Write(style)

Response.Output.Write(sw.ToString())

Response.Flush()

Response.End()

End Sub

Figure below displays the Excel Workbook which contains exported GridView with images.

Product Bundles

DevCraft

Web

Mobile

Document Management

Desktop

Reporting & Mocking

Automated Testing

CMS

UI/UX Tools

Debugging

Free Tools

Support and Learning

Productivity and Design Tools

Radgrid doesnt export image in excel

30 Answers, 1 is accepted