EXCEL IO

在.net中操作Excel表格大致有三种方式

1、利用com组件Microsoft Excel 11.0 object library（不同版本的Excel，类库不同，这是2003的）

有必要的话 using Excel

 

2、利用ado.net将Excel表格当作数据源

 

3、HMTL或XML的content-type

 

利用 Microsoft Excel 11.0 object library 导出数据

string[,] tb = new string[3,3] { { "name", "ybzou2008", "niki" }, { "sex", "man", "women" }, { "brithday", "2008-01-01", "2009-01-01" }}; int rows = tb.GetUpperBound(1); int columns = tb.GetUpperBound(0); //Excel应用程序 Excel.Application xlsApp = new Excel.Application(); //判断当前系统是否安装了相应的Excel if (xlsApp == null) { MessageBox.Show("你的机器没有安装Excel！"); } //工作簿 Excel.Workbooks wbs = xlsApp.Workbooks; //添加一个工作簿 Excel.Workbook wb = wbs.Add(Excel.XlWBATemplate.xlWBATWorksheet); //访问第一个工作表 Excel.Worksheet ws = (Excel.Worksheet)wb.Worksheets[1]; //设置Sheet名 ws.Name = "演示Sheet"; //输出标题 ws.Cells[1, 1] = "用户数据"; //输出字段 for (int i = 0; i <= columns; i++) ws.Cells[2, i + 1] = tb[i, 0]; //输出值 for (int i = 0; i <= columns; i++) for (int j = 1; j <= rows; j++) ws.Cells[2 + j, i + 1] = tb[i, j]; //设置单元格分类为文本 ws.get_Range(ws.Cells[1, 1], ws.Cells[rows + 2, columns + 1]).NumberFormatLocal = "@"; //设置列宽 ws.get_Range(ws.Cells[1, 1], ws.Cells[rows + 2, columns + 1]).ColumnWidth = 20; //设置居中 ws.get_Range(ws.Cells[1, 1], ws.Cells[rows + 2, columns + 1]).VerticalAlignment = Excel.XlVAlign.xlVAlignCenter; ws.get_Range(ws.Cells[1, 1], ws.Cells[rows + 2, columns + 1]).HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter; //设置表格线 ws.get_Range(ws.Cells[1, 1], ws.Cells[rows + 2, columns + 1]).Borders.LineStyle = 1; //设置标题字体 ws.get_Range(ws.Cells[1, 1], ws.Cells[1, 1]).Font.Size = 12; //合并首行单元格 ws.get_Range(ws.Cells[1, 1], ws.Cells[1, columns + 1]).MergeCells = true; //设置一二行粗体 ws.get_Range(ws.Cells[1, 1], ws.Cells[2, columns + 1]).Font.Bold = true; //保存到文件 wb.Saved = true; wb.SaveCopyAs(@"C:/123.xls");

 

参考资料:

 

Microsoft Office Development
http://msdn.microsoft.com/zh-cn/library/bb726434(en-us).aspx

 

Microsoft Office Development with Visual Studio
http://msdn.microsoft.com/en-us/library/aa188489(office.10).aspx

 

如何使用 Visual C# 2005 或 Visual C# .NET 向 Excel 工作簿传输数据
http://support.microsoft.com/kb/306023/zh-cn

 

CSDN技术中心 C#操作Excel（导入导出）
http://dev.csdn.net/article/72/72658.shtm

 

C#导出Excel的函数（可根据实际需要进行相应修改）
http://fengrengui.cnblogs.com/articles/397899.html

 

EXCel操作类
http://www.cnblogs.com/labliang/archive/2009/01/22/1379810.html

 

[C#] EXCEL导入导出类
http://hi.baidu.com/trip008/blog/item/1e1e88ec34bd1639269791b9.html

 

C# Excel 行高,列宽,合并单元格,单元格边框线,冻结
http://hi.baidu.com/yinzhenying/blog/item/65dbdec8c34da81e7f3e6f82.html

 

C#导出Excel总结
http://blog.csdn.net/jilm168/archive/2007/11/06/1869118.aspx

 

c# Excel 导出最新办法
http://blog.zol.com.cn/1068/article_1067621.html

 

C#导出Excel-Csv格式数据
http://www.cnblogs.com/star65225692/archive/2008/10/11/1308811.html

 

C# 对Excel操作与分析
http://www.cnblogs.com/JackWang/archive/2008/03/29/1128579.html