Reading from Text File and Writing to Excel

minnietheminx — Mon, 01 Nov 2010 09:38:28 +0800

Hi, I'm trying to do this in C#.

this is my txt file

QUOTE

Levels item_lvl
{
#Extract this
Level1
{
lvlname = level1;
lvlnumber = 1;
lvltime = 5 secs;
}
Level2
{
lvlname = level2;
lvlnumber = 2;
lvltime = 10 secs;
}
}

The output to my Excel file is supposed to be this:

QUOTE

Item_Lvl

Level1 level1 1 5 secs
Level2 level2 2 10 secs

I've tried storing them in a 2D list but it doesn't work.

C# Read From Text File and display in excel

minnietheminx — Tue, 12 Oct 2010 15:44:35 +0800

my Text file looks something like this:

QUOTE

# created by min
Timestamp:

Levels (a, b, c)
{
data1 type1 a1, b1, c1,
data2 type2 a1, b2, c2,
data3 type3 a1, b3, c3,
data4 type4 a1, b4, c4,
}
line1
line2
line3
line4

I've read the file and stored it in a list using:

CODE

public void ReadFile()
{
string filename = filepathTxt.Text;
using (StreamReader sr = new StreamReader(filename))
{
string line;
while ((line = sr.ReadLine()) != null)
{
data.Add(line);
}
}
}

how do I just extract

QUOTE

data1 type1 a1, b1, c1,
data2 type2 a1, b2, c2,
data3 type3 a1, b3, c3,
data4 type4 a1, b4, c4,

and store them in an excel file in the exact same way? thanks

Lowyat.NET: Latest topics by minnietheminx

Reading from Text File and Writing to Excel

C# Read From Text File and display in excel