Excal?=>EXCEL?问题叙述得不清楚大概的意思是DATATABLE输出到EXCEL的问题吧
换页是否是重新建立一个新SHEET的意思
网上很多搜一下会有答案
换页是否是重新建立一个新SHEET的意思
网上很多搜一下会有答案
解决方案 »
- 求同时upload多个文件到ftp 的方案
- Session不起作用,帮我看看,在线等,十分感谢
- DataGridView绑定DataTable的问题
- 下载的zipcsv格式文件解压缩出来只有1k
- C#二维数组,急求解
- 这样让自己的程序感知另外的进程(或程序)结束?
- c#如何写多个表同时操作的事物处理
- 给xml的一个节点添加属性的问题!
- 请问toolbar里面的button该如何设置他的快捷键?设置(&字母)没响应啊?
- 如何使窗体激活,而非窗体上的控件激活?
- 问问C#是否可以编写引擎
- 请问各位利用C#如何分块读写ORACLE里的BOLB从而提高效率(C\S),避免程序假死。。。谢谢各位,不是SQL SERVER 哦
///导出指定的Excel文件
public void ExportToExcel(DataSet ds, string strExcelFileName)
{
if (ds.Tables.Count == 0 || strExcelFileName == "") return;
doExport(ds, strExcelFileName);
}
///执行导出
private void doExport(DataSet ds, string strExcelFileName)
{
Excel.Application excel1 = new Excel.Application();
int rowIndex = 1;
int colIndex = 0;
excel1.Application.Workbooks.Add(true);
System.Data.DataTable table = ds.Tables[0];
foreach (DataColumn col in table.Columns)
{
colIndex++;
excel1.Cells[1, colIndex] = col.ColumnName;
} foreach (DataRow row in table.Rows)
{
rowIndex++;
colIndex = 0;
foreach (DataColumn col in table.Columns)
{
colIndex++;
excel1.Cells[rowIndex, colIndex] = row[col.ColumnName].ToString();
}
}
excel1.Visible = false;
excel1.ActiveWorkbook.SaveAs(strExcelFileName + ".XLS", Excel.XlFileFormat.xlExcel9795, null, null, false, false, Excel.XlSaveAsAccessMode.xlNoChange, null, null, null, null, null);
excel1.Quit();
excel1 = null;
GC.Collect();//垃圾回收
}
<authentication mode="Windows"/>
<identity impersonate="true"></identity>
</authentication>2.引用用命名空间:using using Microsoft.Office;在此之前需要添加引用,右击项目,添加引用,浏览C:\Program Files\Microsoft Office\OFFICE11找到excel.exe 确定3.调用方法string sql = "select top 20 uid as 用户编号,username as 用户名 from dnt_users";
ds = SqlHelp.ExecuteDataSet(SqlHelp.sqlCon, CommandType.Text, sql, null);
ExportToExcel(ds, Server.MapPath("excel/"+DateTime.Now.ToString("yyyyMMddhhssm")));
<authentication mode="Windows"/>
<identity impersonate="true"></identity>
</authentication>2.引用用命名空间:using using Microsoft.Office;在此之前需要添加引用,右击项目,添加引用,浏览C:\Program Files\Microsoft Office\OFFICE11找到excel.exe 确定3.调用方法string sql = "select uid as 用户编号,username as 用户名 from dnt_users";
ds = SqlHelp.ExecuteDataSet(SqlHelp.sqlCon, CommandType.Text, sql, null);
ExportToExcel(ds, Server.MapPath("excel/"+DateTime.Now.ToString("yyyyMMddhhssm")));
把你当前页和行数当作参数传递进来
string sql = "select uid as 用户编号,username as 用户名 from dnt_users WHERE ID BETWEEN '"+Nowpage+"'* '"+Pagerow+"' AND CAST( '"+Nowpage+"' AS INT)-1* Pagerow ";
ds = SqlHelp.ExecuteDataSet(SqlHelp.sqlCon, CommandType.Text, sql, null);
ExportToExcel(ds, Server.MapPath("excel/"+DateTime.Now.ToString("yyyyMMddhhssm")));
把你当前页和行数当作参数传递进来
string sql = "select uid as 用户编号,username as 用户名 from dnt_users WHERE ID BETWEEN "sql += " (CAST( '"+Nowpage+"' AS INT)-1 )* cast( '"+Pagerow+"' as int) and cast('"+Nowpage+"' as int)*cast( '"+Pagerow+"' as int) "; ds = SqlHelp.ExecuteDataSet(SqlHelp.sqlCon, CommandType.Text, sql, null);
ExportToExcel(ds, Server.MapPath("excel/"+DateTime.Now.ToString("yyyyMMddhhssm")));
也可用SqlDataAdapter Fill方法的重载public int Fill (
DataSet dataSet,
int startRecord,
int maxRecords,
string srcTable
)
实现分页
http://www.cnblogs.com/ayuan/archive/2006/07/26/459967.aspx