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

[Solved] Empty Spreadsheet on export

1 Answer 155 Views

Grid

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

Eddie asked on 29 May 2009, 01:34 PM

I'm not sure whats going on cause i'm getting my rows displayed on the grid but with I can ExportToExcel nothing is showing up. I am currently not using paging. I know I got this to work a few years back (non ajax ver)

    
                public partial class JobSearchbyPart : System.Web.UI.UserControl  
        
                {  
        
                    [DefaultValue("")]  
        
                    public string PartNumber  
        
                    {  
        
                        get 
        
                        {  
        
                            object partNumber = ViewState["PartNumber"];  
        
                            if (partNumber != null)  
        
                                return (string)partNumber;  
        
                            else 
        
                                return String.Empty;  
        
                        }  
        
                        set 
        
                        {  
        
                            ViewState["PartNumber"] = value;  
        
                        }  
        
                    }  
        
                    protected void Page_Load(object sender, EventArgs e)  
        
                    {  
        
                    }  
        
                    protected void txtPartNumber_TextChanged(object sender, EventArgs e)  
        
                    {  
        
                        PartNumber = txtPartNumber.Text;  
        
                        gvJob.DataBind();  
        
                    }  
        
                    protected void ImageButton1_Click(object sender, ImageClickEventArgs e)  
        
                    {  
        
                        gvJob.MasterTableView.ExportToExcel();  
        
                    }  
        
                }

HTML:

    
            <%@ Control Language="C#" AutoEventWireup="true" CodeBehind="JobSearchbyPart.ascx.cs" 
        
                Inherits="VantageShowOff.UserControls.JobSearchbyPart" %> 
        
            <%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %> 
        
            <div id="JobsbyPart">  
        
                <fieldset> 
        
                    <legend>Job Search by Part</legend> 
        
                    <div id="JobsbyPartHeader">  
        
                        <label for="txtPartNumber">  
        
                            Part:</label> 
        
                        <asp:TextBox ID="txtPartNumber" runat="server" OnTextChanged="txtPartNumber_TextChanged"></asp:TextBox> 
        
                        <br /> 
        
                        <asp:ImageButton ID="ImageButton1" runat="server" OnClick="ImageButton1_Click" /> 
        
                        <br /> 
        
                    </div> 
        
                    <div id="JobsbyPartData">  
        
                        <telerik:RadGrid ID="gvJob" runat="server" GridLines="None" DataSourceID="dsJobs">  
        
                            <ExportSettings ExportOnlyData="True" OpenInNewWindow="True">  
        
                                <Excel Format="ExcelML" /> 
        
                            </ExportSettings> 
        
                            <MasterTableView AutoGenerateColumns="False" DataSourceID="dsJobs">  
        
                                <RowIndicatorColumn> 
        
                                    <HeaderStyle Width="20px"></HeaderStyle> 
        
                                </RowIndicatorColumn> 
        
                                <ExpandCollapseColumn> 
        
                                    <HeaderStyle Width="20px"></HeaderStyle> 
        
                                </ExpandCollapseColumn> 
        
                                <Columns> 
        
                                    <telerik:GridBoundColumn DataField="PartNumber" HeaderText="PartNumber" SortExpression="PartNumber" 
        
                                        UniqueName="PartNumber">  
        
                                    </telerik:GridBoundColumn> 
        
                                    <telerik:GridBoundColumn DataField="JobNumber" HeaderText="JobNumber" SortExpression="JobNumber" 
        
                                        UniqueName="JobNumber">  
        
                                    </telerik:GridBoundColumn> 
        
                                    <telerik:GridBoundColumn DataField="Description" HeaderText="Description" SortExpression="Description" 
        
                                        UniqueName="Description">  
        
                                    </telerik:GridBoundColumn> 
        
                                    <telerik:GridBoundColumn DataField="RevisionNumber" HeaderText="RevisionNumber" SortExpression="RevisionNumber" 
        
                                        UniqueName="RevisionNumber">  
        
                                    </telerik:GridBoundColumn> 
        
                                    <telerik:GridBoundColumn DataField="SequenceNumber" HeaderText="SequenceNumber" SortExpression="SequenceNumber" 
        
                                        UniqueName="SequenceNumber">  
        
                                    </telerik:GridBoundColumn> 
        
                                    <telerik:GridBoundColumn DataField="StartDate" DataType="System.DateTime" HeaderText="StartDate" 
        
                                        SortExpression="StartDate" UniqueName="StartDate">  
        
                                    </telerik:GridBoundColumn> 
        
                                    <telerik:GridBoundColumn DataField="DueDate" DataType="System.DateTime" HeaderText="DueDate" 
        
                                        SortExpression="DueDate" UniqueName="DueDate">  
        
                                    </telerik:GridBoundColumn> 
        
                                    <telerik:GridCheckBoxColumn DataField="Completed" DataType="System.Boolean" HeaderText="Completed" 
        
                                        SortExpression="Completed" UniqueName="Completed">  
        
                                    </telerik:GridCheckBoxColumn> 
        
                                </Columns> 
        
                            </MasterTableView> 
        
                        </telerik:RadGrid> 
        
                        <asp:ObjectDataSource ID="dsJobs" runat="server" SelectMethod="getJobsbyPart" TypeName="DataServices.Models.jobasmbl">  
        
                            <SelectParameters> 
        
                                <asp:ControlParameter ControlID="txtPartNumber" Name="partNumber" PropertyName="Text" 
        
                                    Type="String" /> 
        
                            </SelectParameters> 
        
                        </asp:ObjectDataSource> 
        
                    </div> 
        
                </fieldset> 
        
            </div>

[Solved] Empty Spreadsheet on export

1 Answer, 1 is accepted