如何在csv中写入单独的列
本文关键字:单独 csv | 更新日期: 2023-09-27 18:02:45
我有一个html表,我试图写入csv文件。数组中的行以'n分隔,当我将其打印到csv文件时,除了一个问题外,一切正常。我希望在下一列中打印每个逗号值。不幸的是,它并没有这样做。我当前的代码将html表中每行中的所有值写入csv中的正确行。
try
{
string filepath = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);
StreamWriter sw = new StreamWriter(Environment.GetFolderPath(Environment.SpecialFolder.Desktop) + "''spreadsheet.csv", true);
foreach (var i in valueArray)
{
if (i.ToString() == "'n")
{
sw.Write("'n");
}
else
{
{
sw.Write(i.ToString());
sw.Write("'t");//my failed attempt
}
}
}
sw.Flush();
sw.Close();
saveOK = true;
}
数组中的值看起来像:"first,second,third,fourth, fifth,last,'n, first, ....,last,'n,"
在CSV中显示为:
column 1 column 2
row1 :firstsecondthirdfourthfithlast
row2 :firstsecond....... last
foreach (var i in valueArray)
{
if (i.ToString() == "'n")
{
sw.Write(sw.NewLine);
}
else
{
sw.Write(i.ToString() + ",");
}
}