读取Excel中的内容，并写入txt文件中

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
using System.IO;

//**********************************************
//程式设计：殷庆飞
//设计时间：2007-8-10
//功能描述：读取Excel中的内容，并写入txt文件中
//修改人：
//修改描述：
//修改时间：
//修改描述：
//***********************************************

namespace 文件格式转换
{
public partial class Form1 : Form
{
OleDbConnection cn;
DataSet MyDataSet;

public Form1()
{
InitializeComponent();
}

//浏览按钮，选择要读取的EXCEL文件
private void btnFind_Click(object sender, EventArgs e)
{
txtName.Text = "";
OpenFileDialog openFile = new OpenFileDialog();
openFile.Filter = "Excel files (*.xls)|*.xls|All files (*.*)|*.*";
openFile.ShowDialog();
if (txtName.Text == string.Empty) txtName.Text = openFile.FileName;
}

//转换按钮，将Excel中的内容转换到文本文件中
private void btnConvert_Click(object sender, EventArgs e)
{
try
{
if (txtName.Text == string.Empty || txtConName.Text == string.Empty)//判断是否选择了要读到的Excel,是否输入了转换后的txt文件名称
{
MessageBox.Show("注意：选择要转换的Excel,并输入转换后的文本文件名称", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
cn = GetExcelConnection(txtName.Text.Trim(), false, 1);
if (cn != null)
{
cn.Open();
MyDataSet = ExecuteDataSet(cn);
if (MyDataSet != null)
{
string strPath = Application.StartupPath + @"\" + txtConName.Text.Trim() + ".txt";

if (File.Exists(strPath))
{
if (MessageBox.Show("文件：" + txtConName.Text + "已经存在！是否要删除？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information) == DialogResult.OK)
{
File.Delete(strPath);
}
else
{
MessageBox.Show("请输入其它的名称", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
txtConName.Focus();
return;
}
}

FileStream fs = new FileStream(strPath, FileMode.CreateNew, FileAccess.Write, FileShare.Read);
StreamWriter sw = new StreamWriter(fs);
string strContent = "";

for (int i = 0; i < MyDataSet.Tables.Count; i++)//Excel中sheet的个数
{
for (int row = 0; row < MyDataSet.Tables[i].Rows.Count; row++)
{
strContent = "";
for (int col = 0; col < MyDataSet.Tables[i].Columns.Count; col++)//sheet中列的个数
{
if (col == 1)
{
strContent += MyDataSet.Tables[i].Rows[row][col].ToString() + " ";
}
else
{
strContent += MyDataSet.Tables[i].Rows[row][col].ToString();
}
}
sw.WriteLine(strContent);
}
}
sw.Close();//关闭文件
MessageBox.Show("转换成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show("连接Excel发生错误", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
catch (Exception ex)
{
string strError = string.Format("错误：{0}", ex.Message);
MessageBox.Show(strError, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);

}
}

//退出
private void btnExit_Click(object sender, EventArgs e)
{
Application.Exit();
}

/**//// <summary>
/// 获取 Excel 连接对象。
/// </summary>
/// <param name="strFullPath">文件的完全路径</param>
/// <param name="isTreatedHeader">是否处理表头</param>
/// <param name="intIMEXMode">输入输出模式。1：设置输入为文本 Text 类型，通常使用该值。0/2：设置输入为 多数 Majority 类型，此设置极易导致数据缺失发生。</param>
/// <returns>Excel 连接对象</returns>
public static OleDbConnection GetExcelConnection( string strFullPath, bool isTreatedHeader, int intIMEXMode )
{
try
{
string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties='Excel 8.0;HDR={1};IMEX={2};'";
string strTreatedHeader = string.Empty;

if (isTreatedHeader) strTreatedHeader = "Yes";
else strTreatedHeader = "No";

connectionString = string.Format(connectionString, strFullPath, strTreatedHeader, intIMEXMode);

return new OleDbConnection(connectionString);
}
catch (Exception ex)
{
string strError = string.Format("错误：{0}", ex.Message);
MessageBox.Show(strError, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return null;
}

}

/**//// <summary>
/// 读取给定连接中全部或给定表的内容至 DataSet。
/// </summary>
/// <param name="cn">给定连接</param>
/// <param name="sheetNames">[可选参数]指定表名 的 sheet</param>
/// <returns>包含全部或给定 Sheet 数据的 DataSet</returns>
public static DataSet ExecuteDataSet( OleDbConnection cn, params string[] sheetNames )
{
try
{
DataSet ds = new DataSet();

DataTable schemaTable = cn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
string queryString;

// 带 $ 的表名
string fullTableName;

// 不带 $ 的表名
string realTableName;

OleDbDataAdapter odda = new OleDbDataAdapter();

foreach (DataRow dr in schemaTable.Rows)
{
fullTableName = dr["TABLE_NAME"].ToString();

realTableName = fullTableName.Remove(fullTableName.Length - 1, 1);

// 根据给定表导入
if (sheetNames.Length > 0)
{
// 若当前表不在给定表数组中，则不填充到数据集中。
if (Array.IndexOf(sheetNames, realTableName) < 0)
{
continue;
}
}

queryString = string.Format("SELECT * FROM [{0}]", fullTableName);

odda.SelectCommand = new OleDbCommand(queryString, cn);
odda.Fill(ds, realTableName);
}

return ds;
}
catch (Exception ex)
{
string strError = string.Format("错误：{0}", ex.Message);
MessageBox.Show(strError, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return null;
}
}

//打开关于框
private void btnAbout_Click(object sender, EventArgs e)
{
frmAbout frm = new frmAbout();
frm.ShowDialog();
}

}
}

可到这里去下载http://download.youkuaiyun.com/source/225379