Hi,
I have a dataset and i want to export it to excel. Problem is while one of
the datacolumn contains negative value and i want that column value to be
shown in brackets in excel.
In the dataset (datatable view) its getting displayed correctly. i.e.
(21,000)
But in the excel, its coming as -21,000 but i want it in (21,000) format.
Here is the piece of code which i am using...
*********************
HttpResponse response = HttpContext.Current.Response;
response.Clear();
response.Charset = string.Empty;
string filename = "test.xls";
response.ContentType = "application/vnd.ms-excel";
response.AddHeader(Constant.CONTENT_DISPOSITION, "attachment;filename=\""
+ filename + "\"");
using (StringWriter sw = new StringWriter())
{
using (HtmlTextWriter htw = new HtmlTextWriter(sw))
{
System.Web.UI.WebControls.DataGrid dg = new
System.Web.UI.WebControls.DataGrid();
dg.Font.Name = "verdana";
dg.Font.Size = 10;
dg.HeaderStyle.Font.Bold = true;
dg.HeaderStyle.ForeColor = Color.SteelBlue;
dg.DataSource = DATASET;
dg.DataBind();
dg.RenderControl(htw);
response.Write(sw.ToString());
response.End();
}
}
**********************
Please suggest something...
Thanks.
--
You received this message because you are subscribed to the Google
Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML
Web Services,.NET Remoting" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en
or visit the group website at http://megasolutions.net
