如何把文本文档(.txt)内容变到Excel里面? 想用C#编写以后小程序(小弟刚刚入手C#),把文本文档里某些内容 转去 EXCEL里面。网上搜索了不少帖子,还是不会太会。所以发帖求助,希望可以给code参考一下。谢谢了! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 你没说清楚问题,如果是将TXT内容写入某一单元可以使用Rang("a1")="asdfgh"样式或cells(row,colunms)="asdfg“更多参考:http://bingning.net/VB/SOURCE/index.html excel 格式提供一下啊 ,主要就是先读文本文档内容,然后把你要的截出来,按一定样式导出EXCEL呗, 数据集应该可以用READXML的方法吧,忘了 读取txt打开excel按照你的要求往对应的cell里面放东西 /// <summary> /// 写人excel文件内容 /// </summary> /// <param name="ExcelFileName"> excel文件名</param> /// <param name="Sheets">工作薄名</param> /// <param name="dataTable">要写入的数据表</param> public void ExportToExcel(string ExcelFileName, string Sheets, DataTable dataTable) { if (!File.Exists(ExcelFileName)) { return; } string strConn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + ExcelFileName + ";Extended Properties=Excel 8.0;"; OleDbConnection conn = new OleDbConnection(strConn); try { conn.Open(); } catch { return; } OleDbCommand cmd = new OleDbCommand(); cmd.Connection = conn; string strSql = "insert into [" + Sheets + "$] ("; for (int i = 0; i < dataTable.Columns.Count; i++) { if (i != 0) { strSql = strSql + ","; } strSql = strSql + "a" + i.ToString(); } strSql = strSql + ") values("; try { string strsql0 = strSql; for (int ii = 0; ii < dataTable.Columns.Count; ii++) { if (ii != 0) { strsql0 = strsql0 + ","; } strsql0 = strsql0 + "'" + dataTable.Columns[ii].ToString() + "'"; } strsql0 = strsql0 + ")"; cmd.CommandText = strsql0; cmd.ExecuteNonQuery(); for (int i = 0; i < dataTable.Rows.Count; i++) { string strsql = strSql; for (int ii = 0; ii < dataTable.Columns.Count; ii++) { if (ii != 0) { strsql = strsql + ","; } strsql = strsql + "'" + dataTable.Rows[i][ii].ToString() + "'"; } strsql = strsql + ")"; cmd.CommandText = strsql; cmd.ExecuteNonQuery(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } conn.Close(); }这个也许对你有帮助 直接把.txt文件改成.cvs文件,用excel打开就可以了! string path = @"D:\Test.txt";string content="";if (File.Exists(path)){ content = File.ReadAllText(path , Encoding.GetEncoding("gb2312")); } ExcelApplication excel = new ExcelApplication(); try { excel.Visible = false; excel.Workbooks.Add(Missing.Value); Worksheet sheet = (Worksheet)excel.ActiveSheet; Range range = null; range = sheet.get_Range("A1", Missing.Value); range.Value2 = strContent; sheet.SaveAs(Application.StartupPath + "\a.xls", Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value); excel.ActiveWorkbook.Close(false, null, null); } catch (Exception ex) { } finally { excel.Quit(); excel = null; } excel 其实本身就是com组件可以 引用excel。exe 然后用就行了http://www.thewebhappy.com 没太明白你的意思,但可以把文本文件与 excel 都做成数据源来操作。将文本文件的数据内容填充到 excel 中。 请教关于C#分屏管理 才接触C#不久, 如何做一个自动登录MSN的程序? 如何使用一个类中的变量在另一个类中引用 ?? 表格布局问题,高手帮帮忙 关于.net中显示数据源的问题 sos 字符串转int32 求助:Win8语音库剥离解决方案 C++的sdk怎么封装成C# C#怎样生成固定文章格式word文档 求一个简单的正则表达式 如何在屏幕输出字幕,像酷狗音乐那样? c#中 string类的字符数统计
打开excel
按照你的要求往对应的cell里面放东西
/// 写人excel文件内容
/// </summary>
/// <param name="ExcelFileName"> excel文件名</param>
/// <param name="Sheets">工作薄名</param>
/// <param name="dataTable">要写入的数据表</param>
public void ExportToExcel(string ExcelFileName, string Sheets, DataTable dataTable)
{
if (!File.Exists(ExcelFileName))
{
return;
}
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + ExcelFileName + ";Extended Properties=Excel 8.0;";
OleDbConnection conn = new OleDbConnection(strConn);
try
{
conn.Open();
}
catch
{
return;
}
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = conn;
string strSql = "insert into [" + Sheets + "$] (";
for (int i = 0; i < dataTable.Columns.Count; i++)
{
if (i != 0)
{
strSql = strSql + ",";
}
strSql = strSql + "a" + i.ToString();
}
strSql = strSql + ") values(";
try
{
string strsql0 = strSql;
for (int ii = 0; ii < dataTable.Columns.Count; ii++)
{
if (ii != 0)
{
strsql0 = strsql0 + ",";
}
strsql0 = strsql0 + "'" + dataTable.Columns[ii].ToString() + "'";
}
strsql0 = strsql0 + ")";
cmd.CommandText = strsql0;
cmd.ExecuteNonQuery();
for (int i = 0; i < dataTable.Rows.Count; i++)
{
string strsql = strSql;
for (int ii = 0; ii < dataTable.Columns.Count; ii++)
{
if (ii != 0)
{
strsql = strsql + ",";
}
strsql = strsql + "'" + dataTable.Rows[i][ii].ToString() + "'";
}
strsql = strsql + ")";
cmd.CommandText = strsql;
cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
conn.Close();
}这个也许对你有帮助
string content="";
if (File.Exists(path))
{
content = File.ReadAllText(path , Encoding.GetEncoding("gb2312"));
}
ExcelApplication excel = new ExcelApplication();
try
{
excel.Visible = false;
excel.Workbooks.Add(Missing.Value);
Worksheet sheet = (Worksheet)excel.ActiveSheet; Range range = null;
range = sheet.get_Range("A1", Missing.Value);
range.Value2 = strContent;
sheet.SaveAs(Application.StartupPath + "\a.xls", Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value); excel.ActiveWorkbook.Close(false, null, null);
}
catch (Exception ex)
{
}
finally
{
excel.Quit();
excel = null;
}
http://www.thewebhappy.com