摘要：
public static void GridViewToExcel(GridView grd, HttpResponse response, string charset){ RemoveControls(grd); response.Clear(); response.Buffer = true; response.Charset = charset; response.AppendHeader("Content-Disposition", "attachment;filename=NewFileName.xls"); //文件名可以自定义 resp 阅读全文
摘要：
select * from [Sheet1$] where ...连接字符串：//Excel 2007string conn= "Provider=Microsoft.ACE.OLEDB.12.0;data source=" + fullpath+ ";Extended Properties='Excel 12.0;HDR=Yes;IMEX=1'";(数据连接组件安装: http://download.microsoft.com/download/7/0/3/703ffbcb-dc0c-4e19-b0da-1463960fdcdb/Acc 阅读全文