bs数据库数据导出数据到excel问题?由于数据量很大。而且是多个数据源。比较耗费时间。想找个高效的方法。用isapi写个导出数据到excel文件。请各位大虾帮帮忙。谢谢只要解决问题,分数。我可以再开贴加。
解决方案 »
- 用fckeditor 出现 了 这个 问题 ,一般 是怎么引起的 ?
- 返回的是table类型,但是还有一个输出参数,也要返回,怎么办?
- 帖子提交,转到一个新页面,提示帖子发布成功,我想用一个“返回”回到 刚发布帖子的页面,请问怎么实现
- 一个好郁闷的问题哦,验证控件失效了
- 如何在网页中播放 power point 文件(*.pps),就像播放 flash (*.swf) 一样 ?
- 如何在C#的函数中实现弹出提示框?
- asp.net 2.0中GridView中的LinkButton的CommandArgument怎样取得当前行的RowIndex?
- 在cs文件中使用vbscript中的msgbox語法問題
- 如何使ASP.NET页面在显示器上居中显示
- 用什么工具可以反编译ASP.NET的代码?
- dropdownlist默认值
- 复制Webform后gridview无法识别???
Dim j As Integer
Dim sqtjzhi As String = ""
'权限判断
If m01 = "7" Then '只有权限到社区的时候才提示要随访的人数
sqtjzhi = " and x.sq=" & m02 & " and jd='" + ljd + "'"
'sql = "select x.name,case x.H_bzid when 'wz_tjxx_zh_djb.aspx' then 'tj/wz_tjxx_zh_djb.aspx' when '../hebeitj/hb_tjxx_djb.aspx' then 'hebeitj/hb_tjxx_djb.aspx' when '../wsbxm/tjxx_hch.aspx' then 'wsbxm/tjxx_hch.aspx' end as H_bzid,d.presj ,d.nextsj,d.bz,d.jcid,d.Avgsbp,d.Avgdbp from ddsf d left join xyjcb x on d.jcid=x.id where d.nextsj<='" & Now.ToShortDateString.ToString & " ' and x.status=0 " & sqtjzhi & " order by d.nextsj"
sql = "select x.name,d.Avgsbp,d.Avgdbp,convert(varchar(10),d.presj,121) as presj ,d.nextsj from ddsf d left join xyjcb x on d.jcid=x.id where d.nextsj<='" & Today.AddDays(14).ToString & " ' and x.status=0 " & sqtjzhi & " " + strssrq + " order by d.nextsj" Dim adapter As New SqlDataAdapter(sql, con)
Dim ds As New DataSet
adapter.Fill(ds)
mydatagrid.DataSource = ds.Tables(0)
mydatagrid.DataBind()
Response.ContentType = "application/vnd.ms-excel"
Response.Charset = ""
Me.EnableViewState = False Dim objSW As New System.IO.StringWriter
Dim objHTW As New System.Web.UI.HtmlTextWriter(objSW)
mydatagrid.RenderControl(objHTW)
Response.Write(objSW.ToString)
Response.End()
'Response.AddHeader("content-disposition", "attachment;filename=myfile.xls")
End If
{
string FileName = DateTime.Today.ToString("yyyyMMdd") + "_ExportData_" + System.Guid.NewGuid().ToString().Substring(0, 5)+".xls";
if (Request.QueryString["id"] == null)
{
MyHelper.JavaScript.CloseCurrentForm();
return;
} DataTable dt = MyHelper.StoredProcedure.FillDataTable("ExportListByID",
new SqlParameter("@id", Request.QueryString["id"]));
Response.Clear();
Response.Buffer = true; Response.Charset = "GB2312";
Response.ContentType = "application/vnd.ms-excel";
Response.ContentEncoding = Encoding.GetEncoding("gb2312");
Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, Encoding.GetEncoding("gb2312")).ToString());
this.EnableViewState = false;
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
GridView gv = new GridView();
gv.DataSource = dt;
gv.DataBind();
gv.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}
刚好帮我测试一下别人的开源代码,纯二进制操作Excel
http://myxls.in2bits.org/
我试过还不错,就看大数据量了
不设font时,打开的Excel会有小提示
您能给我发一份吗?[email protected]
您说的这个执行效率可以吗?
这个找不到合并列。