写入Excel表代码,CSharp代码库,德仔网

代码语言

代码分类

【CSharp】写入Excel表

作者:nicoxml / 发布于2014/10/8/ 759

简单的Excel表操作函数，仅供参考，需要电脑安装Office，并引用Microsoft.Office.Interop.Excel.dll才能编译。


	using System;
	using System.Reflection;
	using System.IO;
	using Microsoft.Office.Interop.Excel;
	
	namespace Test
	{
	 class Program
	 {
	 public static bool WriteXls(string filename)
	 {
	 //启动Excel应用程序
	 Microsoft.Office.Interop.Excel.Application xls = new Microsoft.Office.Interop.Excel.Application();
	 _Workbook book = xls.Workbooks.Add(Missing.Value); //创建一张表，一张表可以包含多个sheet
	
	 //如果表已经存在，可以用下面的命令打开
	 //_Workbook book = xls.Workbooks.Open(filename, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
	
	 _Worksheet sheet;//定义sheet变量
	 xls.Visible = false;//设置Excel后台运行
	 xls.DisplayAlerts = false;//设置不显示确认修改提示
	
	 for (int i = 1; i < 4; i++)//循环创建并写入数据到sheet
	 {
	 try
	 {
	 sheet = (_Worksheet)book.Worksheets.get_Item(i);//获得第i个sheet，准备写入
	 }
	 catch (Exception ex)//不存在就增加一个sheet
	 {
	 sheet = (_Worksheet)book.Worksheets.Add(Missing.Value, book.Worksheets[book.Sheets.Count], 1, Missing.Value);
	 }
	 sheet.Name = "第" + i.ToString() + "页";//设置当前sheet的Name
	 for (int row = 1; row < 20; row++)//循环设置每个单元格的值
	 {
	 for (int offset = 1; offset < 10; offset++)
	 sheet.Cells[row, offset] = "( " + row.ToString() + "," + offset.ToString() + " )";
	 }
	 }
	 //将表另存为
	 book.SaveAs(filename, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, XlSaveAsAccessMode.xlNoChange, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
	
	 //如果表已经存在，直接用下面的命令保存即可
	 //book.Save();
	
	 book.Close(false, Missing.Value, Missing.Value);//关闭打开的表
	 xls.Quit();//Excel程序退出
	 //sheet,book,xls设置为null，防止内存泄露
	 sheet = null;
	 book = null;
	 xls = null;
	 GC.Collect();//系统回收资源
	 return true;
	 }
	 static void Main(string[] args)
	 {
	 string Current;
	 Current = Directory.GetCurrentDirectory();//获取当前根目录
	 WriteXls(Current + "\\test.xls");
	 }
	 }
	}

试试其它关键字

　读取　　 Excel表　

同语言下

可能有用的

nicoxml贡献的其它代码(5)