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

Export to excel from RadGrid is blank when binded using dynamically through vb code

8 Answers 473 Views

General Discussions

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

Kavita asked on 25 Sep 2013, 12:26 PM

Hi,
I have a search form , in which user fills information.
Is is not compulsory to fill all the information, so whatever user has filled according to that i show the result in my RadGrid.

My query looks like this.

Dim connection As SqlConnection =
New SqlConnection(ConfigurationManager.ConnectionStrings("InductoServConnectionString").ToString())
connection.Open()

cmd = New SqlCommand("select * from tblServiceReports where " + Condition, connection)

myReader = cmd.ExecuteReader()

gdCstRecovery.DataSource = myReader

Here "condition" is a variable which contains parameters.

When radgrid shows the result, i try to export it using provided button Export to Excel in ExcelML format.
But excel is coming blank. No column or any data is present.
Please help. It is quite urgent.

8 Answers, 1 is accepted

answered on 26 Sep 2013, 12:19 PM

Hi Kavitha,

Please try the sample code snippet to export footer to excel.

ASPX:

<asp:Button ID="Button1" runat="server" Text="Export" OnClick="Button1_Click" />

<telerik:RadGrid ID="RadGrid1" runat="server" OnNeedDataSource="RadGrid1_NeedDataSource"

Width="600px" OnExcelMLExportRowCreated="RadGrid1_ExcelMLExportRowCreated">

<ExportSettings ExportOnlyData="true" Excel-Format="ExcelML" />

<MasterTableView AutoGenerateColumns="false" ShowFooter="true">

<Columns>

<telerik:GridBoundColumn Aggregate="Count" DataField="ProductName" FooterAggregateFormatString="Total products: {0}" />

<telerik:GridBoundColumn Aggregate="Sum" DataField="Price" FooterAggregateFormatString="Total: {0}" />

<telerik:GridBoundColumn DataField="Manufacturer" />

</Columns>

</MasterTableView>

</telerik:RadGrid>

C#:

protected void RadGrid1_NeedDataSource(object source, GridNeedDataSourceEventArgs e)

{

DataTable table = new DataTable();

table.Columns.Add("ProductName");

table.Columns.Add("Price", typeof(double));

table.Columns.Add("Manufacturer");

table.Rows.Add("Futo maki", 12.44, "Osaka Nihonbashi");

table.Rows.Add("Musaka", 10.61, "Sofiiski gozbi");

table.Rows.Add("Cheesezer", 9.50, "Burger mafia");

RadGrid1.DataSource = table;

}

protected void RadGrid1_ExcelMLExportRowCreated(object source, GridExportExcelMLRowCreatedArgs e)

{

if (e.Worksheet.Table.Rows.Count == RadGrid1.Items.Count + 1)

{

RowElement row = new RowElement();

GridFooterItem footer = (source as RadGrid).MasterTableView.GetItems(GridItemType.Footer)[0] as GridFooterItem;

foreach (GridColumn column in (source as RadGrid).MasterTableView.Columns)

{

CellElement cell = new CellElement();

string cellText = footer[column.UniqueName].Text;

cell.Data.DataItem = cellText == " " ? "" : cellText;

row.Cells.Add(cell);

}

e.Worksheet.Table.Rows.Add(row);

}

protected void Button1_Click(object sender, EventArgs e)

{

RadGrid1.MasterTableView.ExportToExcel();

}

Thanks,
Princy