This question is locked. New answers and comments are not allowed.
I created radgid header name dynamically in ItemDataBound but when i export the data in to excel i am getting the default value from query.
protected void radweeklygrid_ItemDataBound(object sender, GridItemEventArgs e)
{
try
{
if (e.Item is GridHeaderItem)
{
GridHeaderItem head = e.Item as GridHeaderItem;
if (e.Item.Cells[6].Text == "W1")
{
e.Item.Cells[6].Text = beforemonday5h.ToString() + "<br/>" + "To" + "<br/>" + beforesunday5h.ToString();
}
if (e.Item.Cells[7].Text == "W2")
{
e.Item.Cells[7].Text = beforemonday4h.ToString() + "<br/>" + "To" + "<br/>" + beforesunday4h.ToString();
}
if (e.Item.Cells[8].Text == "W3")
{
e.Item.Cells[8].Text = beforemonday3h.ToString() + "<br/>" + "To" + "<br/>" + beforesunday3h.ToString();
}
if (e.Item.Cells[9].Text == "W4")
{
e.Item.Cells[9].Text = beforemonday2h.ToString() + "<br/>" + "To" + "<br/>" + beforesunday2h.ToString();
}
if (e.Item.Cells[10].Text == "W5")
{
e.Item.Cells[10].Text = beforemonday1h.ToString() + "<br/>" + "To" + "<br/>" + beforesunday1h.ToString();
}
if (e.Item.Cells[11].Text == "W6")
{
e.Item.Cells[11].Text = beforemondayh.ToString() + "<br/>" + "To" + "<br/>" + beforesundayh.ToString();
}
}
}
}
and my excel sheet is and i am not able to show the footer also.
Project Name Project Manager Lead Developer Lead QA W1 W2 W3 W4 W5 W6 Total hours
xxxxx xxxxx xxx xxx 40 24 24 9 0 0 97
xxxxx xxxxx xxx xxx 0 0 6 196 233 45 480
i want the dynamic value of W1 to W6 in the excel sheet and footer also not showing.
In the application interface it was showing the dynamic values of the column and footer value.
protected void radweeklygrid_ItemDataBound(object sender, GridItemEventArgs e)
{
try
{
if (e.Item is GridHeaderItem)
{
GridHeaderItem head = e.Item as GridHeaderItem;
if (e.Item.Cells[6].Text == "W1")
{
e.Item.Cells[6].Text = beforemonday5h.ToString() + "<br/>" + "To" + "<br/>" + beforesunday5h.ToString();
}
if (e.Item.Cells[7].Text == "W2")
{
e.Item.Cells[7].Text = beforemonday4h.ToString() + "<br/>" + "To" + "<br/>" + beforesunday4h.ToString();
}
if (e.Item.Cells[8].Text == "W3")
{
e.Item.Cells[8].Text = beforemonday3h.ToString() + "<br/>" + "To" + "<br/>" + beforesunday3h.ToString();
}
if (e.Item.Cells[9].Text == "W4")
{
e.Item.Cells[9].Text = beforemonday2h.ToString() + "<br/>" + "To" + "<br/>" + beforesunday2h.ToString();
}
if (e.Item.Cells[10].Text == "W5")
{
e.Item.Cells[10].Text = beforemonday1h.ToString() + "<br/>" + "To" + "<br/>" + beforesunday1h.ToString();
}
if (e.Item.Cells[11].Text == "W6")
{
e.Item.Cells[11].Text = beforemondayh.ToString() + "<br/>" + "To" + "<br/>" + beforesundayh.ToString();
}
}
}
}
and my excel sheet is and i am not able to show the footer also.
Project Name Project Manager Lead Developer Lead QA W1 W2 W3 W4 W5 W6 Total hours
xxxxx xxxxx xxx xxx 40 24 24 9 0 0 97
xxxxx xxxxx xxx xxx 0 0 6 196 233 45 480
i want the dynamic value of W1 to W6 in the excel sheet and footer also not showing.
In the application interface it was showing the dynamic values of the column and footer value.