Export griddata with image to Excel

[San]

Hi
i have a column called image in my grid and this images i am binding from database and it's displaying in the radgrid but this image is not exporting to excel using Exporttoexcel command name.

what is the code/properties to export grid data with images into excel.



Thanks
Santosh

[Shinu]

Hi,

From Q3 2012 version, radgrid  supports image exporting when using BIFF Export. Check the following help documentation for more.
Excel BIFF (Binary) Export

Thanks,
Shinu.

[San]

Hi Shinu,
it's not working ,Image column is showing as null in excel sheet after exporting...

Please give me some other solution if you know..

Thanks in advance...

Santosh

[Shinu]

Hi,

Unfortunately I cannot replicate the issue at my end. Here is the full code that I tried which worked as expected.
aspx:

<telerik:RadGrid ID="RadGrid1" AutoGenerateColumns="false" DataSourceID="SqlDataSource2"
            runat="server">
            <ExportSettings Excel-Format="Biff">
            </ExportSettings>
            <MasterTableView CommandItemDisplay="Top">
                <CommandItemSettings ShowExportToExcelButton="true" />
                <Columns>
                    <telerik:GridBoundColumn DataField="EmployeeID">
                    </telerik:GridBoundColumn>
                    <telerik:GridTemplateColumn>
                        <ItemTemplate>
                            <asp:Image ID="Image" ImageUrl="~/Images/img.gif" runat="server" />
                        </ItemTemplate>
                    </telerik:GridTemplateColumn>
                </Columns>
            </MasterTableView>
</telerik:RadGrid>

Thanks,
Shinu.

[San]

Hi Shinu,

i have used your same code just assigned the grid with my SqlDataSource2  but it's not working.i don't exactly what is the problem.
could you please provide me the full code with database so that i can try it out.

Thanks
Santosh

[Shinu]

Hi,

Here is the full code.
aspx:

<asp:ScriptManager ID="ScriptManager1" runat="server">
       </asp:ScriptManager>
       <telerik:RadGrid ID="RadGrid1" AutoGenerateColumns="false" DataSourceID="SqlDataSource2"
           runat="server">
           <ExportSettings Excel-Format="Biff">
           </ExportSettings>
           <MasterTableView CommandItemDisplay="Top">
               <CommandItemSettings ShowExportToExcelButton="true" />
               <Columns>
                   <telerik:GridBoundColumn DataField="EmployeeID">
                   </telerik:GridBoundColumn>
                   <telerik:GridTemplateColumn>
                       <ItemTemplate>
                           <asp:Image ID="Image" ImageUrl="~/Images/editServerButton.gif" runat="server" />
                       </ItemTemplate>
                   </telerik:GridTemplateColumn>
               </Columns>
           </MasterTableView>
       </telerik:RadGrid>
   </div>
   <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
       SelectCommand="select  * from [Employees]"></asp:SqlDataSource>

Thanks,
Shinu.