ansaurus

Question

Answer 1

A:

If you need to open the exported file in Excel, you could simply save a CSV file. The first line would have the column names the rest of the lines would be the data rows.

The following code will write a CSV file that can be opened in Excel. It will look just like your image.

// I've hard coded the file contents for simplicity. 
// You'll have to generate this in your code.
string csv = 
@", nvm, hg, ms, ls, none
fun1, 12, 22, 44, 5, 77
fun2, 2, 1, 77, 45, 23
fun3, 44, 11, 12, 22, 31";

File.WriteAllText("c:\test.csv", csv);

jrummell 2010-02-18 17:01:48

i can create an xls file but how can i write to the right column\row?i have title in the top of the table and in the side, and in the middle the information..

2010-02-18 17:09:26

I've updated my example to include the first 3 columns from your image (for brevity). Each line is a row and each comma separated value is a column value in that row. Hopefully that makes sense.

jrummell 2010-02-18 17:16:59

it's not working!!i tried this:StreamWriter sw = new StreamWriter(@"C:\cc.csv",true); sw.Write("testing");but the file stays empty.

2010-02-18 17:25:22

I would use File.WriteAllText("c:\test.txt", "testing content"). Its much simpler that dealing with StreamWriter (http://msdn.microsoft.com/en-us/library/ms143375.aspx).

jrummell 2010-02-18 17:28:03

it works, but it writting to the same place, and i can't use a comma here to pass the next collumn.

2010-02-18 17:36:47

If you're writing one line at a time, then you could use File.AppendAllText (http://msdn.microsoft.com/en-us/library/ms143356.aspx). It may be worth while to look over the other static File methods too: http://msdn.microsoft.com/en-us/library/system.io.file_methods.aspx

jrummell 2010-02-18 17:39:39

i just want to write the parameters to the right square!how can i acces a square??

2010-02-18 17:45:34

I'm assuming by square you mean table cell. I would not recommend trying to write once cell at a time. Just create one string with one row per line and then save that string to the file.

jrummell 2010-02-18 18:34:20

and how can i do it?i need each parameter to be in the right cell.how the string need to lool like, and how can i write it to the file?

2010-02-18 19:15:02

I updated my example to match your image exactly. Hope this helps.

jrummell 2010-02-18 19:31:42

it works!tanks!!!

2010-02-18 19:53:47

ansaurus

tags:

views:

answers:

create and write to table in c#

related questions