Route 53 has the ability to easily configure DNS record sets specifically for failover scenarios. These failover record sets can be configured to failover to full-blown deployments in other regions or to a static HTML page that informs your customers of the issue.
Solved
ASP.NET - C# - set gridview cell as text and export to excel as text
Posted on 2012-12-21
I am populating a grid with data from a database. I am then exporting that data to excel. The problem I am having is that a column will have a value "001" but it exports as "1". How can I define it so it is text when it exports?
protected void ExportToExcel(DataTable dt)
{
string sFileName = "Data_" + DateTime.Now.Year + DateTime.Now.Month + DateTime.Now.Day + ".xls";
GridView gv = new GridView();
gv.AllowPaging = false;
gv.DataSource = dt;
gv.DataBind();
Response.Clear();
Response.ClearContent();
Response.ClearHeaders();
Response.Buffer = true;
Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", sFileName));
Response.ContentType = "application/vnd.ms-excel";
//Response.ContentType = "application/vnd.openxmlformats";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
//Change the Header Row Foreground to white color
gv.HeaderRow.Style.Add("color", "#FFFFFF");
//Applying stlye to gridview header cells
for (int i = 0; i < gv.HeaderRow.Cells.Count; i++)
{
//Change to Blue
gv.HeaderRow.Cells[i].Style.Add("background-color", "#507CD1");
}
int j = 1;
//This loop is used to apply stlye to cells based on particular row
foreach (GridViewRow gvrow in gv.Rows)
{
gvrow.BackColor = Color.White;
if (j <= gv.Rows.Count)
{
if (j % 2 != 0)
{
for (int k = 0; k < gvrow.Cells.Count; k++)
{
gvrow.Cells[k].Style.Add("background-color", "#EFF3FB");
}
}
}
j++;
}
gv.RenderControl(htw);
Response.Write(sw.ToString());
Response.Flush();
Response.End();
}
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
5
2
8 Comments
string myString = myInt.ToString();
also, if you need to pad leading zeros or format, check this info:
http://msdn.microsoft.com/en-us/library/dd260048.aspx
also, if you need to pad leading zeros or format, check this info:
http://msdn.microsoft.com/en-us/library/dd260048.aspx
Active today
I walked through the values in the DataTable and GridView and both contain 001. The problem is when it opens in excel that it formats it to a number.
Any ideas?
Any ideas?
Hi, try this
protected void Button1_Click(object sender, EventArgs e)
{
this.gvw1.Columns[0].Heade
}
protected void Button1_Click(object sender, EventArgs e)
{
this.gvw1.Columns[0].Heade
}
You should be able to format the column in question to be text using:
.EntireColumn.NumberFormat
.EntireColumn.NumberFormat
Active today
@jjester1 - where would i put that code ".EntireColumn.NumberForma
@samirbhogayta - why are you modifying the headertext?
@samirbhogayta - why are you modifying the headertext?
Active today
I figured it out.
Original Code
Code Fix
Original Code
foreach (GridViewRow gvrow in gv.Rows)
{
gvrow.BackColor = Color.White;
if (j <= gv.Rows.Count)
{
if (j % 2 != 0)
{
for (int k = 0; k < gvrow.Cells.Count; k++)
{
gvrow.Cells[k].Style.Add("background-color", "#EFF3FB");
}
}
}
j++;
}
Code Fix
foreach (GridViewRow gvrow in gv.Rows)
{
gvrow.BackColor = Color.White;
//HERE IS THE FIX - Format Specific Cell as Text
gvrow.Cells[21].Style.Add("mso-number-format", "\\@");
if (j <= gv.Rows.Count)
{
if (j % 2 != 0)
{
for (int k = 0; k < gvrow.Cells.Count; k++)
{
gvrow.Cells[k].Style.Add("background-color", "#EFF3FB");
}
}
}
j++;
}
Featured Post
Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Introduction
This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks.
Background
I had to provide a way for user…
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
How to fix incompatible JVM issue while installing Eclipse
While installing Eclipse in windows, got one error like above and unable to proceed with the installation.
This video describes how to successfully install Eclipse.
How to solve incompa…
Suggested Courses
Course of the Month8 days, 21 hours left to enroll
721 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.