C#导出Excel的示例详解

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Windows.Forms;
using System.Reflection;
 
namespace DMS
{
/// 

/// C#操作Excel类
/// 
class ExcelOperate
{
//法一
//public bool DataSetToExcel(DataSet dataSet, bool isShowExcle)
//{
//  DataTable dataTable = dataSet.Tables[0];
//  int rowNumber = dataTable.Rows.Count;
//  int columnNumber = dataTable.Columns.Count;
 
//  if (rowNumber == 0)
//  {
//    MessageBox.Show("没有任何数据可以导入到Excel文件！");
//    return false;
//  }
 
//  //建立Excel对象
//  Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();
//  excel.Application.Workbooks.Add(true);
//  excel.Visible = isShowExcle;//是否打开该Excel文件
 
//  //填充数据
//  for (int c = 0; c 
/// 将数据集中的数据导出到EXCEL文件
/// 
/// 输入数据集
/// 是否显示该EXCEL文件
/// 
public bool DataSetToExcel(DataSet dataSet, bool isShowExcle)
{
DataTable dataTable = dataSet.Tables[0];
int rowNumber = dataTable.Rows.Count;//不包括字段名
int columnNumber = dataTable.Columns.Count;
int colIndex = 0;
 
if (rowNumber == 0) 
{
return false;
}
 
//建立Excel对象 
Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();
//excel.Application.Workbooks.Add(true);
Microsoft.Office.Interop.Excel.Workbook workbook = excel.Workbooks.Add(Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet);
Microsoft.Office.Interop.Excel.Worksheet worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Worksheets[1];
excel.Visible = isShowExcle;
//Microsoft.Office.Interop.Excel.Worksheet worksheet = (Microsoft.Office.Interop.Excel.Worksheet)excel.Worksheets[1];
Microsoft.Office.Interop.Excel.Range range;
 
//生成字段名称 
foreach (DataColumn col in dataTable.Columns)
{
colIndex++;
excel.Cells[1, colIndex] = col.ColumnName;
}
 
object[,] objData = new object[rowNumber, columnNumber]; 
 
for (int r = 0; r 
/// 将数据集中的数据保存到EXCEL文件
/// 
/// 输入数据集
/// 保存EXCEL文件的绝对路径名
/// 是否打开EXCEL文件
/// 
public bool DataSetToExcel(DataSet dataSet, string fileName, bool isShowExcle)
{
DataTable dataTable = dataSet.Tables[0];
int rowNumber = dataTable.Rows.Count;//不包括字段名
int columnNumber = dataTable.Columns.Count;
int colIndex = 0;
 
if (rowNumber == 0) 
{
MessageBox.Show("没有任何数据可以导入到Excel文件！");
return false;
}
 
//建立Excel对象 
Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();
//excel.Application.Workbooks.Add(true);
Microsoft.Office.Interop.Excel.Workbook workbook = excel.Workbooks.Add(Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet);
Microsoft.Office.Interop.Excel.Worksheet worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Worksheets[1];
excel.Visible = false;
//Microsoft.Office.Interop.Excel.Worksheet worksheet = (Microsoft.Office.Interop.Excel.Worksheet)excel.Worksheets[1];
Microsoft.Office.Interop.Excel.Range range;
 
//生成字段名称 
foreach (DataColumn col in dataTable.Columns)
{
colIndex++;
excel.Cells[1, colIndex] = col.ColumnName;
}
 
object[,] objData = new object[rowNumber, columnNumber]; 
 
for (int r = 0; r