源代码:(导出Gridview中的值)
GridView GridView2 = new GridView();
GridView2.DataSource = (DataView)Session["dvlist9"];
GridView2.DataBind();
Response.Charset = "GB2312";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, System.Text.Encoding.UTF8));
Response.ContentType = FileType;
this.EnableViewState = false;
StringWriter tw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(tw);
GridView2.RenderControl(hw);
Response.Write(tw.ToString());
Response.End();
运行没问题,但是导出的Excel非真正的Excel(用.txt打开不是乱码),所如导出的Excel不能导入,怎样控制源代码,可以生成真正的Excel?(看过不少解答,但是没有源代码,只是偏方,不能根上治病,给个c#源代码吧,初学者)
GridView GridView2 = new GridView();
GridView2.DataSource = (DataView)Session["dvlist9"];
GridView2.DataBind();
Response.Charset = "GB2312";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, System.Text.Encoding.UTF8));
Response.ContentType = FileType;
this.EnableViewState = false;
StringWriter tw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(tw);
GridView2.RenderControl(hw);
Response.Write(tw.ToString());
Response.End();
运行没问题,但是导出的Excel非真正的Excel(用.txt打开不是乱码),所如导出的Excel不能导入,怎样控制源代码,可以生成真正的Excel?(看过不少解答,但是没有源代码,只是偏方,不能根上治病,给个c#源代码吧,初学者)
解决方案 »
- 请问C#中如何获得字符串的前2二个字符
- 高人指点 难难难也!!正则表达式 关于括号(可有可无)的匹配问题
- c# winform 如何实现登陆欢迎界面?
- 为何用server=192.168.2.164连接数据库出错
- 文字内容格式化后(色彩,字型等等),存入数据库和从数据库读取出,怎样保持格式不变?
- 一个button,右边紧挨者再加一个有个三角形标记的小按钮,小按钮单击时弹出菜单,主按钮单击时做另外的事情
- WinForm中,使用WebBrowser打开的某个页面具有多个form,如何提交第二个,第三个FORM
- bt文件的sha1码,是用哪部分算的,有人知道吗?
- 跪地恳求C#下的水晶报表的说明或帮助!否则实在不会用呀!
- 隐藏窗体
- 关于ListBox控件Item项重绘问题!
- 用c#做动态网页连接数据库显示的问题
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.IO;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace Public
{
public static class ToExcel
{
//将GridView数据导出至Excel中 public static string GridViewToExcel(GridView gd, string strPath, string strFileName)
{
new Help().CreateFolder(@"C:\reportforms");
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
gd.RenderControl(htw);
string strHtml = sw.ToString().Trim();
string ExcelFileName = strFileName;
string FilePhysicialPathName = strPath; //Request.PhysicalApplicationPath; //生成的Excel文件名 string objectExcelFileName = Path.Combine(FilePhysicialPathName, ExcelFileName);
if (File.Exists(objectExcelFileName))
{
File.Delete(objectExcelFileName);
}
FileStream fs = new FileStream(objectExcelFileName, FileMode.Create);
BinaryWriter bw = new BinaryWriter(fs, Encoding.GetEncoding("GB18030"));
bw.Write(strHtml);
bw.Close();
fs.Close();
return "";
}
}
}
你去掉就行了,我用的是VS2008.new Help().CreateFolder(@"C:\reportforms");
是我写的一个类,就是如果没该文件夹就创建,要是有的话就不动。你不要也可以