用c# 将txt转换为excel
我的txt如下：
39.4% 2013-07-03 15-38-59
35.8 2013-07-03 15-38-59
39.5% 2013-07-03 15-39-03
35.8 2013-07-03 15-39-03
39.7% 2013-07-03 15-39-06
35.7 2013-07-03 15-39-06
39.8% 2013-07-03 15-39-10
35.6 2013-07-03 15-39-10
......
想分为四列
39.4% 2013-07-03 15-38-59 35.8 2013-07-03 15-38-59
39.5% 2013-07-03 15-39-03 35.8 2013-07-03 15-39-03
39.7% 2013-07-03 15-39-06 35.7 2013-07-03 15-39-06
39.8% 2013-07-03 15-39-10 35.6 2013-07-03 15-39-10
........
请问该怎么做？最好用代码教我与给出具体实现。网上的小工具转化都做不到这种程度。 C# Excel txt
[解决办法]
就上转换格式这一部分的代码，生成到excel，自己百度下或者参考我的博客：
生成ｅｘｃｅｌ
string result = string.Empty;
StreamReader sr = new StreamReader("test.txt");
int line = 0;
while (sr.Peek() > 0)
{
line++;
result += sr.ReadLine() + " ";
if (line % 2 == 0)
{
result += "\r\n";
}
}
Console.WriteLine(result);
Private Function ToExcelFile(ByVal table As DataTable, ByVal excelFile As String, ByVal tableName As String) As Boolean
Try
Dim Connection As New OleDbConnection(String.Format("Provider = Microsoft.Jet.OLEDB.4.0; " & _
"Data Source = {0};Extended Properties=Excel 8.0", excelFile))
Dim MyDataAdapter = New OleDbDataAdapter("select * from " & tableName, Connection)
Dim m_CommandBuilder As New OleDbCommandBuilder(MyDataAdapter)
Dim MyDataSet As New DataSet()
Dim objCmd As New OleDbCommand
Dim ColumnList As New List(Of String)
Dim Columns As String
Connection.Open()
For Each col As DataColumn In Table.Columns
ColumnList.Add(col.ColumnName & " varchar")
Next
Columns = "Create TABLE " & tableName & "(" & String.Join(",", ColumnList.ToArray) & ")"
objCmd = New OleDbCommand(Columns, Connection)
objCmd.ExecuteNonQuery()
MyDataAdapter.Fill(MyDataSet, "Temp")
For i As Integer = 0 To table.Rows.Count - 1
MyDataSet.Tables("Temp").Rows.Add(table.Rows(i).ItemArray)
Next
MyDataAdapter.Update(MyDataSet, "Temp")
MyDataAdapter.Dispose()
MyDataSet.Dispose()
Connection.Close()
Catch ex As Exception
Return False
End Try
Return True
End Function
string result = string.Empty;
StreamReader sr = new StreamReader("C:\\1.txt");
List<ExcelTable> tablelist = new List<ExcelTable>();
ExcelTable model = null;
int line = 0;
while (sr.Peek() > 0)
{
string readlinestr = sr.ReadLine().Trim();
if (String.IsNullOrEmpty(readlinestr))
{
continue;
}
line++;
result += readlinestr + " ";
if (line % 2 == 0)
{
foreach (Match m in Regex.Matches(result, @"(?<percent>\d+\.\d+%)\s*(?<date1>\d{4}-\d{1,2}-\d{1,2}\s*\d{1,2}-\d{1,2}-\d{1,2})\s*(?<num>\d+\.\d+)\s*(?<date2>\d{4}-\d{1,2}-\d{1,2}\s*\d{1,2}-\d{1,2}-\d{1,2})"))
{
model = new ExcelTable();
model.field1 = m.Groups["percent"].Value;
model.field2 = m.Groups["date1"].Value;
model.field3 = m.Groups["num"].Value;
model.field4 = m.Groups["date2"].Value;
tablelist.Add(model);
}
result += "\r\n";
}
}
// Console.WriteLine(result);
foreach (ExcelTable m in tablelist)
{
Console.WriteLine(m.field1 + "\t" + m.field2 + "\t" + m.field3 + "\t" + m.field4);
}
