* i have report using excel sheet in dynamically bind cell in image and records.
* click button excel sheet download successfully. but open excel sheet show alert in
* 'the file you are trying to open is in a different format than specified by the file extension. verify that the file is not corrupted and is form a trusted source before opening file. do you want to open the file now?' yes or no.
* and after yes click show image and records.
* but next time click button download excel sheet. not open new excel sheet.
* show alert in "the file you are trying to open is in a different format than specified by the file extension. verify that the file is not corrupted and is
form a trusted source before opening file. do you want to open the file now?"
* after yes click not open new record excel sheet. open previews record sheet.
* i have using code:
DomainBLL objbll = new DomainBLL();
DomainOrganisation domain = objbll.GetDomainOrganisationsDetails(orgid);
string image1;
//string pat = Server.MapPath;
if (domain.Imagefile != null)
{
image1 = Server.MapPath(@"~/" + domain.Imagefile);
}
else
{
image1 = Server.MapPath(@"~/Images/defaultlogo.jpg");
}
reportstartdd = Convert.ToString(hdnstartdate.Value);
reportendd = Convert.ToString(hdnenddate.Value);
string usercount = Convert.ToString(hdntotaluser.Value);
string novisit = Convert.ToString(hdnnoofvisit.Value);
string XlsPath = Server.MapPath(@"~/App_Data/test.xls");
string attachment = string.Empty;
if (XlsPath.IndexOf("\\") != -1)
{
string[] strFileName = XlsPath.Split(new char[] { '\\' });
attachment = "attachment; filename=" + strFileName[strFileName.Length - 1];
}
else
attachment = "attachment; filename=" + XlsPath;
try
{
Response.ClearContent();
Response.AddHeader("content-disposition", attachment);
Response.ContentType = "application/vnd.ms-excel";
Response.Write("\n");
Response.Write("Organisation Name");
Response.Write("\t");
Response.Write(ddlselect.SelectedItem);
Response.Write("\n");
Response.Write("Report Start Date");
Response.Write("\t");
Response.Write(Util.Convertmonthdate(reportstartdd));
Response.Write("\t");
Response.Write("Report End Date");
Response.Write("\t");
Response.Write(Util.Convertmonthdate(reportendd));
Response.Write("\n");
Response.Write("Total Current Users");
Response.Write("\t");
Response.Write(usercount);
Response.Write("\t");
Response.Write("Total Visits");
Response.Write("\t");
Response.Write(novisit);
Response.Write("\n");
Response.Write("Usage");
Response.Write("\n");
Response.Write("\n");
if (dt.Rows.Count != 0)
{
foreach (DataColumn datacol in dt.Columns)
{
// dataco;
Response.Write(tab + datacol.ColumnName);
tab = "\t";
}
Response.Write("\n");
foreach (DataRow dr in dt.Rows)
{
tab = "";
for (int j = 0; j < dt.Columns.Count; j++)
{
Response.Write(tab + Convert.ToString(dr[j]));
tab = "\t";
}
Response.Write("\n");
}
}
//Top 20 search report
tab = string.Empty;
DataTable dt1 = top20search;
if (dt1.Rows.Count != 0)
{
foreach (DataColumn datacol in dt1.Columns)
{
Response.Write(tab + datacol.ColumnName);
tab = "\t";
}
Response.Write("\n");
foreach (DataRow dr in dt1.Rows)
{
tab = "";
for (int j = 0; j < dt1.Columns.Count; j++)
{
Response.Write(tab + Convert.ToString(dr[j]));
tab = "\t";
}
Response.Write("\n");
}
}
//Top 10 careerchoice report
tab = string.Empty;
DataTable dt2 = top10careerchoice;
if (dt2.Rows.Count != 0)
{
foreach (DataColumn datacol in dt2.Columns)
{
Response.Write(tab + datacol.ColumnName);
tab = "\t";
}
Response.Write("\n");
foreach (DataRow dr in dt2.Rows)
{
tab = "";
for (int j = 0; j < dt2.Columns.Count; j++)
{
Response.Write(tab + Convert.ToString(dr[j]));
tab = "\t";
}
Response.Write("\n");
}
}
//Top 20 careersearch report
tab = string.Empty;
DataTable dt3 = top20tagsearch;
if (dt3.Rows.Count != 0)
{
foreach (DataColumn datacol in dt3.Columns)
{
Response.Write(tab + datacol.ColumnName);
tab = "\t";
}
Response.Write("\n");
foreach (DataRow dr in dt3.Rows)
{
tab = "";
for (int j = 0; j < dt3.Columns.Count; j++)
{
Response.Write(tab + Convert.ToString(dr[j]));
tab = "\t";
}
Response.Write("\n");
}
}
//widget report
tab = string.Empty;
DataTable dt4 = careerwidget;
if (dt4.Rows.Count != 0)
{
foreach (DataColumn datacol in dt4.Columns)
{
Response.Write(tab + datacol.ColumnName);
tab = "\t";
}
Response.Write("\n");
foreach (DataRow dr in dt4.Rows)
{
tab = "";
for (int j = 0; j < dt4.Columns.Count; j++)
{
Response.Write(tab + Convert.ToString(dr[j]));
tab = "\t";
}
Response.Write("\n");
}
}
//Dashboard report
tab = string.Empty;
DataTable dt5 = careerdashbard;
if (dt5.Rows.Count != 0)
{
foreach (DataColumn datacol in dt5.Columns)
{
Response.Write(tab + datacol.ColumnName);
tab = "\t";
}
Response.Write("\n");
foreach (DataRow dr in dt5.Rows)
{
tab = "";
for (int j = 0; j < dt5.Columns.Count; j++)
{
Response.Write(tab + Convert.ToString(dr[j]));
tab = "\t";
}
Response.Write("\n");
}
}
Response.End();
}
catch (Exception ex)
{
// Response.Write(ex.Message);
}