日期:2014-05-17  浏览次数:20412 次

excel输出时设置某列为文本格式
我想在excel输出时设置某列为文本格式,但现在用的是/t格式输出,该怎么操作excel目标输出文件?求大神指导。 

(有人说用‘’,单输出后‘’保留,还会改变excel格式)
FileStream fs = new FileStream(filePath, FileMode.Create, FileAccess.Write); 

StreamWriter sw = new StreamWriter(fs, System.Text.Encoding.GetEncoding("gb2312"));string column = aColumnNameArr;//表头格式字符串string l_column = column.Replace(";", "\t");//表头字符串数组string[] l_columnArr = column.Split(';'); 

//写入表头. 

sw.WriteLine(l_column);//写入内容.foreach (DataRow dr in aDt.Rows){string l_info = "";for (int i = 0; i < l_columnArr.Length; i++){if (i == l_columnArr.Length - 1){l_info += "'"+dr[i].ToString().Trim()+"'";}elsel_info += "'"+dr[i].ToString().Trim() + "'\t";}sw.WriteLine(l_info);} 

sw.Close(); fs.Close();

------解决方案--------------------
l_info += "'"+dr[i].ToString().Trim()+"'";}elsel_info += "'"+dr[i].ToString().Trim() + "'\t";
改成
if (i == l_columnArr.Length - 1){
l_info += "=\""+dr[i].ToString().Trim()+"\"";}
else
l_info += "=\""+dr[i].ToString().Trim() + ""\t";