C#导出到EXCEL(worksheet)
来源:互联网 发布:国内硕士预科知乎 编辑:程序博客网 时间:2024/06/05 17:13
string saveFileName = @"e:/xx.xls";
List<ExcelInfo>list=daochuInfo.selExcel();//数据源
if (list.Count==0)
return;
bool fileSaved=false;
Excel.Application xlApp=new Excel.Application();
if(xlApp==null)
{
this.Page.RegisterStartupScript("script", "<script>alert('无法创建Excel对象,可能您的机子未安装Excel');</script>");
return;
}
Excel.Workbooks workbooks=xlApp.Workbooks;
Excel.Workbook workbook=workbooks.Add(Excel.XlWBATemplate.xlWBATWorksheet);
Excel.Worksheet worksheet=(Excel.Worksheet)workbook.Worksheets[1];//取得sheet1
//写入字段
worksheet.Cells[1,1]="B";
worksheet.Cells[1, 2] = "C";
worksheet.Cells[1, 3] = "D";
//写入数值
for(int r=0;r<list.Count;r++)
{
ExcelInfo excelInfo = (ExcelInfo)list[r];
worksheet.Cells[r+2,1]=excelInfo.B;
worksheet.Cells[r + 2, 2] = excelInfo.C;
worksheet.Cells[r + 2,3] = excelInfo.D;
}
worksheet.Columns.EntireColumn.AutoFit();//列宽自适应。
if(saveFileName!="")
{
try
{
workbook.Saved =true;
workbook.SaveCopyAs(saveFileName);
fileSaved=true;
}
catch(Exception ex)
{
fileSaved=false;
this.Page.RegisterStartupScript("script", "<script>alert('导出文件时出错,文件可能正被打开!');</script>");
}
}
else
{
fileSaved=false;
}
xlApp.Quit();
GC.Collect();//强行销毁
}
public static List<ExcelInfo> selExcel()
{
string str = "select b,c,d from tb_excel";
using (SqlConnection sqlCon = new SqlConnection(Database.conStr))
{
using (SqlCommand sqlCmd = new SqlCommand(str, sqlCon))
{
sqlCon.Open();
List<ExcelInfo> list = new List<ExcelInfo>();
SqlDataReader dr = sqlCmd.ExecuteReader();
while (dr.Read())
{
ExcelInfo excelInfo = new ExcelInfo();
excelInfo.B = dr[0].ToString();
excelInfo.C = dr[1].ToString();
excelInfo.D = dr[2].ToString();
list.Add(excelInfo);
}
return list;
}
}
}
- C#导出到EXCEL(worksheet)
- C#导出到EXCEL
- C#导出到EXCEL
- C#导出到EXCEL
- C#导出到EXCEL
- C#导出到excel
- c#导出到excel
- c# 导出到Excel
- C#导出到EXCEL
- C#导出到EXCEL
- C#导出到Excel
- c#导出到excel
- Delphi , C# 複製整個Excel WorkSheet 的方法
- C#下操作EXCEL--更改worksheet名
- [转]C#导出到EXCEL
- c#导出数据到Excel
- C#数据导出到Excel
- C#数据导出到Excel
- VC编译器-使用静态库
- 系统集群架构设计需考虑的几个因素
- 123
- 使用JMS接口接入WebSphere MQ消息
- .net中将excel导入sqlserver(worksheet专版)
- C#导出到EXCEL(worksheet)
- linux-socket详解与实例
- 微软的面试题及答案-超变态但是很经典(ZZ)
- QT学习笔记之五 HexSpinBox
- Linux文件和目录访问权限设置
- 我的第一篇学习日志-websphere class loader
- 如何修改标准屏幕的search help
- 基于J2EE体系的新一代ERP系统
- .NET框架